$db=@mysqli_connect('localhost','root','password','database'); //链接数据库

$sql = "show tables like 'table'"; //查询table表格

$re = mysqli_query($db,$sql); //执行SQL

//判断表是否存在

if(mysqli_num_rows($re)){ 

echo "存在";

}else{

echo "不存在";

}