Script to Create DB and Tables

[stoneygossard]

Hi,

I am wondering, is it possible to write the sql within a php file that, when uploaded to the server, will magically create the database along with all the tables and fields specified in the sql code within the php file?I know this is prob possible but do you need to save the file as some kind of .exe or something to make it a kind of "sql installer file"?

And are there any example of same source code floating round the web?

Regards

Stoney

[notaloser]

yes it is possible, but it is regular php code that can create the tables and everything as soon as you run it on the server..

i think that you should read up on php and mysql some using these resources rather than posting multiple easily-answered threads..

www.w3schools.com www.php.net www.mysql.com

in your case, heres an example of a code that will create a database and table when run..

$query = mysql_query("CREATE DATABASE database_name");
mysql_select_db("database_name");
$query2 = mysql_query("CREATE TABLE Person (LastName varchar(30), FirstName varchar, Address varchar, Age int(3) )";

will create a database named database_name, select it, and create a table named Person with the fields LastName maximum 30 characters, Firstname, Address, and Age maximum 3 integers