Skip to content

Instantly share code, notes, and snippets.

@Theaxiom
Created August 10, 2010 00:40
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 Theaxiom/516394 to your computer and use it in GitHub Desktop.
Save Theaxiom/516394 to your computer and use it in GitHub Desktop.
<?php
require_once('../config/database.php');
$DbConfig = new DATABASE_CONFIG();
$username = $DbConfig->default['login'];
$password = $DbConfig->default['password'];
$hostname = $DbConfig->default['host'];
$dbname = $DbConfig->default['database'];
$filename = "../config/sql/kinspire_mysql.sql";
//connection to the database
$db = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
mysql_select_db($dbname);
$msg = false;
$sql = false;
if ($f = fopen($filename, 'r')) do {
$line = fgets($f);
$line = trim($line);
if(!@ereg('^--', $line))
{
$sql .= " " . $line;
}
} while (!feof($f));
fclose($f);
if(!$sql) {
$msg = "No queries found in $filename";
return false;
}
$queries = explode(';', $sql);
foreach($queries as $query) {
$query = trim($query);
if($query == "") {
continue;
}
if(!mysql_query($query . ';')) {
$msg = "query " . $query . " failed";
return false;
}
}
if ($msg === false) {
$msg = "Done";
}
echo $msg;
mysql_close();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment