PHP B_DBController Beispiele

Beispiel #1

Datei: export.php Projekt: Ahmed-Badawy/DB-Backup

<?php

require "B_DBController.php";
$config_array = ["db_host" => "localhost", "db_name" => "shopjavaproject", "db_user" => "root", "db_pass" => ""];
$obj = new B_DBController($config_array);
$output_dir = __DIR__ . "/backups";
// directory files
$output_name = time() . "-" . $obj->db_name;
// output name sql backup
//$output = $obj->backup_database($output_dir,$output_name)->generate_download_file();
$output = $obj->backup_database($output_dir, $output_name)->save_gzip_file();
// $output = $obj->backup_database($output_dir,$output_name)->save_sql_file();
// $obj->show_all_tables();

Beispiel #2

Datei: remoteController.php Projekt: Ahmed-Badawy/DB-Backup

<?php

$input = $_POST;
require "B_DBController.php";
$config_array = ["db_host" => $input['host'], "db_name" => $input['db'], "db_user" => $input['user'], "db_pass" => $input['pass']];
$obj = new B_DBController($config_array);
$output_dir = __DIR__ . "/backups";
// directory files
$output_name = time() . "-" . $obj->db_name;
// output name sql backup
//var_export($config_array);die;
if ($input['type'] == "download") {
    $output = $obj->backup_database($output_dir, $output_name)->generate_download_file();
}
if ($input['type'] == "save_gzip") {
    $output = $obj->backup_database($output_dir, $output_name)->save_gzip_file();
}
if ($input['type'] == "save_sql") {
    $output = $obj->backup_database($output_dir, $output_name)->save_sql_file();
}
if ($input['type'] == "test") {
    $output = $obj->backup_database($output_dir, $output_name)->backup_data;
}
// $obj->show_all_tables();
echo "<pre>";
var_export($output);
die;

Beispiel #3

Datei: import.php Projekt: Ahmed-Badawy/DB-Backup

<?php

require "B_DBController.php";
$config_array = ["db_host" => "localhost", "db_name" => "test", "db_user" => "root", "db_pass" => ""];
$obj = new B_DBController($config_array);
$sql_file_name = "1.sql";
$full_directory = __DIR__ . "/backups/" . $sql_file_name;
$sql_string = file_get_contents($full_directory);
// get contents
//	echo "<pre>";var_export($sql_string);die;
$obj->drop_all_tables();
$obj->mysqli_import_sql($sql_string);