【www.gdgbn.com--word】
$host = "localhost";
$user_name = "root";
$password = "admin";
$conn = mysql_connect($host,$user_name,$password);
if(!$conn)
{
die("数据库连接失败:
".mysql_error());
}
echo "数据库连接成功!继续操作...";
mysql_select_db("test");
$sql = "select id,name,city from users";
$result = mysql_query($sql);
if($result)
{
echo "sql语句:" . $sql . "
已经成功执行!";
$num = mysql_num_rows($result); //调用函数mysql_num_row()获得select语句查询结果的行数
echo "
该sql语句查询到".$num."www.111cn.net行数据";
}
if(mysql_close($conn))
{
echo "
........
";
echo "到数据库的连接已经成功关闭";
}