Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table `'user'` (id int);
show tables;
<?php
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
echo json_encode($pdo->query('show tables')->fetchAll(PDO::FETCH_ASSOC));
;
$query = "SELECT * FROM users `:userName`;";
$stmt = $pdo->prepare($query);
$stmt->bindValue(":userName", 'user');
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);