importSQL.php

<?php

	include("helper.php");
	$errors = array();
	$goToNextStep = false;

	$host = $_SESSION['db_host'];
	$username = $_SESSION['db_user'];
	$password = $_SESSION['db_pass'];
	$database = $_SESSION['db_name'];

	// connect to database
	$con = mysql_connect($host, $username, $password);
	mysql_select_db($database, $con);
	
	// read import sql
	$import = file_get_contents("config/import.sql");
	
	$queries = array();
	PMA_splitSqlFile($queries, $import);
	
	foreach ($queries as $query)
	{
		if (!mysql_query($query['query']))
		{
			$errors[] = "<b>".mysql_error()."</b><br>(".substr($query['query'], 0, 200)."...)";
		}
	}
   
	// close connection
	mysql_close($con);
	
	// show error
	include("templates/importSQL.php");