note 92694 added to function.implode
| From: | adam82s at gmail dot com | Date: | Tue, 04 Aug 2009 12:39:21 +0000 |
| Subject: | note 92694 added to function.implode | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-159081@lists.php.net to get a copy of this message | ||
Found it very useful when inserting sql/mysql rows,
<?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")
?>
Very useful when dealing with tables with many columns.
----
Server IP: 92.48.74.199
Probable Submitter: 193.128.72.68
----
Manual Page -- http://www.php.net/manual/en/function.implode.php
Edit -- https://master.php.net/note/edit/92694
Del: integrated -- https://master.php.net/note/delete/92694/integrated
Del: useless -- https://master.php.net/note/delete/92694/useless
Del: bad code -- https://master.php.net/note/delete/92694/bad+code
Del: spam -- https://master.php.net/note/delete/92694/spam
Del: non-english -- https://master.php.net/note/delete/92694/non-english
Del: in docs -- https://master.php.net/note/delete/92694/in+docs
Del: other reasons-- https://master.php.net/note/delete/92694
Reject -- https://master.php.net/note/reject/92694
Search -- https://master.php.net/manage/user-notes.php