Running an SQL File and having PHP Execute it

[Twister1004]

Hey everyone,

 

I have an SQL file called "Cype.sql" and I was wanting to have it run when the install feature is going on. However I can't seem to figure out why exactly the code is not working.

 

is it possible to have it run without getting too in depth the PHP coding?  I'm not OOP Literate yet.

 

//Connection is opened
//While in installation file


$sqlFile = "Cype.sql";

if(!file_exists($sqlFile)){
echo "File not found";
}
else{
$openFile = fopen($sqlFile, "r");
$tryQuery = mysql_query($openFile);
}

 

Now obviously, I'm not the best coder. I've been out of the works of PHP for quite some time now as well.

However, I have researched it and found no answers to my issue.

 

 

Any help would be greatly appreciate. Thank you.

[Buddski]

Currently, you are only opening the file. You arent telling PHP to read it..

file_get_contents() will read the contents of a file for you.

[Twister1004]

Thank you very much Buddski!

 

Now for another question:

is there a way for the mysql_query to execute multiple SQL querys in one file?

[Buddski]

mysql_query does not support multiple queries.

You will have to loop through each query in your file and run them individually.

[Twister1004]

Now onto figuring that out!

 

Thank you very much!