PHP/MySQL execute prepared statements stored in files

PHP
1

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

2

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:[LIST=1]
[]read sql statements from file into a variable, say $sql;
[]next, use this in your php page.
[/LIST]


   $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