作者ob556 (^o^OoB)
看板PHP
标题[请益] PHP+postgreSQL
时间Mon Dec 31 15:50:58 2012
之前用Mysql+PHP都没问题，但这次改用postgresql就一直抓不到资料库的资料
以下是我的程式码：
$con = pg_connect("host=$hostname port=$port dbname=$database user=$username
password=$password") or die ("Could not connect to server\n");
// array for JSON response
$response = array();
//搜寻主选单项目
$query = "SELECT * FROM category";
$sql = pg_query($con,$query) or die("Cannot execute query!");
if (pg_num_rows($sql) > 0) {
// looping through all results
// subcategories node
$response["categories"] = array();
while ($row = pg_fetch_array($sql)) {
// temp user array
$category = array();
$category["category_ID"] = $row["category_ID"];
$category["category_name"] = $row["category_name"];
// push single subcategory into final response array
array_push($response["categories"], $category);
}
// success
$response["success"] = 1;
// echoing JSON response
echo json_encode($response);
} else {
// no category found
$response["success"] = 0;
$response["message"] = "No subcategory found";
// echo no users JSON
echo json_encode($response);
}
结果每次连结到PHP都出现"Cannot execute query!"
我有把$query的内容直接放到phppgadmin里面用SQL查询，是没问题的
所以一直搞不清楚问题到底出在哪
希望有好心人能教教我><
谢谢!!!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.160.170.250
1F：推 plover:权限? 01/01 01:57
2F：→ ob556:如果是权限问题 应该会跑出"Could not connect to serve"?? 01/01 18:18
3F：→ ob556:还是有可能是我进去资料库但没有权限取出资料? 01/01 18:19
4F：推 alpe:看看 pg_hda.conf 里面有啥 01/02 20:51