Home / Questions / 127998
Accepted
Sagara
Asked: 2020-12-31 16:45:35 +0800 CST 2020-12-31 16:45:35 +0800 CST

How to loop through this array in php?

  • 772

I am working with php CodeIgniter and I am getting results from a query which I save in the following array

$arr = array();
foreach ($query->result() as $row)
{
    $arr[] = array("id"=>$row->id, "nom"=>$row->nombre);
}

But I haven't found how to iterate through the array in order to use the "id" and "nom" values ​​of each index.

php

2 Answers

  1. You could use to get the result of the query, with $result being what you got from the query:

    $resultado->result_array();

    Then it is easier to get the fields because you use:

    <?php foreach($resultado as $rows =>$row){

 echo $row['id'];
 echo $row['nombre'];
}

    This way you easily extract the values ​​returned in the query SQL. "id"and "nombre"it is just as the fields are called in your table, so if you have a field in your table called "surname" to obtain each of the indices of the result of the query, "apellido"you should do:

    <?php
foreach($resultado as $rows =>$row){

 echo $row['apellido'];
}

    That is the solution Greetings!

    • 1
  2. Best Answer

    If you store your data in an array like this:

    $arr = array();
foreach ($query->result() as $row)
{
    $arr[] = array("id"=>$row->id, "nom"=>$row->nombre);
}

    You can access them one by one from this other:

    foreach ($arr as $row)
{
    $id     = $row['id'];
    $nombre = $row['nom'];
}

    What you are creating is a multidimensional array where each value is an associative array that stores the values ​​obtained $row->idthrough $row->nombrethe query for each record, assigning them to the keys 'id' and 'nom'. Thus, to access a specific data, for example the ID of the third record obtained, you will have to access using first the position, to access the associative array and then the index associated with the ID data within it:

    $arr_row = $arr[2];
$id = $arr_row['id'];
    • 1