我有一个用AdodbConn从表中选择的函数,问题是如何将当前值与循环中的下一个值进行比较。因为我必须在当前值和下一个值之间推一个值。
public function list()
{
$errMsg = "";
$recPerPage = 15;
$currPage = 1;
$where = "";
$filter_user="";
// $user_level = 0[Admin] 1[user]
if(isset($_GET["pagenum"]))
$currPage = intval($_GET["pagenum"])+1;
if(isset($_GET["pagesize"]))
$recPerPage = intval($_GET["pagesize"]);
$this->load->library('AdodbConn');
$conn = $this->adodbconn->getOraConn("WF");
$this->load->helper('erp_wb_helper');
if(isset($_GET["filterscount"]))
$where = genJQWFilterSQL($this->initGrid());
$query="select NO_DOK ID,NO_DOK,JDOK
from TBTR_VIEW5
where TR like '".$this->session->userdata('TMP_KS')."'
and TK like'".$this->session->userdata('TMP_RT')."' ".
$where."
order by CREATED_DATE desc";
$arrParamData = array();
$rst=$conn->PageExecute($query,$recPerPage,$currPage,$arrParamData);
if($rst){
$total_rows = $this->adodbconn->gettotalrec($conn, $query, $arrParamData);
if($rst->recordCount()>0){
for($i=0;$irecordCount();$i++){
//Compare here current no_dok with next no_dok
$arrData[] = array(
'ID' => $rst->fields["ID"],
'NO_DOK' => $rst->fields["NO_DOK"],
'JDOK' => $rst->fields["JDOK"]
);
$rst->moveNext();
}
}else{
$total_rows = 0;
$arrData[] = array(
'ID' => "",
'NO_DOK' => "",
'JDOK' => ""
);
}
}else{
$total_rows = 0;
$arrData[] = array(
'ID' => "",
'NO_DOK' => "",
'JDOK' => ""
);
}
//$errMsg = $query;
$data[] = array(
'where' => $where,
'TotalRows' => $total_rows,
'Rows' => $arrData,
'ErrorMsg'=>$errMsg
);
print_r(json_encode($data,JSON_PRETTY_PRINT));
}
我试过几种方法,比如:
for($i=0;$irecordCount();$i++){
if($rst[$i]->fields["NO_DOK"]==1 && $rst[$i+1]->fields["NO_DOK"]==3){
//
}
}
但没用。