时间:2021-07-01 10:21:17 帮助过:17人阅读
function queryUserReport ( $userid ) { $resUserReportList = "" ; $queryUserReport = "Select reportId, userid, reportCheckId, email, createtime, constitutiontype From userreport Where userid = '".$userid."' " ; //echo "query:".$queryConstiutContent."
"; $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() ; }
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; } } }
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 )
//获取数据 $arrayUserReportList = $dbConstituModel->queryUserReport($_SESSION['userid']); while ( $arrayUserReportList = $arrayUserReportList ){ echo ""; echo " "; }".$arrayUserReportList['reportId']." "; echo "".$arrayUserReportList['createtime']." "; echo "查看报告 "; echo "