This question already has an answer here:
when I run the following:
$pdo = new PDO('sqlite:/path/to/database.db');
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $pdo->prepare('CREATE TABLE IF NOT EXISTS :user (id INTEGER PRIMARY KEY AUTOINCREMENT, time INTEGER NOT NULL, ping TEXT NOT NULL);');
$user = "me";
$stmt->execute(array('user' => $user));
I get the following error, referencing the :user part of the SQL:
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 near ":user": syntax error in /datasql.php:21 Stack trace: #0 /datasql.php(21): PDO->prepare('CREATE TABLE IF...') #1 {main} thrown in /datasql.php on line 21
I can't find anything wrong with the SQL and if I run the command without the variable insertion, it runs fine.
What is causing this error? Thanks ahead!
</div>