note 106071 modified in function.implode by danbrown
| From: | danbrown@php.net | Date: | Fri, 07 Oct 2011 14:38:36 +0000 |
| Subject: | note 106071 modified in function.implode by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-183708@lists.php.net to get a copy of this message | ||
for dealing with tables:
<?php
$values =
array('firstname'=>'firstname_value','lastname'=>'lastname_value');
sprintf('INSERT INTO %s (%s) VALUES ("%s")', 'table_name',
implode(', ', array_map('mysql_escape_string', array_keys($values))),
implode('", "',array_map('mysql_escape_string', $values)));
//that gives you: INSERT INTO table_name (firstname, lastname) VALUES ("firstname_value",
"lastname_value")
?>
--was--
for dealing with tables:
<?php
$values =
array('firstname'=>'firstname_value','lastname'=>'lastname_value');
sprintf('INSERT INTO %s (%s) VALUES ("%s")', 'table_name',
implode(', ', array_map('mysql_escape_string', array_keys($values))),
implode('", "',array_map('mysql_escape_string', $values)));
//that gives you: INSERT INTO table_name (firstname, lastname) VALUES ("firstname_value",
"lastname_value")
?>-
http://php.net/manual/en/function.implode.php