PHP Source Code for backing up Database

http://reeteshghimire.com.np/2019/07/04/backup-restore-mysql-database-using-php/

https://stackoverflow.com/questions/22195493/export-mysql-database-using-php-only

1. <?php
3. $connection = mysqli_connect('localhost','root','','quiz');
5. $tables = array();
6. $result = mysqli_query($connection,"SHOW TABLES");
7. while($row = mysqli_fetch_row($result)){
8. $tables[] = $row[0];
9. }
11. $return = '';
12. foreach($tables as $table){
13. $result = mysqli_query($connection,"SELECT * FROM ".$table);
14. $num_fields = mysqli_num_fields($result);
16. $return .= 'DROP TABLE '.$table.';';
17. $row2 = mysqli_fetch_row(mysqli_query($connection,"SHOW CREATE TABLE ".$table));
18. $return .= "\n\n".$row2[1].";\n\n";
20. for($i=0;$i<$num_fields;$i++){
21. while($row = mysqli_fetch_row($result)){
22. $return .= "INSERT INTO ".$table." VALUES(";
23. for($j=0;$j<$num_fields;$j++){
24. $row[$j] = addslashes($row[$j]);
25. if(isset($row[$j])){ $return .= '"'.$row[$j].'"';}
26. else{ $return .= '""';}
27. if($j<$num_fields-1){ $return .= ',';}
28. }
29. $return .= ");\n";
30. }
31. }
32. $return .= "\n\n\n";
33. }
35. //save file
36. $handle = fopen("backup.sql","w+");
37. fwrite($handle,$return);
38. fclose($handle);
39. echo "Successfully backed up";

Source Code for Restoring the Database

1. <?php
3. $connection = mysqli_connect('localhost','root','','test');
5. $filename = 'backup.sql';
6. $handle = fopen($filename,"r+");
7. $contents = fread($handle,filesize($filename));
9. $sql = explode(';',$contents);
10. foreach($sql as $query){
11. $result = mysqli_query($connection,$query);
12. if($result){
13. echo '<tr><td><br></td></tr>';
14. echo '<tr><td>'.$query.' <b>SUCCESS</b></td></tr>';
15. echo '<tr><td><br></td></tr>';
16. }
17. }
18. fclose($handle);
19. echo 'Successfully imported';