douqie1884 2018-01-31 02:40
浏览 71
已采纳

如何在datatables中连接postgresql?

i had created and connected datatables to postgresql.

this is my connection code. may i have two connection called pg_query, and how i can make a right code? i try for 2 days and still stuck

<?php
$conn = "host=localhost port=5432 dbname=test user=postgres password=password";
$connection = pg_connect($conn);
if (!$connection) {
print("failed");
exit;
}
else print("Connection Success");
?>

this is my datatables code

<?php
include_once("connection.php");

$params = $columns = $totalRecords = $data = array();

$params = $_REQUEST;

$columns = array( 
    0 =>'id',
    1 =>'employee_name', 
    2 => 'employee_salary',
    3 => 'employee_age'
);

$where = $sqlTot = $sqlRec = "";

$sql = "SELECT * FROM employee ORDER BY employee_name";
$sqlTot .= $sql;
$sqlRec .= $sql;


$sqlRec .=  "ORDER BY employee_name";

$queryTot = pg_query($conn, $sqlTot)or die("database error:");

$totalRecords = pg_num_rows($queryTot);

$queryRecords = pg_query($conn, $sqlRec) or die("error to fetch employees data");

while( $row = pg_fetch_row($queryRecords) ) { 
    $data[] = $row;
}   

$json_data = array(
    "draw"            => 1,   
    "recordsTotal"    => intval( $totalRecords ),  
    "recordsFiltered" => intval($totalRecords),
    "data"            => $data  
);

echo json_encode($json_data);  

print_r ($json_data);
?>

But, i'm getting error enter image description here

  • 写回答

1条回答 默认 最新

  • dougan4884 2018-01-31 02:49
    关注

    First parameter to pg_query should be connection you get from pg_connect. What you actually pass is variable $conn where you have string with connection specification (username etc).

    To fix your problem, instead of $conn use variable $connection where you store actual connection returned by pg_connect on line:

    $connection = pg_connect($conn);
    

    So for example instead of:

    $queryTot = pg_query($conn, $sqlTot)or die("database error:");
    

    there should be:

    $queryTot = pg_query($connection, $sqlTot)or die("database error:");
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥60 优博讯DT50高通安卓11系统刷完机自动进去fastboot模式
  • ¥15 minist数字识别
  • ¥15 在安装gym库的pygame时遇到问题,不知道如何解决
  • ¥20 uniapp中的webview 使用的是本地的vue页面,在模拟器上显示无法打开
  • ¥15 网上下载的3DMAX模型,不显示贴图怎么办
  • ¥15 关于#stm32#的问题:寻找一块开发版,作为智能化割草机的控制模块和树莓派主板相连,要求:最低可控制 3 个电机(两个驱动电机,1 个割草电机),其次可以与树莓派主板相连电机照片如下:
  • ¥15 Mac(标签-IDE|关键词-File) idea
  • ¥15 潜在扩散模型的Unet特征提取
  • ¥15 iscsi服务无法访问,如何解决?
  • ¥15 感应式传感器制作的感应式讯响器