|
|
Posted by strawberry on 11/03/06 23:45
In the function below, I'd like to extend the scope of the $table
variable such that, once assigned it would become available to other
parts of the function. I thought 'global $table;' would solve this but
it's clear that I'm misunderstanding $variable persistence. I posted a
similar enquiry over at alt.php.mysql, but I guess this is a more
appropriate forum because the problems I'm having relate to PHP.
Any help appreciated.
$function array_to_mysql($array) { //1 define the function
if(is_array($array)){ //2 if $array is indeed an array
foreach($array as $key=>$value){ //3 foreach key/value pair
within the array
if(is_array($value)){ //4 either the current value
is itself an array
array_to_mysql($value); //5 (so call this function again
to process that array)
} else { //6 or it isn't
if($key == 'name'){ //7 (in which case, if the key
paired with that value = 'name'
$table = $value; //8 then assign that value to
$table)
} elseif //9 or else
($key == 'ID'){ //10 (if the key paired with
that value = 'ID'
$parent = $value;}else{ //11 then assign that value to
$parent
echo "INSERT INTO $table ($key) VALUES ('$value') ON DUPLICATE KEY
UPDATE <BR>\n";}
if(!is_null($parent)){ //13 Finally, if $parent is
assigned issue the following
echo "INSERT INTO $table (ID) VALUES ('$parent') ON DUPLICATE KEY
UPDATE<BR>\n";
}
}
}
}
}
Apologies if the formatting gets stuffed up in the posting. TIA
Navigation:
[Reply to this message]
|