PHP ADORecordSet::MoveNext方法代码示例

 /**
  * @param ADORecordSet $rs
  * @return Model_WgmGoogleCse[]
  */
 private static function _getObjectsFromResult($rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $object = new Model_WgmGoogleCse();
         $object->id = $rs->fields['id'];
         $object->name = $rs->fields['name'];
         $object->url = $rs->fields['url'];
         $object->token = $rs->fields['token'];
         $objects[$object->id] = $object;
         $rs->MoveNext();
     }
     return $objects;
 }

 /**
  * Get next temporary stats record by load id.
  * @param $loadId string
  * @return mixed array or false if the end of
  * records is reached.
  */
 function getNextByLoadId($loadId)
 {
     if (!$this->_result || $this->_loadId != $loadId) {
         $this->_result = $this->_getGrouped($loadId);
         $this->_loadId = $loadId;
     }
     if ($this->_result->EOF) {
         return false;
     }
     $row = $this->_result->GetRowAssoc(false);
     $this->_result->MoveNext();
     return $row;
 }

/**
 * Retrieve the next row returned from a specific database query
 * @param bool|ADORecordSet $p_result Database Query Record Set to retrieve next result for.
 * @return array Database result
 */
function db_fetch_array(&$p_result)
{
    global $g_db, $g_db_type;
    if ($p_result->EOF) {
        return false;
    }
    # mysql obeys FETCH_MODE_BOTH, hence ->fields works, other drivers do not support this
    if ($g_db_type == 'mysql' || $g_db_type == 'odbc_mssql' || $g_db_type == 'mssqlnative') {
        $t_array = $p_result->fields;
        $p_result->MoveNext();
        return $t_array;
    } else {
        $t_row = $p_result->GetRowAssoc(false);
        static $t_array_result;
        static $t_array_fields;
        if ($t_array_result != $p_result) {
            // new query
            $t_array_result = $p_result;
            $t_array_fields = null;
        } else {
            if ($t_array_fields === null) {
                $p_result->MoveNext();
                return $t_row;
            }
        }
        $t_convert = false;
        $t_fieldcount = $p_result->FieldCount();
        for ($i = 0; $i < $t_fieldcount; $i++) {
            if (isset($t_array_fields[$i])) {
                $t_field = $t_array_fields[$i];
            } else {
                $t_field = $p_result->FetchField($i);
                $t_array_fields[$i] = $t_field;
            }
            switch ($t_field->type) {
                case 'bool':
                    switch ($t_row[$t_field->name]) {
                        case 'f':
                            $t_row[$t_field->name] = false;
                            break;
                        case 't':
                            $t_row[$t_field->name] = true;
                            break;
                    }
                    $t_convert = true;
                    break;
                default:
                    break;
            }
        }
        if ($t_convert == false) {
            $t_array_fields = null;
        }
        $p_result->MoveNext();
        return $t_row;
    }
}

 /**
  * @param ADORecordSet $rs
  * @return Model_WatcherMailFilter[]
  */
 private static function _getObjectsFromResult($rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $object = new Model_WatcherMailFilter();
         $object->id = $rs->fields['id'];
         $object->pos = $rs->fields['pos'];
         $object->name = $rs->fields['name'];
         $object->created = $rs->fields['created'];
         $object->is_disabled = intval($rs->fields['is_disabled']);
         $object->worker_id = intval($rs->fields['worker_id']);
         if (null != @($criteria_ser = $rs->fields['criteria_ser'])) {
             if (false === @($object->criteria = unserialize($criteria_ser))) {
                 $object->criteria = array();
             }
         }
         if (null != @($actions_ser = $rs->fields['actions_ser'])) {
             if (false === ($object->actions = unserialize($actions_ser))) {
                 $object->actions = array();
             }
         }
         $objects[$object->id] = $object;
         $rs->MoveNext();
     }
     return $objects;
 }

 private static function _getObjectsFromResultSet(ADORecordSet $rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $tag = new CloudGlueTag();
         $tag->id = intval($rs->fields['id']);
         $tag->name = $rs->fields['name'];
         $objects[$tag->id] = $tag;
         $rs->MoveNext();
     }
     return $objects;
 }

 private static function _createObjectsFromResultSet(ADORecordSet $rs)
 {
     $db = DevblocksPlatform::getDatabaseService();
     $objects = array();
     if ($rs instanceof ADORecordSet) {
         while (!$rs->EOF) {
             $object = new Model_CustomField();
             $object->id = intval($rs->fields['id']);
             $object->name = $rs->fields['name'];
             $object->type = $rs->fields['type'];
             $object->source_extension = $rs->fields['source_extension'];
             $object->group_id = intval($rs->fields['group_id']);
             $object->pos = intval($rs->fields['pos']);
             $object->options = DevblocksPlatform::parseCrlfString($rs->fields['options']);
             $objects[$object->id] = $object;
             $rs->MoveNext();
         }
     }
     return $objects;
 }

/**
 * Utility function used by the following 3 methods.
 *
 * @param ADORecordSet $rs an ADODB RecordSet object with two columns.
 * @return mixed an associative array, or false if an error occurred or the RecordSet was empty.
 * @access private
 */
function recordset_to_menu(ADORecordSet $rs)
{
    global $CFG;
    if ($rs && $rs->RecordCount() > 0) {
        $keys = array_keys($rs->fields);
        $key0 = $keys[0];
        if (isset($keys[1])) {
            $key1 = $keys[1];
        } else {
            $key1 = $keys[0];
        }
        while (!$rs->EOF) {
            $menu[$rs->fields[$key0]] = $rs->fields[$key1];
            $rs->MoveNext();
        }
        return $menu;
    } else {
        return false;
    }
}

 /**
  * @param ADORecordSet $rs
  * @return Model_WebapiKey[]
  */
 private static function _getObjectsFromResult($rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $object = new Model_WebapiKey();
         $object->id = intval($rs->fields['id']);
         $object->nickname = $rs->fields['nickname'];
         $object->access_key = $rs->fields['access_key'];
         $object->secret_key = $rs->fields['secret_key'];
         $rights = $rs->fields['rights'];
         if (!empty($rights)) {
             @($object->rights = unserialize($rights));
         }
         $objects[$object->id] = $object;
         $rs->MoveNext();
     }
     return $objects;
 }

 /**
  * @param ADORecordSet $rs
  * @return Model_Feed[]
  */
 private static function _getObjectsFromResult($rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $object = new Model_Feed();
         $object->id = $rs->fields['id'];
         $object->guid = $rs->fields['guid'];
         $object->name = $rs->fields['name'];
         $object->secret_key = $rs->fields['secret_key'];
         $objects[$object->id] = $object;
         $rs->MoveNext();
     }
     return $objects;
 }

 /**
  * Move to the next row in the results set
  *
  * Specifying a fetch_mode only works for newly fetched rows, the first row always gets fetched by query!!!
  *
  * @deprecated use foreach(query() or foreach(select() to loop over the query using the global db object
  * @param int $fetch_mode egw_db::FETCH_BOTH = numerical+assoc keys (eGW default), egw_db::FETCH_ASSOC or egw_db::FETCH_NUM
  * @return bool was another row found?
  */
 function next_record($fetch_mode = egw_db::FETCH_BOTH)
 {
     if (!$this->Query_ID) {
         $this->halt('next_record called with no query pending.');
         return 0;
     }
     if ($this->Row) {
         $this->Query_ID->MoveNext();
     }
     ++$this->Row;
     $this->Record = $this->Query_ID->fields;
     if ($this->Query_ID->EOF || !$this->Query_ID->RecordCount() || !is_array($this->Record)) {
         return False;
     }
     if ($this->capabilities['name_case'] == 'upper') {
         switch ($fetch_mode) {
             case egw_db::FETCH_ASSOC:
                 $this->Record = array_change_key_case($this->Record);
                 break;
             case egw_db::FETCH_NUM:
                 $this->Record = array_values($this->Record);
                 break;
             default:
                 $this->Record = array_change_key_case($this->Record);
                 if (!isset($this->Record[0])) {
                     $this->Record += array_values($this->Record);
                 }
                 break;
         }
     } elseif ($this->adodb->fetchMode != $fetch_mode) {
         if (!isset($this->Record[0])) {
             $this->Record += array_values($this->Record);
         }
     }
     return True;
 }

 /**
  * @param ADORecordSet $rs
  * @return Model_DevblocksTemplate[]
  */
 private static function _getObjectsFromResult($rs)
 {
     $objects = array();
     while (!$rs->EOF) {
         $object = new Model_DevblocksTemplate();
         $object->id = $rs->fields['id'];
         $object->plugin_id = $rs->fields['plugin_id'];
         $object->path = $rs->fields['path'];
         $object->tag = $rs->fields['tag'];
         $object->last_updated = $rs->fields['last_updated'];
         $object->content = $rs->fields['content'];
         $objects[$object->id] = $object;
         $rs->MoveNext();
     }
     return $objects;
 }