Question

PHP编程 MYSQL中怎么判断某个数据表是否存在，要代码

Answer 1

判断数据库是否存在 因为mysql_select_db的返回值是FALSE 或TRUE因此mysql_connect($host,$user,$password);$dbname="db";if(!mysql_select_db($db)){echo "数据库不存在";//如果数据库不存在，那么你想做什么？mysql_query("CREATE DATABASES {$dbname}");}else{echo "数据库存在";}

Answer 2

<?php
$con = mysql_connect("localhost","$username","$password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("$datebase_name", $con);

$result = mysql_query("SELECT * FROM your_table");

while($row = mysql_fetch_array($result))
{ if(!$row){ echo "表不存在！"; } else{ echo "表存在！"; }
}

mysql_close($con);
?>