Loading .sql files from within PHP

by 
$db = new PDO($dsn, $user, $password);

$sql = file_get_contents('file.sql');

$qr = $db->exec($sql);

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Im trying to create some temporary tables in mysql using php
  5. How can I prevent SQL injection in PHP?
  6. SQL injection that gets around mysql_real_escape_string()
  7. How to include a PHP variable inside a MySQL statement
  8. How to apply bindValue method in LIMIT clause?
  9. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  10. selecting unique values from a column
  11. Import CSV file directly into MySQL
  12. I cannot get my login form to connect interact properly with mySQL database [closed]
  13. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  14. Increment value in MySQL update query
  15. Create a dynamic mysql query using php variables
  16. How to separate DATE and TIME from DATETIME in MySQL?
  17. Do SQL connections opened with PDO in PHP have to be closed
  18. How to convert ISO8601 to Date format in php
  19. MySQL skipping first row
  20. How to reverse order output of a MySQL query
  21. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  22. How to generate unique id in MySQL?
  23. Fatal error: Call to a member function query() on null
  24. How would I implement a simple site search with php and mySQL?
  25. How to check if a value already exists to avoid duplicates?
  26. how do I get month from date in mysql
  27. php/mysql zip code proximity search
  28. Updating column so that it contains the row position
  29. MYSQL select a piece of a string and order by that piece
  30. Aggregated query without GROUP BY

Leave a Comment