PDO query with variable and string concatenated as table name

Question

I have this query

$prefix = 'de_';
    $sql = "INSERT INTO $prefix.request_products (created_at, request_id) VALUES (NOW(), :request_id)";

Which would be working, but php or PDO (or both) are writing the dot within the query, the table name is de_request_products but the query is build as de_.request_products.

If I just use a space between $prefix and the string PDO throws an error.

Is there any other possibility of how to concatenate the string and the variable within the query, or is the only way to build it like this:

$prefix = 'de_';
$table = 'request_products';
$concat = $prefix.$table;
$sql = INSERT INTO $concat ...

Try "INSERT INTO ".$prefix."request_products .... or "INSERT INTO {$prefix}request_products .... — Eugen
– Eugen, Commented Dec 27, 2014 at 23:00

Markus · Accepted Answer · 2014-12-27 22:51:38Z

2

Use ${variable} syntax:

$sql = "INSERT INTO ${prefix}request_products (created_at, request_id) VALUES (NOW(), :request_id)";

answered Dec 27, 2014 at 22:51

Markus

5,8276 gold badges51 silver badges65 bronze badges

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

Comments

ptrk · Accepted Answer · 2014-12-27 22:56:11Z

1

The manual here: http://php.net/manual/pl/language.types.string.php says: "Enclose the variable name in curly braces to explicitly specify the end of the name." So this should make you happy:

$prefix = 'de_';
$sql = "INSERT INTO ${prefix}request_products (created_at, request_id) VALUES (NOW(), :request_id)";

answered Dec 27, 2014 at 22:56

ptrk

1,8401 gold badge19 silver badges24 bronze badges

Collectives™ on Stack Overflow

PDO query with variable and string concatenated as table name

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related