[PHP] Concatenate PHP code into a string

2004-06-28 Thread abrea 
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

Re: [PHP] Concatenate PHP code into a string

2004-06-28 Thread Michal Migurski 
 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:
-snip-

   /** {{{2
* create an INSERT or UPDATE query based on values of an associative array,
* where keys are the column names to be modified.
*
* @param   arrayvalues an associative array
* @param   string   table  the table name
* @param   string   type   the query type, currently only 'INSERT' or
*  'UPDATE'
* @return  mixed   a SQL query string on success, false otherwise (e.g., no
*  keys found matching valid column names)
*/
function array_to_query($values, $table, $type) // {{{3
{
if(!is_array($values)) return false;

foreach($values as $col = $val) {
$values[$col] = db::quote($val);
if(is_null($val)) unset($values[$col]);
}

switch($type) {

case 'INSERT':
$query = sprintf('INSERT INTO %s (%s) VALUES (%s)', $table, 
join(',', array_keys($values)), join(',', $values));
break;

case 'UPDATE':
foreach($values as $col = $val)
$values[$col] =  ${col} = ${val};

$query = UPDATE $table SET  . join(',', $values);
break;

default:
trigger_error(Unrecognized query type '$type' supplied to 
db_array_to_query(), E_USER_WARNING);
return false;

}

return $query;
}

-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html

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