note 92693 added to function.implode

From: Date: Tue, 04 Aug 2009 12:36:22 +0000
Subject: note 92693 added to function.implode
Groups: php.notes 
Request: Send a blank email to php-notes+get-159080@lists.php.net to get a copy of this message
Found it very useful when inserting sql/mysql rows, $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/92693 Del: integrated -- https://master.php.net/note/delete/92693/integrated Del: useless -- https://master.php.net/note/delete/92693/useless Del: bad code -- https://master.php.net/note/delete/92693/bad+code Del: spam -- https://master.php.net/note/delete/92693/spam Del: non-english -- https://master.php.net/note/delete/92693/non-english Del: in docs -- https://master.php.net/note/delete/92693/in+docs Del: other reasons-- https://master.php.net/note/delete/92693 Reject -- https://master.php.net/note/reject/92693 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#159080) next »