note 63605 added to function.mysql-query

Mysql version of multi-query. Well treated the "';' inside quotes" case (I hope there is no bug!). <?php //mysql query (multi-query) function mysql_multi_query($querystr, $link = NULL) { //seperate the queries by ';' (but not ';' inside quotes) $pattern = "/((('([^\\\\']*(\\\\.)*)*'|". "\"([^\\\\\"]*(\\\\.)*)*\")+[^;'\"]*|". "[^;'\"]+('([^\\\\']*(\\\\.)*)*'|". "\"([^\\\\\"]*(\\\\.)*)*\")*)+)/s"; preg_match_all($pattern, $querystr, $out); $queries = $out[0]; foreach ($queries as $query) if(($query = trim($query)) != '') { if ($link == NULL) $result = mysql_query($query); else $result = mysql_query($query, $link); if(!result) return false; } return $result; //return last result } ?> ---- Server IP: 61.195.146.164 Probable Submitter: 220.58.70.54 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit -- http://master.php.net/note/edit/63605 Del: integrated -- http://master.php.net/note/delete/63605/integrated Del: useless -- http://master.php.net/note/delete/63605/useless Del: bad code -- http://master.php.net/note/delete/63605/bad+code Del: spam -- http://master.php.net/note/delete/63605/spam Del: non-english -- http://master.php.net/note/delete/63605/non-english Del: in docs -- http://master.php.net/note/delete/63605/in+docs Del: other reasons-- http://master.php.net/note/delete/63605 Reject -- http://master.php.net/note/reject/63605 Search -- http://master.php.net/manage/user-notes.php