note 92694 added to function.implode

From: 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

« previous php.notes (#159081) next »