Home >Backend Development >PHP Tutorial >PHP遍历的有关问题?麻烦大家帮看一下

PHP遍历的有关问题?麻烦大家帮看一下

WBOY
WBOYOriginal
2016-06-13 10:09:41788browse

PHP遍历的问题?麻烦大家帮看一下。
我有个方法从mysql中取出一组数据,可是用while,for,foreach遍历出来的数据都多了,麻烦各位给看一下
1:取结果的方法

PHP code
<!--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() ;                    }

2:引用mysql的类
PHP code
<!--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;            }        }    }

3:取出的结果
PHP code
<!--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)

4:页面获取数据代码
PHP code
<!--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>";                    }


------解决方案--------------------
mysql_fetch_array 改成用mysql_fetch_assoc()
------解决方案--------------------
$arrayUserReportList = $dbConstituModel->queryUserReport($_SESSION['userid']);

echo "";
echo "".$arrayUserReportList['reportId']." ";
echo "".$arrayUserReportList['createtime']." ";
echo " 查看报告 ";
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn