Skip to content

Instantly share code, notes, and snippets.

@tborychowski

tborychowski/import_sql_file_to_db.php

Created October 11, 2012 14:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tborychowski/3872588 to your computer and use it in GitHub Desktop.
Save tborychowski/3872588 to your computer and use it in GitHub Desktop.
Download ZIP
PHP :: Import SQL file to DB
Raw
import_sql_file_to_db.php
// import sql file
$file_content = file('updates.sql');
$query = "";
foreach($file_content as $sql_line){
if(trim($sql_line) != "" && strpos($sql_line, "--") === false){
$query .= $sql_line;
if (substr(rtrim($query), -1) == ';'){
$result = $dbo->dbEdit($query);
echo $query.'<br>Result: '.($result==1?'OK':$result).'<br><br><br>';
$query = "";
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment