ty sir/maam for your…
ty sir/maam for your beautiful code its work perfectly in my capstone project
<?php function restore($server, $username, $password, $dbname, $location){ //connection $conn = new mysqli($server, $username, $password, $dbname); //variable use to store queries from our sql file $sql = ''; //get our sql file //return message //loop each line of our sql file foreach ($lines as $line){ //skip comments continue; } //add each line to our query $sql .= $line; //check if its the end of the line due to semicolon //perform our query $query = $conn->query($sql); if(!$query){ $output['error'] = true; $output['message'] = $conn->error; } else{ $output['message'] = 'Database restored successfully'; } //reset our query variable $sql = ''; } } return $output; } ?>
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>How to Restore MySQL Database using PHP</title> <link rel="stylesheet" type="text/css" href="bootstrap4/css/bootstrap.min.css"> </head> <body> <div class="container"> <h1 class="text-center" style="margin-top:30px;">Restore MySQL Database using PHP</h1> <hr> <div class="row justify-content-center"> <div class="col-sm-6"> <?php ?> <div class="alert alert-danger text-center"> <?php echo $_SESSION['error']; ?> </div> <?php } ?> <div class="alert alert-success text-center"> <?php echo $_SESSION['success']; ?> </div> <?php } ?> <div class="card"> <div class="card-body"> <h3>Database Credential and Name</h3> <br> <form method="POST" action="restore.php" enctype="multipart/form-data"> <div class="form-group row"> <label for="server" class="col-sm-3 col-form-label">Server</label> <div class="col-sm-9"> <input type="text" class="form-control" id="server" name="server" placeholder="ex 'localhost'" required> </div> </div> <div class="form-group row"> <label for="username" class="col-sm-3 col-form-label">Username</label> <div class="col-sm-9"> <input type="text" class="form-control" id="username" name="username" placeholder="ex 'root'" required> </div> </div> <div class="form-group row"> <label for="password" class="col-sm-3 col-form-label">Password</label> <div class="col-sm-9"> <input type="text" class="form-control" id="password" name="password" placeholder="db password"> </div> </div> <div class="form-group row"> <label for="dbname" class="col-sm-3 col-form-label">Database</label> <div class="col-sm-9"> <input type="text" class="form-control" id="dbname" name="dbname" placeholder="database you want to restore to" required> </div> </div> <div class="form-group row"> <label for="sql" class="col-sm-3 col-form-label">File</label> <div class="col-sm-9"> <input type="file" class="form-control-file" id="sql" name="sql" placeholder="database you want to restore to" required> </div> </div> <button type="submit" class="btn btn-primary" name="restore">Restore</button> </form> </div> </div> </div> </div> </div> </body> </html>
<?php //include our function include 'function.php'; //get post data $server = $_POST['server']; $username = $_POST['username']; $password = $_POST['password']; $dbname = $_POST['dbname']; //moving the uploaded sql file $filename = $_FILES['sql']['name']; $file_location = 'upload/' . $filename; //restore database using our function $restore = restore($server, $username, $password, $dbname, $file_location); if($restore['error']){ $_SESSION['error'] = $restore['message']; } else{ $_SESSION['success'] = $restore['message']; } } else{ $_SESSION['error'] = 'Fill up credential first'; } ?>