$server_name = "localhost";
$user_name = "root";
$user_password = "";
$database_name = "test";
$table_name = "aaa";
$lin = mysql_connect( $server_name ,$user_name,$user_password,$table_name);
if(!$lin) {
echo("数据库连接失败!");
}else {
echo('数据库连接成功!');
}
mysql_set_charset('utf8');
mysql_select_db('aaa');
$qq= "SELECT * FROM aaa";
$res = mysql_query($qq,$lin);
if($res) {
die("Valid result! ");
}
echo("\n");
echo('<table width="600" border = "1">');
echo('<th>号码</th><th>姓名</th><th>省份</th><th>粉丝量</th><th>电话号码</th>');
while($rows = mysqli_fetch_assoc($res))
{
echo('<tr>');
echo('<td>'.$rows['num'].'</td>');
echo('<td>'.$rows['name'].'</td>');
echo('<td>'.$rows['prince'].'</td>');
echo('<td>'.$rows['fans'].'</td>');
echo('<td>'.$rows['mobile'].'</td>');
echo('</tr>');
}
echo('</table>');
mysql_close($lin);
$user_name = "root";
$user_password = "";
$database_name = "test";
$table_name = "aaa";
$lin = mysql_connect( $server_name ,$user_name,$user_password,$table_name);
if(!$lin) {
echo("数据库连接失败!");
}else {
echo('数据库连接成功!');
}
mysql_set_charset('utf8');
mysql_select_db('aaa');
$qq= "SELECT * FROM aaa";
$res = mysql_query($qq,$lin);
if($res) {
die("Valid result! ");
}
echo("\n");
echo('<table width="600" border = "1">');
echo('<th>号码</th><th>姓名</th><th>省份</th><th>粉丝量</th><th>电话号码</th>');
while($rows = mysqli_fetch_assoc($res))
{
echo('<tr>');
echo('<td>'.$rows['num'].'</td>');
echo('<td>'.$rows['name'].'</td>');
echo('<td>'.$rows['prince'].'</td>');
echo('<td>'.$rows['fans'].'</td>');
echo('<td>'.$rows['mobile'].'</td>');
echo('</tr>');
}
echo('</table>');
mysql_close($lin);