PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table `'test'` (id int); show tables;
Copy Clear
Copy Format Clear
<?php $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); echo json_encode($pdo->query('show tables')->fetchAll(PDO::FETCH_ASSOC)); ; $query = "SELECT * `:userName`;"; $stmt = $pdo->prepare($query); $stmt->bindValue(":userName", 'test'); $stmt->execute(); $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
Show:  
Copy Clear