分类:数据库 发布时间:2017-05-30 10:39:44 阅读: 作者:郑祥景
<?php
/*
header("Content-type: text/html; charset=gbk");
//面向过程链接方法
$connect = mysqli_connect('localhost','root','','xian') or die('Unale to connect');
$zhuaquremenwenzhang = "select * from article where shuxing= 3 and typeid !='xinxi_tongzhi' order by aid desc;"; //抓取热门话题
$zhuaquremenwenzhangd = mysqli_query($connect,$zhuaquremenwenzhang);
$zhuaquremenwenzhangz = mysqli_fetch_array($zhuaquremenwenzhangd);
var_dump($zhuaquremenwenzhangz);
*/
?>
<?php
header("Content-type: text/html; charset=gbk");
//面向对象链接方法
$mysqli = new mysqli('localhost','root','','xian');
mysqli_query($mysqli,'set names utf8'); //设置输出格式为UTF-8
if (mysqli_connect_errno()){
//注意mysqli_connect_error()新特性
die('Unable to connect!'). mysqli_connect_error();
}
$zhuaquremenwenzhang = "select * from article where shuxing= 3 and typeid !='xinxi_tongzhi' order by aid desc;"; //抓取热门话题
$zhuaquremenwenzhangd = $mysqli->query($zhuaquremenwenzhang);
while($zhuaquremenwenzhangz = $zhuaquremenwenzhangd-> fetch_array()){
echo $row['ID'].':'.$row['content'].'<br>';
}
?>
编辑:郑祥景