$conn1 = mysql_connect('localhost','root','');
$selDb1 = mysql_select_db('win_numbers',$conn1); $conn2 = mysql_connect('192.168.1.136','root','');
$selDb2 = mysql_select_db('win_numbers',$conn2); $conn3 = mysql_connect('192.168.1.101','root','');
$selDb3 = mysql_select_db('win_numbers',$conn3); mysql_query("set names 'UTF-8'");
if(isset($_POST['subWin']))
{ $sqlFront = "INSERT INTO `win_numbers`.`front_two` (`id`, `win_num`) VALUES (NULL, '$_POST[front]');";
$insertFront .= mysql_query($sqlFront,$conn1) or die(mysql_error());
$insertFront .= mysql_query($sqlFront,$conn2) or die(mysql_error());
$insertFront .= mysql_query($sqlFront,$conn3) or die(mysql_error()); $sqlLast = "INSERT INTO `win_numbers`.`last_two` (`id`, `win_num`) VALUES (NULL, '$_POST[last]');";
$insertLast .= mysql_query($sqlLast,$conn1) or die(mysql_error()) ;
$insertLast .= mysql_query($sqlLast,$conn2) or die(mysql_error()) ;
$insertLast .= mysql_query($sqlLast,$conn3) or die(mysql_error()) ; $insert = $insertFront && $insertLast;
if($insert)
{
header("Location: index.php?op=succeed");
}else{
header("Location: index.php?op=feiled");
} }第一次提交表单,想三个数据库提交数据都成功,接着在插入的时候,就只能插入到本地服务器的数据库了,后面两个远程的都插入不了。过了好一会后又可以插入一次,接着又不可以了,这是为什么呢?有什么好的帮发远程插入数据吗?
$selDb1 = mysql_select_db('win_numbers',$conn1); $conn2 = mysql_connect('192.168.1.136','root','');
$selDb2 = mysql_select_db('win_numbers',$conn2); $conn3 = mysql_connect('192.168.1.101','root','');
$selDb3 = mysql_select_db('win_numbers',$conn3); mysql_query("set names 'UTF-8'");
if(isset($_POST['subWin']))
{ $sqlFront = "INSERT INTO `win_numbers`.`front_two` (`id`, `win_num`) VALUES (NULL, '$_POST[front]');";
$insertFront .= mysql_query($sqlFront,$conn1) or die(mysql_error());
$insertFront .= mysql_query($sqlFront,$conn2) or die(mysql_error());
$insertFront .= mysql_query($sqlFront,$conn3) or die(mysql_error()); $sqlLast = "INSERT INTO `win_numbers`.`last_two` (`id`, `win_num`) VALUES (NULL, '$_POST[last]');";
$insertLast .= mysql_query($sqlLast,$conn1) or die(mysql_error()) ;
$insertLast .= mysql_query($sqlLast,$conn2) or die(mysql_error()) ;
$insertLast .= mysql_query($sqlLast,$conn3) or die(mysql_error()) ; $insert = $insertFront && $insertLast;
if($insert)
{
header("Location: index.php?op=succeed");
}else{
header("Location: index.php?op=feiled");
} }第一次提交表单,想三个数据库提交数据都成功,接着在插入的时候,就只能插入到本地服务器的数据库了,后面两个远程的都插入不了。过了好一会后又可以插入一次,接着又不可以了,这是为什么呢?有什么好的帮发远程插入数据吗?
PHP 可以同时连接三台服务器的数据库吗?用show processlist 看看。