php - MySQLi中如何检查表是否存在？

Question

这就是我正在做的事情:

$mysqli = new mysqli($db_host,$db_user,$db_pass,$db_name);
$result = $mysqli->query("SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ".$db_name." AND table_name = users");
$nr = $result->num_rows; // 77 line
var_dump($nr);
$mysqli->close();

但是错误提示:

Notice: Trying to get property of non-object in test.php on line 77
NULL

Answer 1

您还可以使用此语句进行检查 SHOW TABLES LIKE 'tablename';