php怎么执行sql文件路径,php执行sql文件

//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."
";

$sql = file_get_contents ( $sqlfile );

$ar = split ( ";", join ( "", file ( $sqlfile ) ) );

foreach ( $ar as $sql ){

echo iconv('UTF-8', 'UTF-8' ,$sql);

echo "
";

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."
";

$sql = file_get_contents ( $sqlfile );

$ar = split ( ";", join ( "", file ( $sqlfile ) ) );

foreach ( $ar as $sql ){

echo iconv('UTF-8', 'UTF-8' ,$sql);

echo "
";

mysql_query($sql);

}

}

?>