[請益] PHP+postgreSQL

[ob556 (^o^OoB)]

之前用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
推 plover:權限?
→ ob556:如果是權限問題 應該會跑出"Could not connect to serve"??
→ ob556:還是有可能是我進去資料庫但沒有權限取出資料?
推 alpe:看看 pg_hda.conf 裡面有啥