Changeset 3199082

Timestamp:

11/28/2024 06:43:14 PM (15 months ago)

Author:

codecompiled

Message:

Updated the db backup method.

File:

• wp-settings/trunk/wp-settings.php (modified) (1 diff)

wp-settings/trunk/wp-settings.php

@@ -300 +300 @@
 
 //$mysqli = new mysqli('localhost','codecomp_wp811','P]4Sl!l6s9','codecomp_wp811');
-$mysqli = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
-/* check connection */
-try {
-if ($mysqli->connect_errno) {
-    printf("Sorry , unable to connect to database %s\n", $mysqli->connect_error);
-    exit();
-}
-else
-{
-
-      $return='';
-     
-      $result = $mysqli->query('SHOW TABLES');
-      
-         
-      $tableCount=0;
-      $tables = array();
-        echo "step no 1";
-       while ($row = $result->fetch_row()) {
-              $tableCount=$tableCount+1;
-                $tables[] = $row[0];
-        //printf ("%s (%s)\n", $row[0], $row[1]);
-    }
-    
-            foreach($tables as $table)
-    {
-                  echo "step no 2";
-        $result = $mysqli->query('SELECT * FROM '.$table);
-        
-        $num_fields = mysqli_num_fields($result);
-        
-            $return.= 'DROP TABLE '.$table.';';
-              echo "step no 3";
-        $row2 = mysqli_fetch_row(mysqli_query($mysqli ,'SHOW CREATE TABLE '.$table));
-        $return.= "\n\n".$row2[1].";\n\n";
-        
-          echo "step no 4";
-        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";
-            }
-        }
-        
+    printf("connecting to db");
+
+$host = DB_HOST;
+$user = DB_USER;
+$password = DB_PASSWORD;
+$database = DB_NAME;
+
+
+// Connect to the database
+$conn = new mysqli($host, $user, $password, $database);
+
+if ($conn->connect_error) {
+    die("Connection failed: " . $conn->connect_error);
+}
+
+$output = "";
+
+$result = $conn->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '$database'");
+
+if ($result->num_rows > 0) {
+    while ($row = $result->fetch_assoc()) {
+        $tableName = $row['TABLE_NAME'];
+
+        // DROP TABLE statement
+        $output .= "DROP TABLE IF EXISTS $tableName;\n";
+
+        // CREATE TABLE statement
+        $createResult = $conn->query("SHOW CREATE TABLE $tableName");
+        if ($createRow = $createResult->fetch_assoc()) {
+            $createTableQuery = str_replace('`', '', $createRow['Create Table']);
+            $output .= $createTableQuery . ";\n\n";
         }
-        
-     ob_clean();
+
+        // INSERT statements
+        $dataResult = $conn->query("SELECT * FROM $tableName");
+        if ($dataResult->num_rows > 0) {
+            while ($dataRow = $dataResult->fetch_assoc()) {
+                $columns = array_map(function ($col) {
+                    return str_replace('`', '', $col);
+                }, array_keys($dataRow));
+                $values = array_map(function ($value) use ($conn) {
+                    return $value === null ? "NULL" : "'" . $conn->real_escape_string($value) . "'";
+                }, array_values($dataRow));
+
+                $output .= "INSERT INTO $tableName (" . implode(", ", $columns) . ") VALUES (" . implode(", ", $values) . ");\n";
+            }
+            $output .= "\n";
+        }
+    }
+}
+
+$conn->close();
+
+  // Output or save the SQL script
+   ob_clean();
    header("Content-type: application/text");
    header("Content-Disposition: attachment; filename=dbBackup.sql");
-echo $return;
+   echo $output;
     exit();
-}
-}//try ends
-catch(Exception $e)
-{
-    echo 'Message: ' .$e->getMessage();
-}
-
 } //method ends
+