MySQL check if a table exists without throwing an exception

by

Querying the information_schema database using prepared statement looks like the most reliable and secure solution.

$sql = "SELECT 1 FROM information_schema.tables 
        WHERE table_schema = database() AND table_name = ?";
$stmt =  $pdo->prepare($sql);
$stmt->execute([$tableName]);
$exists = (bool)$stmt->fetchColumn();

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDO get the last ID inserted
  3. PDO mysql: How to know if insert was successful
  4. Fetching single row, single column with PDO
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDO::PARAM for type decimal?
  7. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  8. which is better every user have a table or just a row [closed]
  9. Many-to-many relationships examples
  10. How can I use PDO to fetch a results array in PHP?
  11. How to upload images into MySQL database using PHP code
  12. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  13. Maximum execution time in phpMyadmin
  14. how safe are PDO prepared statements
  15. PHP PDO – Num Rows
  16. How to solve General error: 2006 MySQL server has gone away
  17. Mysql No connection could be made because the target machine actively refused it
  18. Calling stored procedure with Out parameter using PDO
  19. When *not* to use prepared statements?
  20. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  21. phpmyadmin automatic logout time
  22. Setting a connect timeout with PDO
  23. What is the best way to insert multiple rows in PHP PDO MYSQL?
  24. PDO MySQL: Insert multiple rows in one query
  25. How to bind LIKE values using the PDO extension?
  26. Fatal error: Call to undefined function mysqli_result()
  27. Laravel nested relationships
  28. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  29. PHP 7 RC3: How to install missing MySQL PDO
  30. PDO and MySQL ‘between’

Leave a Comment