PHP運行SQL指令檔

來源:互聯網
上載者:User
<?php  header("Content-Type: text/html;charset=utf-8");function populate_db( $DBname, $DBPrefix, $sqlfile ) {      global $errors;        @mysql_select_db($DBname);      mysql_query("SET NAMES utf8");    $mqr = @get_magic_quotes_runtime();      @set_magic_quotes_runtime(0);      $query = fread(fopen($sqlfile, "r"), filesize($sqlfile));      @set_magic_quotes_runtime($mqr);      $pieces  = split_sql($query);        for ($i=0; $i<count($pieces); $i++) {          $pieces[$i] = trim($pieces[$i]);          if(!empty($pieces[$i]) && $pieces[$i] != "#") {              $pieces[$i] = str_replace( "#__", $DBPrefix, $pieces[$i]);              if (!$result = @mysql_query ($pieces[$i])) {                  $errors[] = array ( mysql_error(), $pieces[$i] );              }          }      }  }    function split_sql($sql) {      $sql = trim($sql);      $sql = ereg_replace("\n#[^\n]*\n", "\n", $sql);        $buffer = array();      $ret = array();      $in_string = false;        for($i=0; $i<strlen($sql)-1; $i++) {          if($sql[$i] == ";" && !$in_string) {              $ret[] = substr($sql, 0, $i);              $sql = substr($sql, $i + 1);              $i = 0;          }            if($in_string && ($sql[$i] == $in_string) && $buffer[1] != "\\") {              $in_string = false;          }          elseif(!$in_string && ($sql[$i] == '"' || $sql[$i] == "'") && (!isset($buffer[0]) || $buffer[0] != "\\")) {              $in_string = $sql[$i];          }          if(isset($buffer[1])) {              $buffer[0] = $buffer[1];          }          $buffer[1] = $sql[$i];      }        if(!empty($sql)) {          $ret[] = $sql;      }      return($ret);  }    $lnk = mysql_connect('localhost','root','password')     or die ('串連失敗'.mysql_error());    if (!mysql_select_db('dbname',$lnk)){    exit();}  populate_db( 'dbname','','abc.sql' );  ?>  

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.