PHP load_db_dump Examples

Example #1

File: system.php Project: mprihodko/converter_users_joomla_to_wp

function create_config()
{
    $error = '';
    if (isset($_POST['create_config'])) {
        @($sql = mysql_pconnect($_POST['db_host'], $_POST['db_user'], $_POST['db_password']));
        $dbselect = mysql_select_db($_POST['db_name']);
        if ($sql && $dbselect) {
            $fp = fopen(PATH_TO_DIR . '/core/config.php', 'w');
            $fc = '<?php 
	define("DB_NAME", "' . $_POST['db_name'] . '"); 
	define("DB_HOST", "' . $_POST['db_host'] . '"); 
	define("DB_USER", "' . $_POST['db_user'] . '"); 
	define("DB_PASSWORD", "' . $_POST['db_password'] . '"); 
?>';
            $fw = fwrite($fp, $fc);
            fclose($fp);
            load_db_dump(PATH_TO_DIR . '/assets/wp_to_joomla.sql', $_POST['db_host'], $_POST['db_user'], $_POST['db_password'], $_POST['db_name']);
        } else {
            $_SESSION['db_error'] = "Check the settings for the database connection";
        }
    }
}

Example #2

File: db_upload.php Project: mprihodko/compiler

<?php

/*DB CHECKER*/
load_db_dump();
delete_files_install();
function load_db_dump($file, $sqlserver, $user, $pass, $dest_db)
{
    $sql = mysql_connect($sqlserver, $user, $pass);
    $result = mysql_list_tables($dest_db);
    while ($table = mysql_fetch_array($result)) {
        $query = "DROP TABLE `" . $table[0] . "`";
        mysql_query($query);
    }
    $a = file($file);
    foreach ($a as $n => $l) {
        if (substr($l, 0, 2) == '--') {
            unset($a[$n]);
        }
    }
    $a = explode(";\n", implode("\n", $a));
    unset($a[count($a) - 1]);
    foreach ($a as $q) {
        if ($q) {
            if (!mysql_query($q)) {
                echo "Fail on '{$q}'";
                mysql_close($sql);
                return false;
            }
        }
    }
    mysql_close($sql);