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

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

WBOY
Release: 2016-06-13 13:46:52
Original
938 people have browsed it

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

Copy after login

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;
            }
        }
    }

Copy after login

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
)


Copy after login

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>";
                    }

Copy after login


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

echo "";
echo "".$arrayUserReportList['reportId']." ";
echo "".$arrayUserReportList['createtime']." ";
echo " 查看报告 ";
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template