Merging two arrays into an associative array?

[opeth02]

Hi

I have two arrays

$in_fields="id, name, cost, description";
$in_values="$id, $name, $cost, $description";

and I want to merge them into one associative array i.e.

$assocarr= array ( id => $id, name => $name, etc, etc );

I've looked through the php manual and I couldn't find anything but I'm sure there is a simple function - can anyone help?

Thanks
Rob.

[diego25]

I don't think there's a simple function that will do that for you, but you can use explode() to give you each item, and then use a for loop (or foreach loop) to create the associative array. Something like this:

<?
$in_fields="id, name, cost, description";
$in_values="$id, $name, $cost, $description"; 

$in_fields2 = explode(',', $in_fields);
$in_values2 = explode(',', $in_values);

for ($i = 0; $i<count($in_fields2); $i++) {
 $array[$in_fields2[$i]] = trim($in_values2[$i]);
}
?>

Diego

[opeth02]

Thanks!

Now I have this code:

$in_fields=explode(",", $in_fields);
$in_values=explode(",", $in_values);

$query="UPDATE $type SET";

$in_fields2 = explode(',', $in_fields);
$in_values2 = explode(',', $in_values);

for ($i = 0; $i<count($in_fields2); $i++) {
	$array[$in_fields2[$i]] = trim($in_values2[$i]);
}

foreach ($array as $key=>$val)
{
	$query .= " $key=\"$val\",";
}

$query=substr($query, 0, strlen($query)-1);
$query.=" WHERE id=$id";
mysql_query($query);

The problem is that it makes $query look like this:

UPDATE cdrom SET Array="Array" WHERE id=540411

What am I doing wrong?

Thanks
Rob.

[diego25]

The problem is you're doing the explode() twice...just do it once.

Diego

[opeth02]

:eek: Can't believe I didn't notice that!

Thanks! It works perfectly now 🙂

Rob.