Web Analytics
 Contoh Sql Hapus Semua Table dan Masukan SQL Baru

Contoh Sql Hapus Semua Table dan Masukan SQL Baru


<?php

$sql = file_get_contents('http://localhost/e-sembako/offline/public/database_backup.sql');

 

$mysqli = new mysqli("localhost", "root", "", "e_sembako_online");

 

$mysqli->query('SET foreign_key_checks = 0');

if ($result = $mysqli->query("SHOW TABLES")) {

while ($row = $result->fetch_array(MYSQLI_NUM)) {

$mysqli->query('DROP TABLE IF EXISTS ' . $row[0]);

}

}

 

$mysqli->query('SET foreign_key_checks = 1');


 

/* execute multi query */

$mysqli->multi_query($sql);

 

$mysqli->close();


Lanjut Part : 1
Jam : 22:47:33
Durasi Part : 0:0:1
Durasi Total : 0:0:1

Punya Pertanyaan , Silahkan Whatsapp Langsung
Muhammad Ullil Fahri
WA : 089696380422
Tautan WA : https://wa.me/message/SG4YA2XQP5FPE1
Theme Customizer

Theme Styles