<?php
//_query执行SQL语句,并返回结果集
function _query($_sql) {
global $conn;//申明全局变量
if (!$_result = mysqli_query($conn,$_sql)) {
echo mysqli_error($conn);
exit('SQL执行失败');
}
//$_result = mysqli_query($conn,$_sql); //检查错误用
return $_result;
}
// _mysqli_list可以返回指定数据集的所有数据
function _mysqli_list($_result) {
return mysqli_fetch_array($_result,MYSQL_ASSOC);
}
//获取全部记录
function _get_all($sql) {
$result = _query($sql);
$rt = array();
while($row = _mysqli_list($result)) {
$rt[]=$row;
}
return $rt;
}
$sql="select * from php_small where big=2 order by px desc,id desc limit 4";
$arr=_get_all($sql);
foreach ($arr as $i=>$rs) :
$rs["id"];
endforeach ;
?>
05-16