//$query mysqli_result //$resulttype int MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH. Defaults to MYSQLI_BOTH. //返回值 Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset. function fetch_array(/*mysqli_result*/ $query, $resulttype = MYSQLI_ASSOC) { //var_dump(!null); if(!$query || !($query instanceof mysqli_result)) return NULL; return $query- fetch_array($resulttype);// }
function data_seek($result,$offset) {
return $result- data_seek($offset);
}
function fetch_assoc($query) {
return $query- fetch_assoc();// 關聯數組 }
function fetch_row($query) { return $query- fetch_row();// 索引數組，數字0,1。eg。。。 }
function fetch_fields($query) { return $query- fetch_fields(); }
//$query string //$resultmode int //返回值 如果成功則返回 TRUE，失敗則返回 FALSE。 For SELECT, SHOW, DESCRIBE or EXPLAIN mysqli_query() will return a result object. public function query($sql ,$resultmode=MYSQLI_STORE_RESULT ) { if(MYSQL_OPEN_LOGS) {
function num_rows($query) { return $query- num_rows;
}
//返回值 int The number of fields from a result set. //也可以用另外一種方式 mysqliHelp- db- field_count返回。 function num_fields($query) { return $query- field_count; }
function free_result($query) { //all methods are equivalent; $query- free(); //$query- free_result(); //$query- close(); }
如果是MYSQLI_USE_RESULT，query以后得到mysqli_result對象后，執行data_seek會出錯，因為 mysqli_result::data_seek() [mysqli-result.data-seek]: Function cannot be used with MYSQL_USE_RESULT
//這里如果是MYSQLI_USE_RESULT，下面的$dbHelper- data_seek($query,10);就會出錯 $query=$dbHelper- query("select id,cateid,title from product limit 22",MYSQLI_STORE_RESULT ); //$query=$dbHelper- query("update product set createtime=UNIX_TIMESTAMP() limit 22");
//$query=$dbHelper- query("insert into `product`(`cateid`,`title`,`text`,`createtime`) values (2,'test','content',1284822691)"); //$query=$dbHelper- query("delete from `product` where id=1"); //$query=$dbHelper- query("replace into product(id,cateid,title,text,createtime) values(1,2,'this is demo','test',UNIX_TIMESTAMP())");
