Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
.git	[ DIR ]	drwxrwxrwx	2025-04-27 13:16
.well-known	[ DIR ]	drwxrwxrwx	2024-09-05 02:01
asset	[ DIR ]	drwxrwxrwx	2025-04-27 15:34
include	[ DIR ]	drwxrwxrwx	2025-04-20 13:23
resource	[ DIR ]	drwxrwxrwx	2025-04-21 15:02
save	[ DIR ]	drwxrwxrwx	2025-04-21 13:47
upload	[ DIR ]	drwxrwxrwx	2025-02-11 02:56
Backup_13_Jan_2025_1736756652.sql	0 B	-rw-rw-rw-	2025-04-20 13:22
README.md	1.52 KB	-rw-rw-rw-	2024-09-07 01:58
admin.php	6.35 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_keluar.php	17 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_masuk.php	17.09 KB	-rw-rw-rw-	2024-09-04 22:54
backup.php	9.09 KB	-rw-rw-rw-	2024-09-04 22:54
cetak_disposisi.php	12.88 KB	-rw-rw-rw-	2024-09-04 22:54
disposisi.php	11.53 KB	-rw-rw-rw-	2024-09-04 22:54
edit_disposisi.php	12.92 KB	-rw-rw-rw-	2024-09-04 22:54
edit_klasifikasi.php	9.94 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_keluar.php	22.76 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_masuk.php	23.54 KB	-rw-rw-rw-	2024-09-04 22:54
edit_tipe_user.php	8.92 KB	-rw-rw-rw-	2024-09-04 22:54
enable-javascript.html	3.4 KB	-rw-rw-rw-	2024-09-04 22:54
file_sk.php	10.32 KB	-rw-rw-rw-	2024-09-04 22:54
file_sm.php	10.61 KB	-rw-rw-rw-	2024-09-04 22:54
fti-aset.sql	37.22 KB	-rw-rw-rw-	2024-09-05 02:19
galeri_sk.php	17.88 KB	-rw-rw-rw-	2024-09-04 22:54
galeri_sm.php	17.91 KB	-rw-rw-rw-	2024-09-04 22:54
google3afbb06bed30a512.html	53 B	-rw-rw-rw-	2025-04-27 15:35
hapus_disposisi.php	4.86 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_klasifikasi.php	4.15 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_keluar.php	6.94 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_masuk.php	7.02 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_user.php	5.49 KB	-rw-rw-rw-	2024-09-04 22:54
index.php	11.43 KB	-rw-rw-rw-	2024-09-04 22:54
kode.php	847 B	-rw-rw-rw-	2025-02-01 14:35
logout.php	92 B	-rw-rw-rw-	2024-09-04 22:54
pengaturan.php	25.78 KB	-rw-rw-rw-	2024-09-04 22:54
profil.php	15.59 KB	-rw-rw-rw-	2024-09-04 22:54
referensi.php	22.04 KB	-rw-rw-rw-	2024-09-04 22:54
restore.php	10.75 KB	-rw-rw-rw-	2024-09-04 22:54
robots.txt	323 B	-rw-rw-rw-	2025-04-27 15:41
surat-fti.sql	11.87 KB	-rw-rw-rw-	2024-09-05 02:17
tambah_disposisi.php	11.71 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_klasifikasi.php	9.83 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_keluar.php	19.99 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_masuk.php	21.77 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_user.php	12.69 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_keluar.php	25.79 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_masuk.php	27.32 KB	-rw-rw-rw-	2024-09-04 22:54
upload_referensi.php	11.5 KB	-rw-rw-rw-	2024-09-04 22:54
user.php	10.28 KB	-rw-rw-rw-	2024-09-04 22:54
web.config	655 B	-rw-rw-rw-	2024-09-07 01:34

Rename

<?php
    //cek session
    if(empty($_SESSION['admin'])){
        $_SESSION['err'] = '<center>Anda harus login terlebih dahulu!</center>';
        header("Location: ./");
        die();
    } else {

if($_SESSION['admin'] != 1){
            echo '<script language="javascript">
                    window.alert("ERROR! Anda tidak memiliki hak akses untuk membuka halaman ini");
                    window.location.href="./logout.php";
                  </script>';
        } else {

echo '
                <div class="row">
                    
                    <div class="col s12">
                        <div class="z-depth-1">
                            <nav class="secondary-nav">
                                <div class="nav-wrapper blue-grey darken-1">
                                    <div class="col m12">
                                        <ul class="left">
                                            <li class="waves-effect waves-light"><a href="?page=sett&sub=back" class="judul"><i class="material-icons">storage</i> Backup Database</a></li>
                                        </ul>
                                    </div>
                                </div>
                            </nav>
                        </div>
                    </div>
                    
                </div>
                ';

// download file hasil backup
                if(isset($_REQUEST['nama_file'])){

$back_dir = "./";
                	$file = $back_dir.$_REQUEST['nama_file'];

$x = explode('.', $file);
                    $eks = strtolower(end($x));

if($eks == 'sql'){

if(file_exists($file)){
                    		header('Content-Description: File Transfer');
                    		header('Content-Type: application/octet-stream');
                    		header('Content-Disposition: attachment; filename='.($file));
                    		header('Content-Transfer-Encoding: binary');
                    		header('Expires: 0');
                    		header('Cache-Control: private');
                    		header('Pragma: private');
                    		header('Content-Length: ' . filesize($file));
                    		ob_clean();
                    		flush();
                    		readfile($file);
                    		exit;
                    	} else {
                            echo '<script language="javascript">
                                    window.alert("ERROR! File sudah tidak ada");
                                    window.location.href="./admin.php?page=sett&sub=back";
                                  </script>';
                        }
                    } else {
                        if($_SESSION['id_user'] == 1){
                            echo '<script language="javascript">
                                    window.alert("ERROR! Format file yang boleh didownload hanya *.SQL");
                                    window.location.href="./logout.php";
                                  </script>';
                        }
                    }
                }

// proses backup  database dilakukan oleh Fungsi
                function backup($host,$user,$pass,$name,$nama_file,$tables){

//untuk koneksi database
                    $return = "";
                    $link = mysqli_connect($host,$user,$pass,$name);

//backup semua tabel database
                    if($tables == '*'){
                        $tables = array();
                        $result = mysqli_query($link, 'SHOW TABLES');
                        while($row = mysqli_fetch_row($result)){
                            $tables[] = $row[0];
                        }
                    } else {

//backup tabel tertentu
                        $tables = is_array($tables) ? $tables : explode(',',$tables);
                    }

//looping table
                    foreach($tables as $table){
                        $result = mysqli_query($link, 'SELECT * FROM '.$table);
                        $num_fields = mysqli_num_fields($result);

$return.= 'DROP TABLE '.$table.';';
                        $row2 = mysqli_fetch_row(mysqli_query($link, 'SHOW CREATE TABLE '.$table));
                        $return.= "\n\n".$row2[1].";\n\n";

//looping field table
                        for($i = 0; $i < $num_fields; $i++){
                            while($row = mysqli_fetch_row($result)){
                                $return.= 'INSERT INTO '.$table.' VALUES(';

for($j=0; $j<$num_fields; $j++){
                                    $row[$j] = addslashes($row[$j]);
                                    $row[$j] = ereg_replace("\n","\\n",$row[$j]);

if(isset($row[$j])){
                                        $return.= '"'.$row[$j].'"' ;
                                    } else {
                                        $return.= '""';
                                    }
                                    if ($j<($num_fields-1)){
                                        $return.= ',';
                                    }
                                }
                                $return.= ");\n";
                            }
                        }
                        $return.="\n\n\n";
                    }

//otomatis menyimpan hasil backup database dalam root folder aplikasi
                    $nama_file;
                    $handle = fopen($nama_file,'w+');
                    fwrite($handle,$return);
                    fclose($handle);
                }

//nama database hasil backup
                $database = 'Backup';
                $file = $database.'_'.date("d_M_Y").'_'.time().'.sql';

//backup database
                if(isset($_REQUEST['backup'])){

//konfigurasi database dan backup semua tabel
                    backup("localhost","root","","ams_native",$file,"*");

//backup hanya tabel tertentu
                    //backup("localhost","user_database","pass_database","nama_database",$file,"tabel1,tabel2,tabel3");

echo '
                        <div class="row">
                            <div class="col m12">
                                <div class="card">
                                    <div class="card-content">
                                        <span class="card-title black-text"><div class="confirr green-text"><i class="material-icons md-36">done</i>
                                        SUKSES! Database berhasil dibackup</div></span>
                                        <p class="kata" style="margin-top: 10px;">Silakan klik tombol <strong>"Download"</strong> dibawah ini untuk mendownload file backup database.</p>
                                    </div>
                                    <div class="card-action">
                                        <form method="post" enctype="multipart/form-data" >
                                            <a href="?page=sett&sub=back&nama_file='.$file.'" class="btn-large blue waves-effect waves-light white-text">DOWNLOAD <i class="material-icons">file_download</i></a>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>';
                } else {

echo '
                    
                    <div class="row">
                        <div class="col m12">
                            <div class="card">
                                <div class="card-content">
                                    <span class="card-title black-text">Backup Database</span>
                                    <p class="kata">Lakukan backup database secara berkala untuk membuat cadangan database yang bisa direstore kapan saja ketika dibutuhkan. Silakan klik tombol <strong>"Backup"</strong> untuk memulai proses backup data. Setelah proses backup selesai, silakan download file backup database tersebut dan simpan di lokasi yang aman.<span class="red-text"><strong>*</strong></span></p><br/>

<p><span class="red-text"><strong>*</strong></span> Sangat tidak disarankan menyimpan file backup database dalam my documents / Local Disk C.</p>
                                </div>
                                <div class="card-action">
                                    <form method="post" enctype="multipart/form-data" >
                                        <button type="submit" class="btn-large blue waves-effect waves-light" name="backup">BACKUP <i class="material-icons">backup</i></button>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>';
                }
            }
        }
?>