SQLite PHP PDO delete all rows in table

Asked Oct 15 '14 at 02:42

Active Oct 15 '14 at 02:42

Viewed 22 times

For some reason this throws a PDOException.

$stmt = $db->prepare('DELETE FROM ?');
$stmt->execute([$table]);

The error I get is "General error: 1 near "?": syntax error". I echoed $table right before prepare and it shows an existing table name.

I initialized $db like this.

 $db = new PDO("sqlite:my.db");
 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);

I'm using PHP 5.4.4.

asked Oct 15 '14 at 02:42

425nesp

4

In prepared statements you can't use variables for anything that's a SQL identifier, like a table name or a column name. – Oct 15 '14 at 02:44
@MikeW, Not only for MySQL, but for all databases – Marcio Mazzucato Oct 15 '14 at 02:45
@Marcio - yes of course. It's about the fourth time I answered this today. I think I'm getting sleepy... – Oct 15 '14 at 02:46
You can do `$table = "table_name";` then `DELETE FROM $table` but you can't use `?` or `:table`. – Funk Forty Niner Oct 15 '14 at 02:47

0 Answers0