php的mysql代码_PHP连接MYSQL(代码)

$db_host='hostname is database server ';

$db_database='database name';

$db_username='username';

$db_password='password';

$connection=mysql_connect($db_host,$db_username,$db_password);//连接到数据库

mysql_query("set names 'utf8'");//编码转化

if(!$connection){

die("could not connect to the database:".mysql_error());//诊断连接错误

}

$db_selecct=mysql_select_db($db_database);//选择数据库

if(!$db_selecct)

{

die("could not to the database".mysql_error());

}

$query="select * from msu ";//构建查询语句

$result=mysql_query($query);//执行查询

if(!$result)

{

die("could not to the database".mysql_error());

}

//array mysql_fetch_row(resource $result);

while($result_row=mysql_fetch_row(($result)))//取出结果并显示

{

$num=$result_row[0];

$age=$result_row[1];

$name=$result_row[2];

echo "

";

echo "

$num";

echo "

$age";

echo "

$name";

echo "

";

}

mysql_close($connection);//关闭连接

?>