前端代碼

<form method="post" action="recovery_mysqldb.php" enctype="multipart/form-data">
<table width="100%" border="0">
  <tbody>
    <tr>
      <td width="25%" height="50" align="right" class="backup-text">數(shù)據(jù)庫還原：</td>
      <td colspan="3"></td>
      </tr>
    <tr>
      <td width="25%" height="50" align="right">請選擇路徑：</td>
      <td colspan="3"><input type="file" name="myfile" id="myfile" style="width: 100%;" placeholder=""></td>
      </tr>
    
    <tr>
      <td height="50">&nbsp;</td>
      <td colspan="3"><span class="text-prompt">*（謹(jǐn)慎使用）選擇 name.sql 文件路徑點擊還原按鈕即可還原數(shù)據(jù)表及數(shù)據(jù)，還原后的數(shù)據(jù)是選擇sql文件里頭的數(shù)據(jù)。</span></td>
    </tr>
    <tr>
      <td height="50" align="right" valign="middle">&nbsp;</td>
      <td height="50" align="center" valign="middle">
        </td>
      <td align="center" valign="middle">
        <button type="submit" name="submit" class="btn btn-success" onclick="return stop()">還原數(shù)據(jù)庫</button>
        <button type="reset" class="btn btn-default">&nbsp;&nbsp;重新設(shè)置&nbsp;&nbsp;</button>
        </td>
      <td width="25%" align="left" valign="middle">&nbsp;</td>
    </tr>
  </tbody>
</table>
</form>

發(fā)送請求后臺代碼

<!--
    作者：87046766@qq.com
    時間：2018-01-16
    描述：版權(quán)所有違者必究
-->
<meta charset="utf-8">
<?php
    ob_start();
    session_start();
    if($_SESSION['admin']!=''){
        //$upload_dir="./upload files";
        $upload_file=iconv("UTF-8","Big5",$_FILES["myfile"]["name"]);
        if(move_uploaded_file($_FILES["myfile"]["tmp_name"],$upload_file)){
            //連接數(shù)據(jù)庫
            $conn=mysql_connect("localhost","root","root");
            mysql_select_db("evaluation_system",$conn);
            mysql_query("set names utf8");
            
            
            //還原數(shù)據(jù)庫要執(zhí)行的語句
            $dbname="evaluation_system";
            $sql="";
            
            //查詢所有數(shù)據(jù)表名
            $sql_tablist="show tables"; 
            $rs_tablist=mysql_query($sql_tablist); 
            while($tablist=mysql_fetch_assoc($rs_tablist)){
                $sql.="drop table `".$tablist['Tables_in_'.$dbname]."`;";
            }
            
            //讀取上傳到的文件
            
            //打開文件
            $handle=fopen($_FILES["myfile"]["name"],"r");
            //讀取文件
            $sql.=fread($handle,filesize($_FILES["myfile"]["name"]));
            //關(guān)閉文件
            fclose($handle);
            
            //不能批量執(zhí)行sql語句分割以；sql
            $array=explode(";",$sql);
            
            //循環(huán)執(zhí)行分隔開的sql語句
            foreach($array as $value){
                mysql_query($value);
            }
            //echo $sql;
            //刪除服務(wù)器端文件
            unlink($_FILES["myfile"]["name"]);
            
            echo "<script type='text/javascript'>alert('數(shù)據(jù)庫還原成功！');window.location.href='admin_mysqldb.php';</script>";
            
        }else{
            echo "<script type='text/javascript'>alert('出錯啦！請重新選擇還原文件！');window.location.href='admin_mysqldb.php';</script>";
        }
    }
    else echo "<script language='javascript'>top.location.href='index.php'</script>";
?>