本文实例讲述了php检测mysql表是否存在的方法。分享给大家供大家参考,具体如下:
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"; } ?>
以上就是利用php查询mysql表是否存在的方法总结的详细内容,更多请关注二当家的素材网其它相关文章!
友情提示:垃圾评论一律封号 加我微信:826096331拉你进VIP群学习群