Maison > Article > développement back-end > PHP遍历的有关问题?麻烦大家帮看一下
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="%5C%22/constest/constitutionreport/myreport_%22.%24arrayUserReportList%5B'reportCheckId'%5D.%22.html%5C%22" target='\"_blcnk\"'>查看报告</a> </td>"; echo "</tr>"; }