PHP處理SQL指令檔匯入到MySQL的代碼執行個體

 通常在製作安裝程式，資料備份程式的時候會要用到這樣的代碼，我看網上有是有不太多，而且有些也不是很好用，有時候這種代碼直接用現成的可以節省很多時間，那麼我就從stackoverflow轉了一個過來,需要的朋友可以參考下

代碼如下:<?php // Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump'; // Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error()); // Temporary variable, used to store current query$templine = '';// Read in entire file$lines = file($filename);// Loop through each lineforeach ($lines as $line){// Skip it if it's a commentif (substr($line, 0, 2) == '--' || $line == '')    continue; // Add this line to the current segment$templine .= $line;// If it has a semicolon at the end, it's the end of the queryif (substr(trim($line), -1, 1) == ';'){    // Perform the query    mysql_query($templine) or print('Error performing query '<strong>' . $templine . '': ' . mysql_error() . '<br /><br />');    // Reset temp variable to empty    $templine = '';}} echo "Tables imported successfully";?>