How can I make the define the table name of an sql statement in php?

Asked Feb 16 '21 at 15:01

Active Feb 16 '21 at 15:01

Viewed 17 times

I'm trying to set the table name in my sql statement in PHP

$stmt = $pdo->prepare("SELECT count(*) FROM ?");
$stmt->execute([$table]);
$count = $stmt->fetchColumn();

with what i tried i get: Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation If you know any solution to pass the table name in php it'll be very helpful! thanks in advance!

asked Feb 16 '21 at 15:01

Theo Chazalon

You can't because you can't parameterize table names. Whether you even should is another question. You would have to use dynamic SQL, be careful, makes sure to quote the name, and don't take it from user input – Charlieface Feb 16 '21 at 15:05
ah! this is a tragedy of the maximum scale – Theo Chazalon Feb 16 '21 at 15:06
Thank you! i'll search what's dynamic sql – Theo Chazalon Feb 16 '21 at 15:07
1

Why do you need to vary the table name? Often this is a symptom of a flaw in the database design. – ADyson Feb 16 '21 at 16:11

How can I make the define the table name of an sql statement in php?

0 Answers0