PHP处理SQL脚本文件导入到MySQL的代码实例

来源:三联时间:2014-03-20

  通常在制作安装程式,数据备份程序的时候会要用到这样的代码,我看网上有是有不太多,而且有些也不是很好用,有时候这种代码直接用现成的可以节省很多时间,那么我就从stackoverflow转了一个过来,需要的朋友可以参考下。

  代码如下:

  // 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 server

  mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());

  // Select database

  mysql_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 line

  foreach ($lines as $line)

  {

  // Skip it if it's a comment

  if (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 query

  if (substr(trim($line), -1, 1) == ';')

  {

  // Perform the query

  mysql_query($templine) or print('Error performing query '' . $templine . '': ' . mysql_error() . '

  ');

  // Reset temp variable to empty

  $templine = '';

  }

  }

  echo "Tables imported successfully";

  ?>

发表评论

最新评论(共0条)