Ahhhh, I was wondering why your variable was named insert.
Anyway, that's easy too.
foreach($insert as $table => $fields) {
$fieldList = array_keys($fields);
$fieldNames = implode(',', $fieldList);
$fieldValues = '"'.implode('","', $fields).'"';
echo 'insert into '.$table.' ('.$fieldNames.') values ('.$fieldValues.')';
}
That puts double quotes around the values. I always use single quotes around my text pieces since PHP doesn't parse what's inside them, thus it's supposed to be faster.
On Jan 11, 2005, at 10:42 AM, Benjamin Edwards wrote:
Ok - looking at what you did I cant see any diference apart from turning a serious updated into a single update. This is usefull if I want to do an update but I actualy want an insert (the update was just used for this example).
I actualy want to do an insert so i'me thinking the following would work:-
foreach ($insert as $table => $fields) {
foreach($fields as $field => $value) {
$columns[] = $field;
$values[] = "'".$value."'";
}
echo
"insert into $table ( ".implode( ', ', $columns ).
" values ( ".implode( ', ', $values )." ) ";
unset($columns);
unset($values);
}
Ben
>>> Brent Baisley <brent@xxxxxxxxxxxx> 01/11/05 03:02pm >>>
You've created a 2x2 array, not a 1x4, which might be confusing you:
tab2 ["fields1"] ["fields5"]
tab1 ["fields2"] ["fields7"]
You almost have it, you just need to set your loop up to handle
unlimited field/value pairs in your array.
One option is to structure your loop like this:
foreach ($insert as $table => $fields) {
foreach($fields as $field => $value) {
$fieldValuePairs[] = "$field = $value";
}
$fieldValueStr = implode(',', $fieldValuePairs);
echo "update $table set $fieldValueStr";
unset($fieldValuePairs);
}
On Jan 11, 2005, at 6:22 AM, Benjamin Edwards wrote:
> If I create the following 2 dimensional associative array:-
>
> $insert["tab2"]["fields1"] = "value1";
> $insert["tab1"]["fields2"] = "value2";
> $insert["tab2"]["fields5"] = "value3";
> $insert["tab1"]["fields7"] = "value4";
>
> how do I do 2 levels of nested loop with the first level looping
> through the first level of the array and the second nesting through
> the second. something like:-
>
> foreach( $insert as $table => $fields ) {
> foreatch( $fields as $field => $value ) {
> echo "update $table set $field = $value";
> }
> }
>
> Regards,
> Ben
>
>
>
>
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email and any files transmitted with it are confidential. It is for the intended recipient only. If you have received the email in error please notify the author by replying to this email. If you are not the intended recipient, you must not disclose, distribute, copy, print, or rely on this email. Any views expressed by an individual within this email which do not constitute or record professional advice relating to the RNLI, do not necessarily reflect the views of the organisation.
Registered Charity Number 209603
<image.tiff>
<image.tiff>
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
