日期:2014-05-17 浏览次数:20549 次
<?php
$conn = mysql_connect('localhost', 'root', '');
if(!$conn)
{
echo "数据库连接失败".mysql_error();
exit();
}
echo "数据库连接成功</br>";
$sql = "show databases"; //查找某个库是否存在
print("$sql</br>");
$sql_return = mysql_query($sql);
echo "$sql_return </br>";
while($row = mysql_fetch_array($sql_return))
{
for($i = 0; $i != count($row); ++$i)
{
printf("%s", $row[0]);
echo "</br>";
}
}
//mysql_select_db('web', $conn);
?>
数据库连接成功 show databases Resource id #4 information_schema information_schema mysql mysql performance_schema performance_schema test test web web
数据库连接成功 show databases Resource id #4 Array ( [0] => information_schema [Database] => information_schema ) Array ( [0] => mysql [Database] => mysql ) Array ( [0] => performance_schema [Database] => performance_schema ) Array ( [0] => test [Database] => test ) Array ( [0] => web [Database] => web )
for($i = 0; $i != count($row); ++$i)
{
printf("%s", $row[0]);
echo "</br>";
}