Creating mySQL tables using a form

Z3RatuL

Well, I tried to create tables using a php form but I run into problems... Here's the code:

$file = "tables.txt"; // the sql file that will populate all the tables, and fill them with data.

$fp = fopen($file, "r");
$read = fread($fp, filesize($file));

$tbl_result = mysql_query($read) or die(mysql_error());

mysql error: You have an error in your SQL syntax near '; INSERT INTO categories VALUES (1, 'Main News', NULL); CREATE TABLE comme' at line 6

Here's the file that has all the tables:

laserlight

Try hardcoding the query.

Do you face the same problem?

Z3RatuL

wow that's what i call quick reply!

well, yes i get the same error. there must be a way doing it but i'm not an advanced coder and i don't know how. i tried the simpe way but maybe it needs more advanced coding.

Weedpacket

Try sending each mysql command separately.

laserlight

Given that each of your queries are separated by a new line, I wonder if this will work:

// the sql file that will populate all the tables, and fill them with data
$file = "tables.txt";

$fp = fopen($file, "r");
$read = fread($fp, filesize($file));

//assume \n is the newline sequence
$read = explode("\n\n", $read);
foreach ($read as $query) {
	$tbl_result = mysql_query($query)
		OR die(mysql_error());
}

though your SQL has to be correct, of course.