type: Enregistre le fait que le résultat soit mis en mémoire tampon ou non sous la forme d'un entier (MYSQLI_STORE_RESULT ou MYSQLI_USE_RESULT, respectivement).

Historique

Version	Description
8.0.0	La classe mysqli_result implémente désormais IteratorAggregate. Auparavant, seule Traversable était implémentée.

Sommaire

mysqli_result::__construct — Constructs a mysqli_result object
mysqli_result::$current_field — Récupère la position courante d'un champ dans un pointeur de résultat
mysqli_result::data_seek — Déplace le pointeur interne de résultat
mysqli_result::fetch_all — Récupère toutes les lignes de résultats dans un tableau associatif, numérique, ou les deux
mysqli_result::fetch_array — Récupère la ligne suivante d'un ensemble de résultats sous forme de tableau associatif, numérique ou les deux
mysqli_result::fetch_assoc — Récupère la ligne suivante d'un ensemble de résultats sous forme de tableau associatif
mysqli_result::fetch_column — Fetch a single column from the next row of a result set
mysqli_result::fetch_field_direct — Récupère les métadonnées d'un champ unique
mysqli_result::fetch_field — Retourne le prochain champs dans le jeu de résultats
mysqli_result::fetch_fields — Retourne un tableau d'objets représentant les champs dans le résultat
mysqli_result::fetch_object — Retourne la ligne suivante d'un ensemble de résultats sous forme d'objet
mysqli_result::fetch_row — Récupère une ligne de résultat sous forme de tableau indexé
mysqli_result::$field_count — Récupère le nombre de champs dans l'ensemble de résultats
mysqli_result::field_seek — Déplace le pointeur de résultat sur le champ spécifié
mysqli_result::free — Libère la mémoire associée à un résultat
mysqli_result::getIterator — Retrieve an external iterator
mysqli_result::$lengths — Retourne la longueur des colonnes de la ligne courante du jeu de résultats
mysqli_result::$num_rows — Retourne le nombre de lignes dans le jeu de résultats

add a note

User Contributed Notes 7 notes

down

tuxedobob ¶

12 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 ¶

6 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

Anonymous ¶

14 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

Marc17 ¶

10 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

blar at blar dot de ¶

15 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

-3

marcus at synchromedia dot co dot uk ¶

9 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

-27

sinisaculic at gmail dot com ¶

14 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