View difference between Paste ID: Xr8PYYas and sitWZ7SN

 <?php
 
-$con= new mysqli("localhost","root","","my_db");//mysqli
+
 $db = "rand_bioskop";
 $con = new mysqli("localhost", "root", "gundam1981", $db); //mysqli
- // Check connection
+
- if ($con->connect_errno) {
+
 // Check connection
 if ($con->connect_errno) {
-//LIST ALL TABLE
+
-$sql= "show full tables FROM my_db where Table_Type != 'VIEW'";
+
-$result = $con->query($sql);
+
-while ($row =  $result->fetch_row()) {
+/* * **
-    echo "Table: {$row[0]}\n";
+  buatlah  fungsi
-    //repair table using MYISAM Only. tested and work!
+  extract semua table (only) dalam database..
-    $sql="REPAIR TABLE $row[0] USE_FRM";
+  masukkan dalam array $aTable yg isinya hanya 5 (jgn 2)
-     $con->query($sql);
+ * *** */
-    echo "\nRepair:$row[0]";
+$sql = "show full tables FROM `{$db}` where Table_Type != 'VIEW'";
 if ($result = $con->query($sql)) {
     while ($row = $result->fetch_row()) {
         //echo "Table: {$row[0]}\n";
-/****
+//===========REPAIR TIDAK DILAKUKAN DISINI
-buatlah  fungsi
+        //repair table using MYISAM Only. tested and work!
-extract semua table (only) dalam database..
+        //$sql="REPAIR TABLE $row[0] USE_FRM";
-masukkan dalam array $aTable yg isinya hanya 5 (jgn 2)
+        // $con->query($sql);
-*****/
+        // echo "\nRepair:$row[0]";
         // var_dump($con->query($sql));
         $aTable[] = $row[0];
     }
 } else {
     printf("Errormessage: %s\n", $con->error);
     die;
 }
 
 //===lakukan proses repair/optimize
 foreach ($aTable as $table) {
     $sql = "OPTIMIZE TABLE `{$table}` ; ";
     $con->query($sql);
     echo "\nRepair:$table"
     . "\n$sql\n";
     var_dump($con->query($sql));
 }
 
 /*
 Buatlah sesingkat mungkin
 */