PHP - Manual: mysqli_result

2024-11-14

mysqli_result类

(PHP 5, PHP 7, PHP 8)

简介

代表从一个数据库查询中获取的结果集。

更新日志

**更新日志**
版本	说明
5.4.0	Iterator support was added, as mysqli_result now implements Traversable.

类摘要

class mysqli_result {

/* 属性 */

int $current_field;

int $field_count;

?array $lengths;

int|string $num_rows;

/* 方法 */

mysqli_field_tell(mysqli_result $result): int

public data_seek(int $offset): bool

public fetch_all(int $mode = MYSQLI_NUM): array

public fetch_array(int $mode = MYSQLI_BOTH): array|null|false

public fetch_assoc(): array|null|false

public fetch_column(int $column = 0): null|int|float|string|false

public fetch_field_direct(int $index): object|false

public fetch_field(): object|false

public fetch_fields(): array

public fetch_object(string $class = "stdClass", array $constructor_args = []): object|null|false

public fetch_row(): array|null|false

mysqli_num_fields(mysqli_result $result): int

public field_seek(int $index): bool

public free(): void

public getIterator(): Iterator

mysqli_fetch_lengths(mysqli_result $result): array|false

mysqli_num_rows(mysqli_result $result): int|string

}

mysqli_result::__construct — Constructs a mysqli_result object
mysqli_result::$current_field — Get current field offset of a result pointer
mysqli_result::data_seek — Adjusts the result pointer to an arbitrary row in the result
mysqli_result::fetch_all — Fetch all result rows as an associative array, a numeric array, or both
mysqli_result::fetch_array — Fetch the next row of a result set as an associative, a numeric array, or both
mysqli_result::fetch_assoc — Fetch the next row of a result set as an associative array
mysqli_result::fetch_column — Fetch a single column from the next row of a result set
mysqli_result::fetch_field_direct — Fetch meta-data for a single field
mysqli_result::fetch_field — Returns the next field in the result set
mysqli_result::fetch_fields — Returns an array of objects representing the fields in a result set
mysqli_result::fetch_object — Fetch the next row of a result set as an object
mysqli_result::fetch_row — Fetch the next row of a result set as an enumerated array
mysqli_result::$field_count — Gets the number of fields in the result set
mysqli_result::field_seek — Set result pointer to a specified field offset
mysqli_result::free — Frees the memory associated with a result
mysqli_result::getIterator — Retrieve an external iterator
mysqli_result::$lengths — Returns the lengths of the columns of the current row in the result set
mysqli_result::$num_rows — Gets the number of rows in the result set

add a note

User Contributed Notes 7 notes

down

tuxedobob ¶

9 years ago


Converting an old project from using the mysql extension to the mysqli extension, I found the most annoying change to be the lack of a corresponding mysql_result function in mysqli. While mysql_result is a generally terrible function, it was useful for fetching a single result field *value* from a result set (for example, if looking up a user's ID).


The behavior of mysql_result is approximated here, though you may want to name it something other than mysqli_result so as to avoid thinking it's an actual, built-in function.


<?php

function mysqli_result($res, $row, $field=0) {

    $res->data_seek($row);

    $datarow = $res->fetch_array();

    return $datarow[$field];

}

?>



Implementing it via the OO interface is left as an exercise to the reader.

down

Cem Kayali / cemkayali(a)eticaret.com.tr ¶

3 years ago


Switching from Php5 to Php7, especially if you have worked on an ongoing, long term project, it is unfortunate that there is no mysqli_result function.

So, this may be helpfull and you can call this function as you wish. I assume you do restricted search (searching for single row or few rows only).

function mysqli_result($search, $row, $field){
$i=0; while($results=mysqli_fetch_array($search)){
if ($i==$row){$result=$results[$field];}
$i++;}
return $result;} 

Simply;

$search=mysqli_query($connection, "select name from table_name where id='7'");
$name=mysqli_result($search, 0, "id"); 

Best wishes,

down

Marc17 ¶

8 years ago


An "mysqli_result" function where $field can be like table_name.field_name with alias or not.
<?php
function mysqli_result($result,$row,$field=0) {
    if ($result===false) return false;
    if ($row>=mysqli_num_rows($result)) return false;
    if (is_string($field) && !(strpos($field,".")===false)) {
        $t_field=explode(".",$field);
        $field=-1;
        $t_fields=mysqli_fetch_fields($result);
        for ($id=0;$id<mysqli_num_fields($result);$id++) {
            if ($t_fields[$id]->table==$t_field[0] && $t_fields[$id]->name==$t_field[1]) {
                $field=$id;
                break;
            }
        }
        if ($field==-1) return false;
    }
    mysqli_data_seek($result,$row);
    $line=mysqli_fetch_array($result);
    return isset($line[$field])?$line[$field]:false;
}
?>

down

Anonymous ¶

12 years ago


Generally, it appears Mysqli OO vs Procedural style has no significant difference in speed, at least with the more generally used functions and methods (connect, close, query, free, etc).

With the fetch_* family of functions and methods dealing with result rows, however, Procedural wins out.  Averaging over a hundred or so tests with a result set of 180,000 records, and using mysqli_fetch_*() functions vs. their mysqli_result::fetch_*() counterpart object methods to read and iterate over all records, all of the mysqli_fetch_*() functions win by ~0.1 seconds less.

This is interesting considering we're dealing with the same result object in both styles.

This was using Vistax64, PHP5.3.2, Mysql 5.1.45, using a bit of this code:

<?php

// procedural - takes 0.1 seconds less than OO here
$stopwatch = microtime(true);
while($row = mysqli_fetch_assoc($result)){
    ++$z;
    }
echo microtime(true) - $stopwatch;

// OO
$stopwatch = microtime(true);
while($row = $result->fetch_assoc()){
    ++$z;
    }
echo microtime(true) - $stopwatch;

?>

down

blar at blar dot de ¶

13 years ago


Extending the MySQLi_Result

<?php

class Database_MySQLi extends MySQLi
{
    public function query($query)
    {
        $this->real_query($query);
        return new Database_MySQLi_Result($this);
    }
}

class Database_MySQLi_Result extends MySQLi_Result
{
    public function fetch()
    {
        return $this->fetch_assoc();
    }

    public function fetchAll()
    {
        $rows = array();
        while($row = $this->fetch())
        {
            $rows[] = $row;
        }
        return $rows;
    }
}

?>

down

-4

marcus at synchromedia dot co dot uk ¶

6 years ago


If you're using the iterator interface on a result instance ($r), like this:

    foreach ($r as $d) {

the iterated value ($d) is an associative-only array, i.e. it's the same as doing this:

    while ($d = $r->fetch_assoc()) {

and NOT like this:

    while ($d = $r->fetch_row()) {

so you can't access row elements by numeric index ($d[0] etc) if you use the foreach syntax.

down

-36

sinisaculic at gmail dot com ¶

11 years ago


storing this object in ANY kind will result in storing an empty object... if you try to serialize it dump it or do anything with it you will end up with a empty object. 

you have to pull all data out f the object and then store the data... no other way.

add a note

官方地址：https://www.php.net/manual/en/class.mysqli-result.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 Composer的Packagist资源 opcache预加载 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHPstorm 里面Terminal 不能使用 esc键吗退出编辑模式吗 php设置cookie为httponly防止xss攻击 PHP - mysql_real_escape_string()与mysql_escape_string() 的区别 PHP mkdir()写出来的权限与mode值不符合支持php7的性能采集扩展

略微加速

PHP官方手册 - 互联网笔记

mysqli_result类

简介

类摘要

目录

User Contributed Notes 7 notes