array, how to solve this

pser

Hi,

I have a challenge which I can find a solution for so I thought posting here might help. I use PHP and codeigniter and this is what i am trying to do.

I run a query towards a database and have the result in a array like this:

[records] => Array (
[0] => stdClass Object (
[OPID] => 5
[OPName] => Red Hat
[Created] => Oct 7 2009 1:51PM )
[1] => stdClass Object (
[OPID] => 3
[OPName] => Windows 7
[Created] => Oct 7 2009 12:00AM )
[2] => stdClass Object (
[OPID] => 4
[OPName] => Windows Server 2003
[Created] => Oct 7 2009 11:17AM )
)

I then use a foreach loop going through the array, so to typical write for example OPID I would write like this

foreach $records as $row
echo $row->OPID;
endforeach;

so far so good and this is working. But I would like to reuse the code and get it more dynamic that is I would love to write something like this:

foreach $records as $row
echo $row[$field]; // something echo $row->$field;
endforeach;

In this case the $field would contain 'OPID' which I get from a $_POST in one example and 'APID' in another, all depending of what data the user do.

So my question, is it possible to have a dynamic value in a $row field like this to get it dynamic?

Cheers
Paal

pser

I found a solution, but I am not sure if it is to elegant. In the loop I used this:

foreach($records->result_array() as $row)

Then I used this to get the first element of the array since I know that it is the unique identifier:
reset($row)

Then next($row) to get the next element in the array

But if someone has a better solution to this I would appreciate it.

Cheers

sneakyimp

If you have an associative array (meaning the keys of the array are textual rather than numeric) then you can do this:

foreach($records as $row) {
  foreach($row as $key => $value) {
    echo $key . '=' . $value . '<br>';
  }
}

pser

Hi,

I was considering a nested foreach, but thinking that if the array is large it would be slow. But I guess I have to try which method is the quickest.

Thanks for the tip anyway :rolleyes:

pser

I posted the challenge on codeigniter forum as well and a solution was posted there. The solution is:

foreach($records->result_array() as $row)
echo $row[$heading['field']];
endforeach;

The missing link for me what the $records->result_array(), I tried to use $records->result()

cheers
Paal