[PHP] Re: Concatenate PHP code into a string

[Torsten Roehr]

Abrea [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Dear List,
 How can I include a dynamically generated array:
 e.g. for($i=0; $isizeof($cols); $i++)
   { $cols[$i]= mysql_field_name($fields,$i); }

 into a MySQL insert query of the type:
 $sql= INSERT cols[0],cols[1],cols[2], ..., comment
 INTO mytable SET
 cols[0]= '$cols[0]',
 cols[1]= '$cols[1]',
 cols[2]= '$cols[2]',
 cols[...]= '$cols[...]',
 comment= '$comment';

 The number of $cols is different for each table.
 Thanks in advance for any help


Hi Alberto,

do your columns change so often that you have to dynamically deal with them?
This requires a DB query every time just to find out the column names!

An easier way would be to setup an array where the key is the column name
and the value is your value to insert. Then you could just do:

$values = array('field1' = 'myValue', 'field2' = 25);

$query = 'INSERT INTO table SET ';
$set = '';

foreach ($values as $column = $value) {
$set .= (empty($set)) ? $column = '$value' : , $column = '$value';
}

$query .= $set;
...

Regards, Torsten Roehr

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Concatenate PHP code into a string

[franciccio]

$query=INSERT+ ;
for ($i=0;$isizeof($col);$i++) {
$query+=cols[$i]+ ;
}
$query+=comment INTO mytable SET;

for ($i=0;$isizeof($col);$i++) {
$query+=cols[$i]+=+$cols[$i]+,;
}

Bye
Franciccio


Abrea [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
 Dear List,
 How can I include a dynamically generated array:
 e.g. for($i=0; $isizeof($cols); $i++)
   { $cols[$i]= mysql_field_name($fields,$i); }

 into a MySQL insert query of the type:
 $sql= INSERT cols[0],cols[1],cols[2], ..., comment
 INTO mytable SET
 cols[0]= '$cols[0]',
 cols[1]= '$cols[1]',
 cols[2]= '$cols[2]',
 cols[...]= '$cols[...]',
 comment= '$comment';

 The number of $cols is different for each table.
 Thanks in advance for any help

 Alberto Brea

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php