Create mysql tables via sql file with php

bluns

Hi guys, im trying to create my tables via php using my sql files for my setup script.

I cant seem to work it out, heres what i have so far (wrong).


if($create_tables==yes)

{

$fp = @readfile("$root_dir/xxxxxx.sql");

if(!fp)

{

$error = "Could not open $root_dir/xxxxxxx.sql.<br>

     Please ensure file is uploaded with correct permissions";

 }

elseif($fp)

{



///this is what i want to use to query mysql with the sql file

mysql_query($fp);

}

}

Any ideas how to fix what i have done?

elementaluk

If your sql queries in your file are on 1 line each you could just use file() then loop through the array returned, if there not, then you could maybe (dont know though) just chuck the whole contents of the file into 1 SQL query.

oh and what the hell is readfile()? must of missed that one...
be lazy, use: file() or that other one...file_get_contents()

Drakla

$fp = @readfile("$root_dir/xxxxxx.sql");

that is just so utterly wrong - readfile returns the number of bytes it's read and throws the contents of the file out to the browser - you wanted fopen, but do like the man says and use file, or file_get_contents.

You could try running mysql with exec or backticks to load in the sql file if you're allowed it, otherwise it's one line at a time as mysql_query won't take multiple commands.