PDO fetchALL command not returning data

Question

I am trying to return information from my database, but all I get is an empty array when I know the database table is not empty.

This is my code

$pdo_dbconn = new PDO("pgsql:host=localhost;dbname=null;user=null;password=null")
    or die ("Could not connect");

$sql = $pdo_dbconn->prepare("SELECT * FROM prsnl_codes;");
$sql->execute();
$array = $sql->fetchALL();

var_dump($array);

This is what the response is

array(0) {}

Can anyone tell me what is going on?

I don't know how pgsql works, but I would say you need to select a database. — Dharman, Jan 18 '20 at 09:19

score 0 · Accepted Answer · answered Aug 19 '20 at 22:23

0

I solved the issue, and all the code up there was correct. The problem I was having was permission on the database, which I resolved.

answered Aug 19 '20 at 22:23

rancper

35
6

PDO fetchALL command not returning data

1 Answers1