在同一个PHP程序里打开mysql 不能使用一个函数。
<?php
/**
* 数据库手动同步PHP shell 作者：清如许 时间：2011-06-19
*/
set_time_limit(0);
//原数据库连接信息
$dbhost1 = "localhost";
$dbname1 = "test";
$dbuser1 = "root";
$dbpwd1 = "123456";
//同步数据缓存
mysql_connect($dbhost1,$dbuser1,$dbpwd1);
mysql_select_db($dbname1);
mysql_query("set names 'utf8'");
$rs = mysql_query("select pid,tid,subject,dateline from pre_forum_post");
while($row = mysql_fetch_array($rs))
{
$data[] = $row;
}
//同步数据库连接信息
$dbhost2 = "localhost";
$dbname2 = "test2";
$dbuser2 = "root";
$dbpwd2 = "123456";
if($data)
{
$conn = mysqli_connect($dbhost2,$dbuser2,$dbpwd2);
mysqli_select_db($conn,$dbname2);
mysqli_query($conn,"set names 'utf8'");
mysqli_query($conn,"truncate table pre_forum_post");
foreach($data as $v)
{
$sql = "insert into pre_forum_post(pid,tid,subject,dateline) values('".$v['pid']."','".$v['tid']."','".$v['subject']."','".$v['dateline']."')";
mysqli_query($conn,$sql);
}
mysqli_close($conn);
}
echo "ok!!";
?>