PHP/MySQL execute prepared statements stored in files

[L4DD13]

Hi,

I have a .sql file which contains the following;

• Setting variable
• Prepared statements generation
• Prepared statement execution

I've tried using file_get_contents() and mysql load data infile (I may be using it for the wrong task).

How would I execute this file?

Cheers,
Michael

[ServerStorm]

Hi Michael,

Normally SQL is not read from file like you have setup. If sql does come from a file it is commonly just the statements to execute but not the connector prepared statements or execution.

If you need to read from a file you would typically do something like:

1. read sql statements from file into a variable, say $sql;
2. next, use this in your php page.

   $sql = file_get_contents(select_companies.sql);
   $stmt = $o_Db->prepare($sql);
   $result = $stmt->execute(); 

Your select_companies.sql might look like:

SELECT
  comany_id
  , company_name
FROM
 companies

This is a bit of a shot in the dark as you did not show any of your files that you read from or the code that you are using.

Regards,
Steve