regular expression problem

I have a file where is structure of one database. The file looks like this:

Structure for table 'name1'

CREATE TABLE (

);

CREATE TABLE (

);

My problem is that I want to read that file into a string (which is done) and grap those CREATE TABLE (); parts into an array.

I have tried to do this whole day with out success. I really appriciate some help. Thanks!

<?php
// String with SQL is $sql

preg_match('/(CREATE[[:space;]]TABLE\(.\);)/e', '$sql2[] = \\1', $sql);
?>

See if that works.

It's matching CREATE TABLE (any characters); and adding it to $sql2.

Note: Be sure to escape the ( and ) after 'TABLE.'

I have had no futrher luck 🙁

Regular Expression which I currently have is following kind:

preg_match_all("/CREATE TABLE.+/", $file_content, $m);

This gives me following kind of result (took from print_r output):

[0] => CREATE TABLE name1 (
[1] => CREATE TABLE name2 (

The problem seems to be ';'. If I add it the whole match fails. Does anyone have tips?

Look into the pattern modifiers...I think you have to use /s.

Diego

Originally posted by diego25
Look into the pattern modifiers...I think you have to use /s.

If I modify it like this:

preg_match_all("/CREATE TABLE.+/s", $file_content, $m);

it will read the who SQL table, but it doesn't work correctly. It reads both of the tables into same place.

[0] => CREATE TABLE name1 (......
CREATE TABLE name2 (......

I need to get from that file all SQL-tables into an array like this:

$tables = array(
[1] => "table1",
[2] => "table2");

Hopefully someone understands my odd thoughts 🙂

This works for me:
<?php

$sql = "CREATE TABLE table1 (
blah blah);

CREATE TABLE table2 (
blah blah);
";

preg_match_all('/CREATE TABLE (.*) (/', $sql, $m);
print_r($m);
?>

Diego