How to add a php variable to a postgres query?

Question

I want to create a table by the name of the number that user creates. So what I wrote as the Postgres query is

$sql = 'CREATE TABLE '.$rNumber.'_Bus_Stops(
                id serial primary key,
                name character varying,
                x double precision,
                y double precision
                );';

I'm getting this error.

Warning: pg_query(): Query failed: ERROR: syntax error at or near "11" LINE 1: CREATE TABLE 11_Bus_Stops( ^ in C:\wamp\www\cdap4\route1.php on line 138

Tried the same with double quotes as well. It does not work. Can someone help? It works totally fine if I remove $rNumber

Are you getting any errors? Show us some more code to support it does not work — Thamilhan
– Thamilhan, Commented Sep 14, 2016 at 6:10
Query need be like this:-$sql = "CREATE TABLE ".$rNumber."_Bus_Stops ( id int NOT NULL, name char(50) NOT NULL,x double,y double,CONSTRAINT ".$rNumber."_Bus_Stops PRIMARY KEY (id) );"; — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Sep 14, 2016 at 6:16

Laurenz Albe · Accepted Answer · 2016-09-14 07:38:03Z

1

Since the table name starts with a digit, it has to be a quoted identifier (an identifier surrounded with double quotes):

$sql = 'CREATE TABLE "'.$rNumber.'_Bus_Stops" (

answered Sep 14, 2016 at 7:38

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

How to add a php variable to a postgres query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related