pg_fetch_array error

Question

This is my current PHP code:

$sql = 'SELECT * from comments where post_id_fk=$post_id';

$users = $db->prepare($sql);
$users->execute();

while($row = pg_fetch_array($users, 0, PGSQL_ASSOC))

For some reason, I keep getting the following error:

Warning: pg_fetch_array() expects parameter 1 to be resource, object given in /home/se212004/public_html/content.html on line 39`

The line number refers to the line with the while loop. I have tried to fix it several times, but I cannot get it to work.

You have an error in your query. Use pg_result_error() to see what it is. — John Conde
– John Conde, Commented Apr 13, 2013 at 21:10

tomor · Accepted Answer · 2013-04-13 22:24:52Z

1

You are using PDO for preparing and executing the statement, and I believe you should also use it for fetching the results. So, basically, you would have to do something like this:

$sql = 'SELECT * from comments where post_id_fk=$post_id';

$users = $db->prepare($sql);
$users->execute();

$results = $users->fetchAll();

Or you could do:

$sql = 'SELECT * from comments where post_id_fk=$post_id';

$users = $db->prepare($sql);
$users->execute();

while ($row = $users->fetch(PDO::FETCH_ASSOC)){
      // do something with each row
}

answered Apr 13, 2013 at 22:24

tomor

1,7652 gold badges16 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pg_fetch_array error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related