php执行sql文件

最新推荐文章于 2023-06-16 12:48:24 发布

不净之心

最新推荐文章于 2023-06-16 12:48:24 发布

阅读量129

点赞数

分类专栏： PHP 文章标签： php 数据库

本文链接：https://blog.csdn.net/pyzheng/article/details/84367326

版权

PHP 专栏收录该内容

77 篇文章 0 订阅

订阅专栏

<?php
	//http://blog.163.com/tonylee@126/blog/static/130335554201172412923695/  先保证表的编码是UTF-8
	header('Content-Type: text/html; charset=UTF-8');
	$hostname = 'localhost';
	$dbname = 'aaa';
	$username = 'aaa';
	$pw = 'aaa';

	$conn = mysql_connect ( $hostname, $username, $pw ) or die ( "无法连接数据库" );
	mysql_select_db ( $dbname, $conn ) or die ( "无法连接到数据库" );

	mysql_query('set names utf8' );

	$arr = array("testdata");//删除数据
	foreach($arr as $sqlfile){
		$sqlfile=$sqlfile.".sql";
		echo $sqlfile."<br>";
		$sql = file_get_contents ( $sqlfile );
		$ar = split ( ";", join ( "", file ( $sqlfile ) ) );
		foreach ( $ar as $sql ){
			echo  iconv('UTF-8', 'UTF-8' ,$sql);
			echo "<br>";
			mysql_query($sql);
		}
	}

	$arr = array("system_site","system_nvg","system_art_type","system_art","system_pic",
			"system_message","system_auth","system_user","system_group","system_user_group",
			"system_i18n","system_access","system_friend");//每个表的insert sql
	foreach($arr as $sqlfile){
		$sqlfile=$sqlfile.".sql";
		echo $sqlfile."<br>";
		$sql = file_get_contents ( $sqlfile );
		$ar = split ( ";", join ( "", file ( $sqlfile ) ) );
		foreach ( $ar as $sql ){
			echo  iconv('UTF-8', 'UTF-8' ,$sql);
			echo "<br>";
			mysql_query($sql);
		}
	}



?>