php - 如何使用 PHP 从 PostgreSQL 获取数据

Question

我无法使用 PHP 从 PostgreSQL 获取数据。每次我运行查询时，它都会返回 NULL。

我的查询:

$psql = new psql('localhost','database','user','password');

$psq = pg_query("SELECT * FROM students");
$result = pg_fetch_row($psq);
var_dump($result); 

Answer 1

您的数据库连接似乎有问题。尝试使用 pg_last_error() 来查看发生了什么。以下是一些示例:

<?php
    $dbhost = 'localhost';
    $dbname='database';
    $dbuser = 'user';
    $dbpass = 'password';

    $dbconn = pg_connect("host=$dbhost dbname=$dbname user=$dbuser password=$dbpass")
        or die('Could not connect: ' . pg_last_error());

    $query = 'SELECT * FROM students';
    $result = pg_query($query) or die('Error message: ' . pg_last_error());

    while ($row = pg_fetch_row($result)) {
        var_dump($row);
    }

    pg_free_result($result);
    pg_close($dbconn);
?>

还有 PDO:

<?php
    try {
        $dbhost = 'localhost';
        $dbname='database';
        $dbuser = 'user';
        $dbpass = 'password';

        $connection = new PDO("pgsql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);

        $sql = 'SELECT * FROM students';

        foreach ($connection->query($sql) as $row) {
            var_dump($row);
        }

        $connection = null;
    } catch (PDOException $e) {
        die("Error message: " . $e->getMessage());
    }
?>