<?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();
<?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;
<?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);