/**
* @param mysqli_result $mysqli_result
* @param bool $single
* @return array|bool|null
*/
public function fetch($mysqli_result, $single)
{
$this->_('fields', array());
foreach ($mysqli_result->fetch_fields() as $field) {
$this->_('fields')[$field->name] = $this->rules[$this->types[$field->type]];
}
switch (true) {
case !$mysqli_result:
return null;
case $single && $mysqli_result->num_rows == 0:
$result = false;
break;
case $single:
$result = $this->cast($mysqli_result->fetch_assoc());
break;
case $mysqli_result->num_rows == 0:
$result = array();
break;
default:
$result = array();
while ($row = $mysqli_result->fetch_assoc()) {
$result[] = $this->cast($row);
}
}
$mysqli_result->free();
return $result;
}
/**
* @return array|null
*/
public function fetch()
{
if (is_bool($this->result)) {
return $this->result;
}
return $this->result->fetch_assoc();
}
public function fetch_accoc()
{
while ($row = $this->resource_id->fetch_assoc()) {
$this->result_array[] = $row;
}
return $this->result_array;
}
public function nextRecord()
{
if (is_object($this->handle) && ($data = $this->handle->fetch_assoc())) {
return $data;
} else {
return false;
}
}
function fetchAll()
{
$data = array();
while ($record = $this->result->fetch_assoc()) {
$data[] = $record;
}
return $data;
}
/**
* @param Entity $entity
* @return EntityManagerMysqli
*/
protected function fetch(\mysqli_result $result, Entity $entity = null)
{
while ($data = $result->fetch_assoc()) {
$this->add($entity->getClone()->serialize($data));
}
return $this;
}
/**
* Returns the current row of a result set under HHVM
* The problem was fetch_object creates new instance of a given class,
* and attaches resulted key/value pairs after the class was constructed.
*
* @return mixed
*/
private function currentHHVM()
{
if ($this->_as_object === TRUE or is_string($this->_as_object)) {
if ($this->_reflect_class === NULL) {
// Create reflection class of given classname or stdClass
$this->_reflect_class = new ReflectionClass(is_string($this->_as_object) ? $this->_as_object : 'stdClass');
}
// Support ORM with loaded, when the class has __set and __construct if its ORM
if ($this->_reflect_class->hasMethod('__set') === TRUE && $this->_reflect_class->hasMethod('__construct') === TRUE) {
// Get row as associated array
$row = $this->_result->fetch_assoc();
// Get new instance without constructing it
$object = $this->_reflect_class->newInstanceWithoutConstructor();
foreach ($row as $column => $value) {
// Trigger the class setter
$object->__set($column, $value);
}
// Construct the class with no parameters
$object->__construct(NULL);
return $object;
} elseif (is_string($this->_as_object)) {
// Return an object of given class name
return $this->_result->fetch_object($this->_as_object, (array) $this->_object_params);
} else {
// Return an stdClass
return $this->_result->fetch_object();
}
}
// Get row as associated array
return $this->_result->fetch_assoc();
}
/**
* Load from mysqli result
*
* @return bool
*/
protected function loadFromMysqliResult()
{
$this->currentData = null;
if (($data = $this->resource->fetch_assoc()) === null) {
return false;
}
$this->position++;
$this->currentData = $data;
$this->currentComplete = true;
$this->nextComplete = true;
$this->position++;
return true;
}
function loadDefaultData($totalCount, mysqli_result $result)
{
if ($totalCount == 0) {
echo "暂无资讯";
return;
} else {
if ($totalCount > 0) {
$cnt = 0;
while ($row = $result->fetch_assoc()) {
if ($cnt < DEFAULT_SHOW) {
$list_id = $row["info_id"];
echo "<div class=\"list\">";
echo "<a href=\"" . $row["origin_link"] . "\" class=\"nav_list\" data-id={$list_id} onclick=\"count({$list_id})\">";
echo "<p class=\"caption\">";
echo $row["caption"];
echo "</p>";
echo "<p class=\"subhead\">";
echo $row["subhead"];
echo "</p>";
echo "<div class=\"footer\">";
echo "<span class=\"text_des\">";
echo $row["origin"];
echo "</span>";
echo " ";
echo " ";
echo "<span class=\"num_des\">";
echo substr($row["publish_date"], 5, 5);
echo "</span>";
echo " ";
echo " ";
echo "<div class=\"like\">";
echo "<img src=\"../images/grayheart.png\" class=\"icon\">";
echo "<span class=\"info_like\">";
echo showFavNum($row["fav"]);
echo "</span>";
echo "</div>";
echo "</div>";
echo "<img src=\"" . $row["pic_link"] . "\" class=\"show_pic\">";
echo "</a>";
echo "</div>";
echo "<hr/>";
$cnt++;
} else {
break;
return;
}
}
}
}
}
/**
* @param \mysqli_result $result
* @param $returnMode
* @return \Generator
*/
public function rowGenerator(\mysqli_result $result, $returnMode)
{
switch ($returnMode) {
case self::RETURN_TYPE_ASSOC:
(yield $result->fetch_assoc());
break;
case self::RETURN_TYPE_NUM:
(yield $result->fetch_array(MYSQLI_NUM));
break;
case self::RETURN_TYPE_BOTH:
(yield $result->fetch_array(MYSQLI_BOTH));
break;
case self::RETURN_TYPE_MYSQLI_ROW:
(yield $result->fetch_row());
break;
case self::RETURN_TYPE_OBJ:
(yield $result->fetch_object());
break;
default:
(yield $result->fetch_assoc());
break;
}
}
function loadDefaultData($totalCount, mysqli_result $result)
{
if ($totalCount == 0) {
return;
} else {
if ($totalCount > 0) {
$cnt = 0;
while ($row = $result->fetch_assoc()) {
if ($cnt < DEFAULT_SHOW) {
$list_id = $row["info_id"];
echo "<div class=\"list\">";
echo "<a href=\"" . $row["origin_link"] . "\" class=\"e_wine_list\" data-id={$list_id} onclick=\"count({$list_id})\">";
echo "<p class=\"wine_caption\">";
echo $row["caption"];
echo "</p>";
echo "<p class='wine_subhead'>";
echo $row['subhead'];
echo "</p>";
echo "<div class=\"wine_footer\">";
echo "<span class=\"wine_orgin\">";
echo $row["origin"];
echo "</span>";
echo " ";
echo " ";
echo "<span class=\"wine_price\">";
echo $row["publish_date"];
echo "</span>";
echo " ";
echo " ";
echo "<div class=\"wine_fav\">";
echo "<img src=\"../images/grayheart.png\" class=\"icon\">";
echo "<span class=\"wine_fav_num\">";
echo showFavNum($row["fav"]);
echo "</span>";
echo "</div>";
echo "</div>";
echo "<img src=\"" . $row["pic_link"] . "\" class=\"wine_show_pic\">";
echo "</a>";
echo "</div>";
echo "<hr/>";
$cnt++;
} else {
break;
return;
}
}
}
}
}
function loadMore($page, mysqli_result $result)
{
$pos = 0;
$cnt = 0;
$arry = array();
while ($row = $result->fetch_assoc()) {
if ($pos != $page * DEFAULT_SHOW) {
$pos++;
continue;
} else {
if ($cnt < DEFAULT_SHOW) {
array_push($arry, $row);
$cnt++;
} else {
break;
return;
}
}
}
return json_encode($arry, JSON_UNESCAPED_UNICODE);
}
/**
* @inheritdoc
*/
public function one()
{
return $this->result->fetch_assoc();
}
/**
* @param mysqli_result $query_id
* @return array|bool
*/
public function fetch_assoc($query_id)
{
return $query_id ? $query_id->fetch_assoc() : false;
}
function loadDefaultComments($totalCount, mysqli_result $res)
{
if ($totalCount == 0) {
return;
} else {
$cnt = 0;
while ($row = $res->fetch_assoc()) {
if ($cnt < DEFAULT_SHOW) {
echo "<div class=\"conts\">";
echo "<div class=\"user_bar\">";
echo "<div class=\"user_info\">";
echo "<img src=\"" . $row["head_pic"] . "\">";
echo "<p class=\"uname\">";
echo $row["nickname"];
echo "</p>";
echo "<p class=\"date_time\">";
echo $row["create_time"];
echo "</p>";
echo "</div>";
echo "</div>";
echo "<div class=\"comment_info\">";
echo "<p class=\"comment_cont\">";
echo $row["comment_cont"];
echo "</p>";
echo "</div>";
echo "</div>";
echo "<hr/>";
$cnt++;
} else {
break;
return;
}
}
}
}
/**
* Ziskat radek z dotazu
* @param mysqli_result $result
* @return array|bool
*/
public static function row(mysqli_result $result)
{
$row = $result->fetch_assoc();
if (null !== $row) {
return $row;
} else {
return false;
}
}
protected function doFetch()
{
return is_null($a = $this->result->fetch_assoc()) ? false : $a;
}
/**
* @param \mysqli_result $result
* @return array
*/
public function fetchAssoc($result)
{
if (!$result) {
return $result;
}
return $result->fetch_assoc();
}
/**
* Returns next result row or false.
*
* @return array|false
*/
protected function fetchRowInternal()
{
return $this->resource->fetch_assoc();
}
/**
* Package query results into models.
*
* @method packageResults
*
* @param Result $result The results to package
* @param Query $query The query which produced the results
*
* @return Collection The results
*/
private function packageResults(Result $result, $query)
{
// Create an empty collection to store results in
$collection = new Collection();
$collection->totalRows = $this->foundRows();
// Loop through the query results
while (($data = $result->fetch_assoc()) !== null) {
// Prepare the row data for storage within a model
$prepared = $this->prepareData($data);
// Package the row into a model
$this->packageModel($prepared, $collection, $query);
}
return $collection;
}
public function __construct(mysqli_result $rs)
{
while ($row = $rs->fetch_assoc()) {
$this->a[] = $row;
}
}
function pm_process_result(mysqli_result $result, $message_count)
{
$message_array = array();
while (($pm_data = $result->fetch_assoc()) !== null) {
if (!isset($pm_data['FROM_LOGON'])) {
$pm_data['FROM_LOGON'] = gettext("Unknown user");
}
if (!isset($pm_data['FROM_NICKNAME'])) {
$pm_data['FROM_NICKNAME'] = "";
}
$message_array[$pm_data['MID']] = array('CREATED' => $pm_data['CREATED'], 'FROM_UID' => $pm_data['FROM_UID'], 'FROM_LOGON' => $pm_data['FROM_LOGON'], 'FROM_NICKNAME' => $pm_data['FROM_NICKNAME'], 'MID' => $pm_data['MID'], 'RECIPIENTS' => array(), 'REPLY_TO_MID' => $pm_data['REPLY_TO_MID'], 'SUBJECT' => $pm_data['SUBJECT'], 'TYPE' => $pm_data['TYPE']);
}
pms_get_recipients($message_array);
pms_have_attachments($message_array);
return array('message_count' => $message_count, 'message_array' => $message_array);
}
/**
* @param mysqli_result $result
* @return mixed
*/
public function fetch_assoc($result)
{
return $result->fetch_assoc();
}
public function fetch_row()
{
return $this->result ? $this->result->fetch_assoc() : null;
}
/**
* Return associative array of the current row or null if no more rows are in the result
* @return array|null
*/
public function fetchAssoc()
{
return $this->dbResult->fetch_assoc();
}
/**
* Return reference to next row in result set.
* @param mysqli_result|resource|PDOStatement $result
* @return array
*/
public function nextRow($result)
{
return $result->fetch_assoc();
}
public static function fetch(\mysqli_result $result)
{
return $result->fetch_assoc();
}
/**
* Get all records as an array of associative arrays
* @param mysqli_result $result
* @return array empty array if no result
*/
public function getAssocArrays(mysqli_result $result = null)
{
$contentArray = array();
if ($result != null) {
while ($row = $result->fetch_assoc()) {
$contentArray[] = $row;
}
}
return $contentArray;
}
/**
* Get all rows from the DB result.
*
* @param \mysqli_result|bool $result The return of query method.
*
* @return array The array of SQL rows
*/
public function getRowsArray($result)
{
$rows = [];
if (!$result) {
return $rows;
}
while ($row = $result->fetch_assoc()) {
$rows[] = $row;
}
$result->free();
return $rows;
}
/**
* Возвращает строку в виде ассоциативного массива из результата последнего запроса к БД
*
* @param \mysqli_result $result альтеранативный результат
* @return array
*/
public function fetchRow($result = null)
{
if ($result) {
return $result->fetch_assoc();
} else {
if ($this->result) {
return $this->result->fetch_assoc();
} else {
return null;
}
}
}
