What is the equivalent of mysql_result in mysqli?

Question

How can I make a FOR in php using mysqli?

'Cause I’ve always been able to do that:

for($i=0; $i < $qtde; $i++){
   $pet_id = **mysql_result**($dadosPets, $i, 'animal_id');
}

How do I do the same, however, with mysqli?

Answer 1

The documentation link itself can help you http://php.net/manual/en/ (recommend in English, because sometimes the Portuguese version contains errors :/ )

Will have to use:

http://php.net/manual/en/mysqli-result.data-seek.php

A complete example:

<?php
//Conecta
$mysqli = new mysqli("localhost", "usuario", "senha", "banco");

if (mysqli_connect_errno()) {
    printf("Erro de conexão: %s\n", mysqli_connect_error());
    exit;
}

$query = 'SELECT ...'; //Sua select

if ($result = $mysqli->query($query)) {
    for($i = 0; $i < $qtde; $i++) {
        if ($result->data_seek($i)) {
            $row = $result->fetch_assoc();

            //ID do pet
            $pet_id = $row['pet_id'];

        }
    }
    $result->close();
}

$mysqli->close();

Procedural style:

<?php
//Conecta
$link = mysqli_connect("localhost", "usuario", "senha", "banco");

if (!$link) {
    printf("Erro de conexão: %s\n", mysqli_connect_error());
    exit;
}

$query = 'SELECT ...'; //Sua select

if ($result = mysqli_query($link, $query)) {
    for($i = 0; $i < $qtde; $i++) {
        if (mysqli_data_seek($result, $i)) {
            $row = mysqli_fetch_assoc($result);

            //ID do pet
            $pet_id = $row['pet_id'];
        }
    }

    mysqli_free_result($result);
}

mysqli_close($link);

Answer 2

I prefer this example

Object-Oriented rating

<?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->close();
}

/* close connection */
$mysqli->close();
?>

procedural notation

<?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);
?>

Answer 3

Mysqli is obsolete and should be used in its place the PDO class, with this you can assemble your querys based on POO, making them much simpler and safer.

See more in the PHP documentation

PDO