PHP 5.3.2 连接Mysql 数据库并查询表

<?php

//定义连接字符串
$server = "127.0.0.1";
$user = "root";
$password = "test";

//连接mysql
$con = mysql_connect ( $server, $user, $password, null, null );
if (! $con) {
die("Cound not connect :".mysql_errno(null));
}

//使用数据库
$database="pk";
mysql_select_db($database);
mysql_set_charset("gbk");

//查询数据表
$query="select idsite,name,main_url  from site";
$result=mysql_query($query);

//遍历数据集合
while($rs=mysql_fetch_array($result)){
echo $rs["idsite"]. "";
echo $rs["name"]. "";
echo $rs["main_url"]. "";
}

//关闭数据库连接
mysql_close($con);

echo "连接完成";