Error in Inserting Values into PostgreSQL table through php

Question

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 &quot;emailaddress&quot; of relation &quot;user_info&quot; 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!

Rasclatt · Accepted Answer · 2014-10-19 07:48:00Z

1

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 ."')";

edited Oct 19, 2014 at 7:48

answered Oct 19, 2014 at 7:43

Rasclatt

12.5k3 gold badges28 silver badges33 bronze badges

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

8 Comments

Rasclatt Over a year ago

Is emailAddress spelled correctly or even exists? It seems to be taking issue with that column.

Shadin Over a year ago

Yes, and its type is character varying. would that be the issue by any chance?

Shadin Over a year ago

I removed the email value then the same error appears with the next value "phoneNumber"

Rasclatt Over a year ago

Which SQL are you sending. You said you tried one with the columns and one without the columns? Are you doing this one:

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

?

Rasclatt Over a year ago

Also, what is special about the name column? It seems to be working. Is it set up differently?

|

Collectives™ on Stack Overflow

Error in Inserting Values into PostgreSQL table through php

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related