//连接数据库
function dbConnect(){
$link=mysql_connect("121.32.236.151","db8051670","");
mysql_query("set names gb2312");
mysql_select_db("db8051670");
}
//执行SQL语句
function query($sql){
if($stmt=mysql_query($sql)){
return $stmt;
}else{
echo 'SQL操作失败:'.mysql_error();
}
}
//处理结果集中的多条数据
function fetchAll($sql){
if($stms=query($sql)){
$rs=array();
while($rows=mysql_fetch_array($stms,MYSQL_ASSOC)){
$rs[]=$rows;
}
}
return $rs;
}
//处理结果集中的单条数据
function fetchRow($sql){
if($stmt=query($sql)){
$row=mysql_fetch_array($stmt,MYSQL_ASSOC);
return $row;
}
}
dbConnect();
$sql="";
//输出单条数据数据
$rs=fetchRow($sql);
echo $rs['title'];
//输出多条数据数据
$data=fetchAll($sql);
foreach($data as $rs){
echo $rs["title"]."
";
}
?>