public function menubackuprestore()
{
$this->load->model('nama_model');
$data['tabel'] = $this->nama_model->tampiltabel(); //AMBIL DATA TABEL-TABEL
$this->load->view('nama_view',$data);
}
public function backup()
{
$tabel = $this->input->post('tabel');
$this->load->dbutil();
$prefs = array(
'tables' => array($tabel),
'format' => 'zip',
'filename' => 'my_db_backup.sql'
);
$backup =& $this->dbutil->backup($prefs);
$db_name = 'backup-on-'. $tabel . '-' . date("d-m-Y") .'.zip'; //NAMAFILENYA
$save = 'pathtobkfolder/'.$db_name;
$this->load->helper('file');
write_file($save, $backup);
$this->load->helper('download');
force_download($db_name, $backup);
}
public function restore()
{
$this->load->helper('file');
$this->load->model('sismas_m');
$config['upload_path']="./assets/database/";
$config['allowed_types']="jpg|png|gif|jpeg|bmp|sql|x-sql";
$this->load->library('upload',$config);
$this->upload->initialize($config);
if(!$this->upload->do_upload("datafile")){
$error = array('error' => $this->upload->display_errors());
echo "GAGAL UPLOAD";
var_dump($error);
exit();
}
$file = $this->upload->data(); //DIUPLOAD DULU KE DIREKTORI assets/database/
$fotoupload=$file['file_name'];
$isi_file = file_get_contents('./assets/database/' . $fotoupload); //PANGGIL FILE YANG TERUPLOAD
$string_query = rtrim( $isi_file, "\n;" );
$array_query = explode(";", $string_query); //JALANKAN QUERY MERESTORE KEDATABASE
foreach($array_query as $query)
{
$this->db->query($query);
}
$path_to_file = './assets/database/' . $fotoupload;
if(unlink($path_to_file)) { // HAPUS FILE YANG TERUPLOAD
redirect('home/setting');
}
else {
echo 'errors occured';
}
}
public function tampiltabel()
{
return $this->db->query("show tables")->result();
}
<form action="<?php echo base_url();?>home/backup" method="post">
<select required="" name="tabel">
<?php
foreach ($tabel as $baris) { ?>
<option value="<?php echo $baris->Tables_in_db_sismas; ?>"><?php echo $baris->Tables_in_db_sismas; ?></option>
<?php } ?>
</select>
<button type="submit" >Backup Database</button>
</form>
<?php echo form_open_multipart('home/restore');?>
<input type="file" name="datafile" id="datafile" />
<button type="submit" >Upload Database</button>
</form>
'sql' => array('application/octet-stream', 'text/sql', 'text/plain','text/x-sql'),
 |
| Marsha Caesarani - Aia Satitiak Mambaok Karam Full Album |
 |
| Fatio Zaki & Yen Berlin - Angelia Full Album |
 |
| Faysal Ray - I'm Sory Baby Full Album |
Skimming adalah tindakan pencurian informasi kartu kredit atau debit dengan cara menyalin informasi yang terdapat pada strip magnetik kartu kredit atau debit secara ilegal.
Skimming adalah salah satu jenis penipuan yang masuk ke dalam metode phishing.
 |
| Fira Addinia - Surek Mandeh Full Album |
