代码:
<?php
$hostName = "localhost";
$usrName = "test";
$passWord = "123456";
$port = "3306";
$dbname = "xzjcy";
$content = mysqli_connect($hostName,$usrName,$passWord,$dbname,$port);
mysqli_set_charset($content,'utf-8');
if(!$content){
die("connect failed!:".mysqli_connect_error());
}else{
echo "connect success!";
}
$sql = "select * from mj_ad";
$result = $content->query($sql);
if ($result)
{
if ($result->num_rows>0)
{
while ($rows = $result->fetch_array()) {
echo "<BR>rows['id']:".$rows['id'];
echo "<BR>rows['title']:".$rows['title'];
echo "<BR>rows['pid']:".$rows['pid'];
}
}else{
echo "<BR>查询结果为空!";
}
}else{
echo "<BR>查询失败!";
}
mysqli_close($content);
?>