mysql split multiquery string with php

Question

I want to make a database restore function that will parse a dump made with phpMyAdmin and will execute all of the queries.

I already have a MySQL class that does the query, but it only knows how to do a single query. I am looking of a way to split the file content into single queries.

I tried to play with preg_split ... but didn't managed to get it to work.

$queries = preg_split('/[(.+);\s*\n/', $content, -1, PREG_SPLIT_NO_EMPTY);

I am not very good with regular expressions. Is there a way I can accomplish my goal?

Community · Accepted Answer · 2017-05-23 12:19:45Z

5

don't try to parse sql with regular expressions. what if there is a ; somewhere inside a sql string?

i would try http://pear.php.net/package/SQL_Parser, or any of the other php mysql parsers out there. see also PHP MySQL SQL parser (INSERT and UPDATE) here on SO.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Mar 27, 2009 at 11:02

ax.

60.4k9 gold badges85 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Guy Fawkes · Accepted Answer · 2012-01-11 07:58:19Z

0

I think splitting in comments above will make bad strings when you have stored procedures, functions or triggers in $content.

answered Jan 11, 2012 at 7:58

Guy Fawkes

2,4513 gold badges24 silver badges41 bronze badges

Comments

marc_s · Accepted Answer · 2013-02-11 21:52:15Z

0

Eventually I managed to find the right regex:

$queries = preg_split('/[.+;][\s]*\n/', $content, -1, PREG_SPLIT_NO_EMPTY);

it splits the query after the ; sign and does not break even if the query spreads on multiple rows or the query contains ; since it looks for it at the end of a line.

edited Feb 11, 2013 at 21:52

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 27, 2009 at 12:04

Gabriel Solomon

30.4k17 gold badges59 silver badges81 bronze badges

Collectives™ on Stack Overflow

mysql split multiquery string with php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related