Execute a .sql file using a php script?

K

kpa4941

New member
Is there some possible command that I can use in my php file while it is connected to a database to execute a .sql/.txt file with the query information in the same directory?

Something like mysql> source file_name
won't work

More like mysql_connect("localhost", $conusername, $conpassword);

Thank you.
 
you need to read the file into memory first.

so more like this:

$queryFileName = "c:\myquery.sql";
$queryFileHandle = fopen($queryFileName, "r");

$query = ''; // that's two single quotes not a double-quote
while ($newLine = fgets($queryFileHandle)) {
$query .= $newLine;
}
fclose($queryFileHandle);

$dbHandle = mysql_connect("localhost", $conusername, $conpassword);

$result = mysql_query($query, $dbHandle);
 
Back
Top