Create equivalent to mysql_fetch_assoc()

[andrewtayloruk]

Hi,

More of a theoretical question than anything else, is it possible to do the following, and if so, any pointers on how it works.

function myFunction($myArray) {

return $value;
}

myArray = Array(1,2,3,4,5,6)

while($tmp = myFunction($myArray)) {

echo $tmp;
}

So basically, like mysql_fetch_array works, where by it loops each record at a time and returns one record until the end of the recordset is reached, but instead of a recordset identified, passing in an array.

Now before everyone starts 🙂 I know I can use foreach(), I'm not interested in the correct way to loop an array, I'm more interested in the theory behind the principle.

Thanks for any discussion.

Andrew

[paulnaj]

Yes, in principle, you can ... using the array functions reset(), next(), current(), etc

See current() to get going.

[bad76]

Hi,
the function is based ons concept of "associative array".

The index of this array are string, called "key", instead of number. However a number is a key too. To do some like mysql_fetch_assoc(), you need of two array: one with value and one with key. Mysql use the value in db as first array, and the name of field as second. Then it make an associatve array:

...
$row[$fieldname[1]]=$value[1];
$row[$fieldname[2]]=$value[2];
$row[$fieldname[3]]=$value[3];
...

Be carefull with this. Some time the php give error with:

$row[$fieldname[2]]=$value[2];

and You must rewrite it as this:

$mykey=$fieldname[2];
$row[$mykey]=$value[2];

I hope this help.

see you