<?php
try{
$pdo=new pdo("mysql:host=121.32.236.151;dbname=db8051670;charset=gbk","db8051670","");
}
catch(PDOException $e){
ECHO $e->getMessage();
}
$pdo->query("set names gbk");
$sql="";
//执行SQL语句,返回$rows结果集
$rows=$pdo->query($sql);
$num=$rows->rowCount();
echo $num;
//以fetchAll方式取出数据
$rt=$rows->fetchAll(PDO::FETCH_ASSOC) ;
for($i=0;$i<$num;$i++){
echo $rt[$i]["title"];
}
//以对象方式取出数据
while($rs=$rows->fetchObject()){
echo $rs->title."
";
}
//以fetch方式取出数据
$list=array();
while($rm=$rows->fetch()){
$list[]=$rm;
}
foreach($list as $vs){
echo $vs["title"];
}
?>