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
Muhammad Ullil Fahri
WA : 089696380422
Tautan WA : https://wa.me/message/SG4YA2XQP5FPE1