note 66759 deleted from function.mysql-query by bjori
| From: | bjori@php.net | Date: | Sun, 28 May 2006 10:58:00 +0000 |
| Subject: | note 66759 deleted from function.mysql-query by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-112433@lists.php.net to get a copy of this message | ||
Note Submitter: keithwkljp at yahoo dot co dot jp
----
Mysql version of multi_query. Unaffected by the ';'s inside quotes.
<?php
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
}
?>