22.9.3.11. The mysqli_result class (mysqli_result)

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = $mysqli->query($query)) {    /* Get field information for all columns */    while ($finfo = $result->fetch_field()) {        /* get fieldpointer offset */        $currentfield = $result->current_field;        printf("Column %d:\n", $currentfield);        printf("Name:     %s\n", $finfo->name);        printf("Table:    %s\n", $finfo->table);        printf("max. Len: %d\n", $finfo->max_length);        printf("Flags:    %d\n", $finfo->flags);        printf("Type:     %d\n\n", $finfo->type);    }    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = mysqli_query($link, $query)) {    /* Get field information for all fields */    while ($finfo = mysqli_fetch_field($result)) {        /* get fieldpointer offset */        $currentfield = mysqli_field_tell($result);        printf("Column %d:\n", $currentfield);        printf("Name:     %s\n", $finfo->name);        printf("Table:    %s\n", $finfo->table);        printf("max. Len: %d\n", $finfo->max_length);        printf("Flags:    %d\n", $finfo->flags);        printf("Type:     %d\n\n", $finfo->type);    }    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Column 1:Name:     NameTable:    Countrymax. Len: 11Flags:    1Type:     254Column 2:Name:     SurfaceAreaTable:    Countrymax. Len: 10Flags:    32769Type:     4

<?php/* Open a connection */$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER BY Name";if ($result = $mysqli->query( $query)) {    /* seek to row no. 400 */    $result->data_seek(399);    /* fetch row */    $row = $result->fetch_row();    printf ("City: %s  Countrycode: %s\n", $row[0], $row[1]);    /* free result set*/    $result->close();}/* close connection */$mysqli->close();?>

<?php/* Open a connection */$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (!$link) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER BY Name";if ($result = mysqli_query($link, $query)) {    /* seek to row no. 400 */    mysqli_data_seek($result, 399);    /* fetch row */    $row = mysqli_fetch_row($result);    printf ("City: %s  Countrycode: %s\n", $row[0], $row[1]);    /* free result set*/    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

City: Benin City  Countrycode: NGA

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";$result = $mysqli->query($query);/* numeric array */$row = $result->fetch_array(MYSQLI_NUM);printf ("%s (%s)\n", $row[0], $row[1]);/* associative array */$row = $result->fetch_array(MYSQLI_ASSOC);printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);/* associative and numeric array */$row = $result->fetch_array(MYSQLI_BOTH);printf ("%s (%s)\n", $row[0], $row["CountryCode"]);/* free result set */$result->free();/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";$result = mysqli_query($link, $query);/* numeric array */$row = mysqli_fetch_array($result, MYSQLI_NUM);printf ("%s (%s)\n", $row[0], $row[1]);/* associative array */$row = mysqli_fetch_array($result, MYSQLI_ASSOC);printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);/* associative and numeric array */$row = mysqli_fetch_array($result, MYSQLI_BOTH);printf ("%s (%s)\n", $row[0], $row["CountryCode"]);/* free result set */mysqli_free_result($result);/* close connection */mysqli_close($link);?>   

The above examples will output:

Kabul (AFG)Qandahar (AFG)Herat (AFG)

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = $mysqli->query($query)) {    /* fetch associative array */    while ($row = $result->fetch_assoc()) {        printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);    }    /* free result set */    $result->free();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = mysqli_query($link, $query)) {    /* fetch associative array */    while ($row = mysqli_fetch_assoc($result)) {        printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);    }    /* free result set */    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Pueblo (USA)Arvada (USA)Cape Coral (USA)Green Bay (USA)Santa Clara (USA)

<?php$c = mysqli_connect('127.0.0.1','user', 'pass');// Using iterators (support was added with PHP 5.4)foreach ( $c->query('SELECT user,host FROM mysql.user') as $row ) {    printf("'%s'@'%s'\n", $row['user'], $row['host']);}echo "\n==================\n";// Not using iterators$result = $c->query('SELECT user,host FROM mysql.user');while ($row = $result->fetch_assoc()) {    printf("'%s'@'%s'\n", $row['user'], $row['host']);}?>   

The above example will output something similar to:

'root'@'192.168.1.1''root'@'127.0.0.1''dude'@'localhost''lebowski'@'localhost'=================='root'@'192.168.1.1''root'@'127.0.0.1''dude'@'localhost''lebowski'@'localhost'

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Name LIMIT 5";if ($result = $mysqli->query($query)) {    /* Get field information for column 'SurfaceArea' */    $finfo = $result->fetch_field_direct(1);    printf("Name:     %s\n", $finfo->name);    printf("Table:    %s\n", $finfo->table);    printf("max. Len: %d\n", $finfo->max_length);    printf("Flags:    %d\n", $finfo->flags);    printf("Type:     %d\n", $finfo->type);    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Name LIMIT 5";if ($result = mysqli_query($link, $query)) {    /* Get field information for column 'SurfaceArea' */    $finfo = mysqli_fetch_field_direct($result, 1);    printf("Name:     %s\n", $finfo->name);    printf("Table:    %s\n", $finfo->table);    printf("max. Len: %d\n", $finfo->max_length);    printf("Flags:    %d\n", $finfo->flags);    printf("Type:     %d\n", $finfo->type);    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Name:     SurfaceAreaTable:    Countrymax. Len: 10Flags:    32769Type:     4

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = $mysqli->query($query)) {    /* Get field information for all columns */    while ($finfo = $result->fetch_field()) {        printf("Name:     %s\n", $finfo->name);        printf("Table:    %s\n", $finfo->table);        printf("max. Len: %d\n", $finfo->max_length);        printf("Flags:    %d\n", $finfo->flags);        printf("Type:     %d\n\n", $finfo->type);    }    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = mysqli_query($link, $query)) {    /* Get field information for all fields */    while ($finfo = mysqli_fetch_field($result)) {        printf("Name:     %s\n", $finfo->name);        printf("Table:    %s\n", $finfo->table);        printf("max. Len: %d\n", $finfo->max_length);        printf("Flags:    %d\n", $finfo->flags);        printf("Type:     %d\n\n", $finfo->type);    }    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Name:     NameTable:    Countrymax. Len: 11Flags:    1Type:     254Name:     SurfaceAreaTable:    Countrymax. Len: 10Flags:    32769Type:     4

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = $mysqli->query($query)) {    /* Get field information for all columns */    $finfo = $result->fetch_fields();    foreach ($finfo as $val) {        printf("Name:     %s\n", $val->name);        printf("Table:    %s\n", $val->table);        printf("max. Len: %d\n", $val->max_length);        printf("Flags:    %d\n", $val->flags);        printf("Type:     %d\n\n", $val->type);    }    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = mysqli_query($link, $query)) {    /* Get field information for all columns */    $finfo = mysqli_fetch_fields($result);    foreach ($finfo as $val) {        printf("Name:     %s\n", $val->name);        printf("Table:    %s\n", $val->table);        printf("max. Len: %d\n", $val->max_length);        printf("Flags:    %d\n", $val->flags);        printf("Type:     %d\n\n", $val->type);    }    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Name:     NameTable:    Countrymax. Len: 11Flags:    1Type:     254Name:     SurfaceAreaTable:    Countrymax. Len: 10Flags:    32769Type:     4

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();} $query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = $mysqli->query($query)) {    /* fetch object array */    while ($obj = $result->fetch_object()) {        printf ("%s (%s)\n", $obj->Name, $obj->CountryCode);    }    /* free result set */    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = mysqli_query($link, $query)) {    /* fetch associative array */    while ($obj = mysqli_fetch_object($result)) {        printf ("%s (%s)\n", $obj->Name, $obj->CountryCode);    }    /* free result set */    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Pueblo (USA)Arvada (USA)Cape Coral (USA)Green Bay (USA)Santa Clara (USA)

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = $mysqli->query($query)) {    /* fetch object array */    while ($row = $result->fetch_row()) {        printf ("%s (%s)\n", $row[0], $row[1]);    }    /* free result set */    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";if ($result = mysqli_query($link, $query)) {    /* fetch associative array */    while ($row = mysqli_fetch_row($result)) {        printf ("%s (%s)\n", $row[0], $row[1]);    }    /* free result set */    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Pueblo (USA)Arvada (USA)Cape Coral (USA)Green Bay (USA)Santa Clara (USA)

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}if ($result = $mysqli->query("SELECT * FROM City ORDER BY ID LIMIT 1")) {    /* determine number of fields in result set */    $field_cnt = $result->field_count;    printf("Result set has %d fields.\n", $field_cnt);    /* close result set */    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}if ($result = mysqli_query($link, "SELECT * FROM City ORDER BY ID LIMIT 1")) {    /* determine number of fields in result set */    $field_cnt = mysqli_num_fields($result);    printf("Result set has %d fields.\n", $field_cnt);    /* close result set */    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Result set has 5 fields.

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = $mysqli->query($query)) {    /* Get field information for 2nd column */    $result->field_seek(1);    $finfo = $result->fetch_field();    printf("Name:     %s\n", $finfo->name);    printf("Table:    %s\n", $finfo->table);    printf("max. Len: %d\n", $finfo->max_length);    printf("Flags:    %d\n", $finfo->flags);    printf("Type:     %d\n\n", $finfo->type);    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";if ($result = mysqli_query($link, $query)) {    /* Get field information for 2nd column */    mysqli_field_seek($result, 1);    $finfo = mysqli_fetch_field($result);    printf("Name:     %s\n", $finfo->name);    printf("Table:    %s\n", $finfo->table);    printf("max. Len: %d\n", $finfo->max_length);    printf("Flags:    %d\n", $finfo->flags);    printf("Type:     %d\n\n", $finfo->type);    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Name:     SurfaceAreaTable:    Countrymax. Len: 10Flags:    32769Type:     4

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT * from Country ORDER BY Code LIMIT 1";if ($result = $mysqli->query($query)) {    $row = $result->fetch_row();    /* display column lengths */    foreach ($result->lengths as $i => $val) {        printf("Field %2d has Length %2d\n", $i+1, $val);    }    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}$query = "SELECT * from Country ORDER BY Code LIMIT 1";if ($result = mysqli_query($link, $query)) {    $row = mysqli_fetch_row($result);    /* display column lengths */    foreach (mysqli_fetch_lengths($result) as $i => $val) {        printf("Field %2d has Length %2d\n", $i+1, $val);    }    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Field  1 has Length  3Field  2 has Length  5Field  3 has Length 13Field  4 has Length  9Field  5 has Length  6Field  6 has Length  1Field  7 has Length  6Field  8 has Length  4Field  9 has Length  6Field 10 has Length  6Field 11 has Length  5Field 12 has Length 44Field 13 has Length  7Field 14 has Length  3Field 15 has Length  2

<?php$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}if ($result = $mysqli->query("SELECT Code, Name FROM Country ORDER BY Name")) {    /* determine number of rows result set */    $row_cnt = $result->num_rows;    printf("Result set has %d rows.\n", $row_cnt);    /* close result set */    $result->close();}/* close connection */$mysqli->close();?>

<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) {    printf("Connect failed: %s\n", mysqli_connect_error());    exit();}if ($result = mysqli_query($link, "SELECT Code, Name FROM Country ORDER BY Name")) {    /* determine number of rows result set */    $row_cnt = mysqli_num_rows($result);    printf("Result set has %d rows.\n", $row_cnt);    /* close result set */    mysqli_free_result($result);}/* close connection */mysqli_close($link);?>   

The above examples will output:

Result set has 239 rows.