PHP, Postgres help using RETURNING

Question

I think I understand how PostgreSQL and RETURNING works - I've found many, many resources. If I'm catching on, it would look something like

"INSERT INTO table (column2, column3) VALUES ('value1', 'value2') RETURNING id;"

However, I can't find anything that helps me access this via PHP. When I thought I figured it out, I tried

$new_id = pg_query($dbc, "INSERT INTO table (column2, column3) ".
"VALUES ('value1', 'value2') RETURNING id;");
return $new_id;

But it returns NULL. I also tried executing and declaring the variable separately with one query. After looking for hours for the solution, I've settled on a max(id) SELECT statement/function, but it's still bothering me. Any help is greatly appreciated.

I'm using Postgres 8.4 and PHP 5.3.

Are you looking for the last inserted ID? If so, maybe this will help: stackoverflow.com/questions/2944297/… — Jason Swett
– Jason Swett, Commented Oct 25, 2012 at 14:26
I understand how to return the last inserted ID - several different ways, in fact. I want to know how to use the returned ID in a PHP variable. — regan_leah
– regan_leah, Commented Oct 25, 2012 at 14:29

greg · Accepted Answer · 2017-05-17 10:23:33Z

23

$new_id does not contain the id but it is a resource descriptor. You need to fetch the data from it as the query would be a SELECT, with pg_fetch_array($new_id) by example.

The RETURNING clause of PostgreSQL projects any fields of the inserted or modified rows ie INSERT|UPDATE … RETURNING id, field1, field2.

edited May 17, 2017 at 10:23

answered Oct 25, 2012 at 14:34

greg

3,5351 gold badge27 silver badges35 bronze badges

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

3 Comments

regan_leah Over a year ago

So, $resource = pg_query(...); $new_id = pg_fetch_array($resource); ?

Kouber Saparev Over a year ago

Actually, as the function returns an array and you need the first (and only) value of it: list($new_id) = pg_fetch_row($resource);

regan_leah Over a year ago

In conclusion, $query = pg_query("INSERT ... RETURNING id"); $row = pg_fetch_row($query); $new_id = $row['0']; !!! Thanks!

Collectives™ on Stack Overflow

PHP, Postgres help using RETURNING

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related