Run a whole sql code with php?

[runiker]

Is there a way to run a sql code (a .sql file thats found on website as well) with php what i want is to be able to click a button and then it run the code.

[Sirupsen]

Remember, before doing this - connect to MySQL first.

$sql = 'CREATE TABLE `Sample Tabel` ('
        . ' `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, '
        . ' `something1` VARCHAR(255) NOT NULL, '
        . ' `something2` TEXT NOT NULL, '
        . ' `something3` LONGTEXT NOT NULL, '
        . ' `time` TIMESTAMP NOT NULL'
        . ' )'
        . ' ENGINE = myisam;'; 

Is our SQL code. To execute this SQL code from PHP, run it in a SQL Query:

$insert = mysql_query($sql); 

So, the entire code would look like this obviously

$sql = 'CREATE TABLE `Sample Tabel` ('
        . ' `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, '
        . ' `something1` VARCHAR(255) NOT NULL, '
        . ' `something2` TEXT NOT NULL, '
        . ' `something3` LONGTEXT NOT NULL, '
        . ' `time` TIMESTAMP NOT NULL'
        . ' )'
        . ' ENGINE = myisam;';

$insert = mysql_query($sql); 

Remember to connect to your database before doing this!

So, to execute the stuff when you click a button, try something like this (not tested)

<form method="post" name="form" action="?create=1">
<input type="submit" name="submit" value="Create">
</form>
<?
if ($_GET["create"] == "1") {
$sql = 'CREATE TABLE `Sample Tabel` ('
        . ' `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, '
        . ' `something1` VARCHAR(255) NOT NULL, '
        . ' `something2` TEXT NOT NULL, '
        . ' `something3` LONGTEXT NOT NULL, '
        . ' `time` TIMESTAMP NOT NULL'
        . ' )'
        . ' ENGINE = myisam;';

$insert = mysql_query($sql);

echo "Sucessfully added the table.";
}
?>

[Blazeme]

With mySQL query function (mysql_query) you can only run ONE query, for example you cannot run:
mysql_query("INSERT ... VALUES (1,223); Update ... SET a=b WHERE c=1");
To run multiple queryes you need to do explode() and then foreach.
Of course, to explode you need to have some kind of seprarator (you can use ; for this one), no new lines (str_replace("\n","",$sql) and etc.

[1337php]

If you can I would just download SQLYog, make a mysql user that you can connect to remotely and just execute the batch. You could also just upload phpmyadmin to the server and execute it that way. PMA has a file limit though and it tends to screw up sometimes.

[visitor]

Sirupsen:
that's not what runiker wanted
1337php:
in php. not sqlyog

[runiker]

Actually this is kinda want i needed i wanted to make a page that runs an sql in order to make some gm tools work and stuff like that kinda like if you ever used phpbb3 how they have there set up button.