CODEWITHSUNDEEP
phpjquerypostgresql
Shadin
Shadin

Reputation: 1967

Error in Inserting Values into PostgreSQL table through php

I'm trying to insert received values into postgresql table using php. I can't figure out why this statement doesn't work

  $query = "INSERT INTO user_info (name, emailAddress, phoneNumber, jobDesc) VALUES ('" . $name . "," . $emailAddr . "," . $phoneNumber . "," . $jobDesc ."')";

I get this error:

Query failed: ERROR:  column "emailaddress" of relation "user_info" does not exist

However, I tried this one:

$query = "INSERT INTO user_info VALUES ('" . $name . "," . $emailAddr . "," . $phoneNumber . "," . $jobDesc ."')";

It works, but it inserts all values into first column!

I'm not sure what I'm missing here!

Upvotes: 0

Views: 175

Answers (1)

Rasclatt
Rasclatt

Reputation: 12505

I think you are missing a whole host of single quotes in your VALUES list...

$query = "INSERT INTO user_info (name, emailAddress, phoneNumber, jobDesc) VALUES ('" . $name . "','" . $emailAddr . "','" . $phoneNumber . "','" . $jobDesc ."')";

Upvotes: 1

Related Questions