cara import Sql Via PHP

---

<?php

$conn = new mysqli('localhost', 'root', '', 'e-sembako_offline');

 

$query = '';

$sqlScript = file('database_backup.sql');

foreach ($sqlScript as $line) {

 

    $startWith = substr(trim($line), 0, 2);

    $endWith = substr(trim($line), -1, 1);

 

    if (empty($line) || $startWith == '--' || $startWith == '/*' || $startWith == '//') {

        continue;

    }

 

    $query = $query . $line;

    if ($endWith == ';') {

        mysqli_query($conn, $query) or die('<div class="error-response sql-import-response">Problem in executing the SQL query <b>' . $query . '</b></div>');

        $query = '';

    }

}

echo '<div class="success-response sql-import-response">SQL file imported successfully</div>';

---

Terima kasih Telah Membaca Artikel Tentang cara import Sql Via PHP

---

Punya Pertanyaan cara import Sql Via PHP , Silahkan Konsultasikan Lewat Whatsapp.
085284606999

Artikel cara import Sql Via PHP Di Update Pada :

---

Salam
Muhammad Ullil Fahri