PHP遍历的问题?麻烦大家帮看一下。
我有个方法从mysql中取出一组数据,可是用while,for,foreach遍历出来的数据都多了,麻烦各位给看一下
1:取结果的方法
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
function queryUserReport ( $userid ) {
$resUserReportList = "" ;
$queryUserReport = "Select reportId, userid, reportCheckId, email, createtime, constitutiontype From userreport Where userid = '".$userid."' " ;
//echo "query:".$queryConstiutContent."<br>";
$resUserReportList = $this->user_db->querySQL ( $queryUserReport ) ;
if ($resUserReportList){
$resUserReportList = $this->user_db->get_Array($resUserReportList);
//print_r($resConstiutContent);
return $resUserReportList ;
} else {
return $this->user_db->print_last_error(TRUE);
}
$this->user_db->Close() ;
}
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
function querySQL($sql){
$this->last_query=$sql;
$result=mysql_query($sql);
if (!$result){
$this->last_error=mysql_error();
return FALSE;
}else {
$this->row_count=mysql_num_rows($result);
return $result;
}
}
function get_Array($result){
if (!$result){
$this->last_error="Invalid resource identifier passed to get_Array() function.";
return FALSE;
}else {
$row=mysql_fetch_array($result);
if ($row==FALSE){
$this->last_error=mysql_error();
return FALSE;
}else {
return $row;
}
}
}
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
Array
(
[0] => 3
[reportId] => 3
[1] => 414
[userid] => 414
[2] => 201209021468
[reportCheckId] => 201209021468
[3] =>
[email] =>
[4] => 2012-02-09 11:30:54
[createtime] => 2012-02-09 11:30:54
[5] => 1
[constitutiontype] => 1
)
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
//获取数据
$arrayUserReportList = $dbConstituModel->queryUserReport($_SESSION['userid']);
while ( $arrayUserReportList = $arrayUserReportList ){
echo "<tr>";
echo "<td>".$arrayUserReportList['reportId']." </td>";
echo "<td>".$arrayUserReportList['createtime']." </td>";
echo "<td><a href=\"/constest/constitutionreport/myreport_".$arrayUserReportList['reportCheckId'].".html\" target=\"_blcnk\">查看报告</a> </td>";
echo "</tr>";
}
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号