multi-lines mysql script

How to run thme with PHP?

Pawel

"Pawe³" <koral21@poczta.onet.pl> wrote
in message news:<bek1bv$nut$3@news.onet.pl>...
>
> How to run thme with PHP?

The simplest way is this:

exec ('mysql -u user -p password dbname < script.sql');

If MySQL command line is not available, you can try
something like this:

// let's pretend we already connected to the server
// and selected the database...
$SQL = explode(';', implode ('', file ('file.sql')));
foreach ($SQL as $query) {
$result = mysql_query ($query)
or die ('The query: ' . $query . '<br>failed: ' . mysql_error());
}

Obviously, it assumes that there are no semicolons in data, which
may be a bit unrealistic...

Cheers,
NC

> > How to run thme with PHP?
>
> The simplest way is this:
>
> exec ('mysql -u user -p password dbname < script.sql');
>
> If MySQL command line is not available, you can try
> something like this:
>
> // let's pretend we already connected to the server
> // and selected the database...
> $SQL = explode(';', implode ('', file ('file.sql')));
> foreach ($SQL as $query) {
> $result = mysql_query ($query)
> or die ('The query: ' . $query . '<br>failed: ' . mysql_error());
> }
>
> Obviously, it assumes that there are no semicolons in data, which
> may be a bit unrealistic...
>
But I like the idea. The next question is whether when I several times call
mysql_query what happens with mysql variables?

Pawel