This article mainly introduces the method of PHP detecting the existence of mysql table. It summarizes and analyzes in the form of examples how PHP uses pdo connection and mysql function to realize the method of judging the existence of mysql table. Friends in need can refer to it
The example of this article describes the method of PHP detecting whether the mysql table exists. Share it with everyone for your reference, the details are as follows:
pdo:
<?php
$dsn = 'mysql:dbname=test;host=127.0.0.1';
$user = 'root';
$password = '';
try {
$pdo = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
die("数据库连接失败".$e->getMessage());
}
$table = 'cy_news';
//判断表是否存在
$result = $pdo->query("SHOW TABLES LIKE '". $table."'");
$row = $result->fetchAll();
if('1' == count($row)){
echo "Table exists";
} else {
echo "Table does not exist";
}
?>mysql:
<?php
$con = mysql_connect("localhost","root","");
mysql_select_db("php_cms", $con);
$table = 'cy_news';
if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '". $table."'"))==1) {
echo "Table exists";
} else {
echo "Table does not exist";
}
?>The above is the detailed content of Summary of methods to use php to query whether a mysql table exists. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
