How to write an Update query statement in PHP?

[Apollo6]

I have the following code snippet that I want to have update a specific record in a table via PHP... I keep getting the following error:
Fatal error: Call to undefined function: pq_query()

Any suggestions would be great.


if ($newpasswd == $renewpasswd) {
$query3 = "UPDATE emptable SET password='$newpasswd'
WHERE
(((user_id)='$user_id'))";

$result3 = pq_query ($connection,$query3)
or die("Error in query: $query3.
" . pg_last_error($connection));

 

[ceco]

this means that the php you are using is not with postgresql support enabled, if you are using a package from any kind of distribution you should install a package called php-pgsql or something like that, with the appropriate extension -> dep for debian, rpm for most of the other distros

after installing the package you should enable it in php.ini by adding
extension=pgsql.so
if you are compiling php by your self you can compile the module in the php with adding to ./configure --with-pgsql
for more options you check the documentation

second you should first use pg_connect() to connect to the DB and after that pg_query

 

[rycamor]

Of course pq_query() is an undefined function. That's because the function you need is pg_query(). ("g" not "q&quot

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[Apollo6]

Thanks for the help. I've corrected the "q"/"g" error and am using the following syntax which works.

if ($newpasswd == $renewpasswd) {
$update = pg_query($connection, "UPDATE emptable SET password='$newpasswd'
WHERE
(((user_id)='$user_id'))"
}