public function restore_db() { $db = new Backuprestore(); $db->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); // if(!move_uploaded_file($_FILES['file']['tmp_name'])){ // switch($_FILES['file']['error']){ // case 1: // echo "file to large"; // break; // case 2: // echo "file larger than set in form (MAX_FILE_SIZE)"; // break; // case 3: // echo "partial upload"; // break; // case 4: // default: // echo "file not uploaded (unknown)"; // } // } // if (isset($_POST['sb_restore'])) { if (!empty($_FILES['file']['name'])) { if ($db->getlast($_FILES['file']['name']) == 'sql') { echo $db->getlast($_FILES['file']['name']); $tempFile = $_FILES['file']['tmp_name']; $targetFile = 'public/temp/' . $_FILES['file']['name']; move_uploaded_file($tempFile, $targetFile); $db->restoreDatabaseSql($targetFile); } elseif ($db->getlast($_FILES['file']['name']) == 'zip') { $tempFile = $_FILES['file']['tmp_name']; //echo $tempFile; $targetFile = 'public/temp/' . $_FILES['file']['name']; //echo $targetFile; move_uploaded_file($tempFile, $targetFile); $db->restoreDatabaseZip($targetFile); } else { echo "Invalid Database File Type"; } } // } /* * ubah nama admin dan password admin, * mengantisipasi lupa password setelah restore */ $sql = "SELECT KD_USER FROM d_user WHERE AKSES_USER=1"; $data = $this->registry->db->select($sql); $id = 0; foreach ($data as $val) { $id = $val['KD_USER']; } $data_admin = array('NM_USER' => 'admin', 'PASS_USER' => Hash::create('sha1', 'admin', HASH_SALT_KEY)); $where = ' id_user='******'d_user', $data_admin, $where); echo "<div id=success>restore data telah berhasil dilakukan, " . $_SESSION['ttlQuery'] . " query dieksekusi pada " . date('Y-m-d H:i:s', $_SESSION['timeQuery']) . "</div>"; // $this->view->render('admin/restore_db'); }
public function restore() { $db = new Backuprestore(); $db->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); if (isset($_POST['submitRestoreDB'])) { if (!empty($_FILES['file']['name'])) { if ($db->getlast($_FILES['file']['name']) == 'sql') { echo $db->getlast($_FILES['file']['name']); $tempFile = $_FILES['file']['tmp_name']; $targetFile = 'public/temp/' . $_FILES['file']['name']; move_uploaded_file($tempFile, $targetFile); $db->restoreDatabaseSql($targetFile); } elseif ($db->getlast($_FILES['file']['name']) == 'zip') { $tempFile = $_FILES['file']['tmp_name']; $targetFile = 'public/temp/' . $_FILES['file']['name']; move_uploaded_file($tempFile, $targetFile); $db->restoreDatabaseZip($targetFile); } else { echo "Invalid Database File Type"; } } } /* * ubah nama admin dan password admin, * mengantisipasi lupa password setelah restore */ $sql = "SELECT id_user FROM user WHERE role=5"; $data = $this->model->select($sql); $id = 0; foreach ($data as $val) { $id = $val['id_user']; } $data_admin = array('username' => 'admin', 'password' => Hash::create('md5', 'admin', HASH_SALT_KEY), 'active' => 'Y'); $where = ' id_user='******'user', $data_admin, $where); $this->view->message = "<div id=success>restore data telah berhasil dilakukan, " . $_SESSION['ttlQuery'] . " query dieksekusi pada " . date('Y-m-d H:i:s', $_SESSION['timeQuery']) . "</div>"; $this->view->render('admin/restore/restore'); }