[thelist] php: multidimensional arrays; and use array_unique or db index?

Michael Barrett mbarrett at abouthalf.com
Sat Mar 29 11:25:00 CST 2003

On Saturday, March 29, 2003, at 01:59  AM, Dunstan Orchard wrote:

> In the end I saw the light and came up with this code, but I'd be 
> interested
> to know what the 'proper' way to extract data from a multi-d array is.

In answer to your first question: foreach is a good tool for inserting 
and pulling data from an array.

foreach($array["index1"]["index2"] as $key => $value) {

//key is the value of each index2
//value is the value assigned to the key

$sql = insert into table $key = $value;

$result = mysql_query($sql);


foreach works with a copy of the array. So you don't have to reset or 
resort the array after calling it. You should apply sorting to the 
array prior to calling foreach.

If you don't need the keys from the array, you can use this syntax:
foreach($array as $value)
which only returns each value from the index.

More information about the thelist mailing list