如何在一个PHP文件里操作MYSQL里两个不同的库,同时进行insert操作。为什么不行? 试试在mysql_query()里指定connection看. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 没有错误提示,看数据库,就是test库里的test表没有添加上,而test2库里的test2却添加上了 afoskoo(暂停打印)说的这样改看看:$query="INSERT INTO `test` ( `id` ) VALUES ('0');";echo $query;mysql_query($query,$connect); <?$host="localhost";$rootname="root";$rootpass="";$dbname="test";$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test(){$host2="localhost";$rootname2="root";$rootpass2="";$dbname2="test2";$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";echo "in:".$query."<br>";mysql_query($query,$connect2);mysql_close($connect2);}test();$query="INSERT INTO `test` ( `id` ) VALUES ('0');";echo $query;mysql_query($query);?>试过了,也不行,继续等待 是改下面,不是上面的<?$host="localhost";$rootname="root";$rootpass="";$dbname="test";$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test(){$host2="localhost";$rootname2="root";$rootpass2="";$dbname2="test2";$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";echo "in:".$query."<br>";mysql_query($query,$connect2);mysql_close($connect2);}test();$query="INSERT INTO `test` ( `id` ) VALUES ('0');";echo $query;mysql_query($query, $connect);?> <?$host="localhost";$rootname="root";$rootpass="";$dbname="testa";function test(){$host2="localhost";$rootname2="root";$rootpass2="";$dbname2="testb";$connect2=mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");$query="INSERT INTO `testb` ( `id` ) VALUES ('0');";echo "TESTB:".$query."<br>";mysql_query($query,$connect2);mysql_close($connect2);}test();$connect=mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");$db=mysql_select_db($dbname,$connect) or die("连结数据库失败!");$query="INSERT INTO `testa` ( `id` ) VALUES ('0');";echo "TESTA:".$query;mysql_query($query,$connect);?> ...test(); // mysql的最后可用连接指向test2$query="INSERT INTO `test` ( `id` ) VALUES ('0');";echo $query;mysql_query($query,$connect); // 若不指定指向test的$connect,则取“最后可用连接”,显然是错误的 <?$host="localhost";$rootname="root";$rootpass="";$dbname="test";$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test(){$host2="localhost";$rootname2="root";$rootpass2="";$dbname2="test2";$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";echo "in:".$query."<br>";mysql_query($query,$connect2);mysql_close($connect2);}test();$query="INSERT INTO `test` ( `id` ) VALUES ('0');";echo $query;mysql_query($query,$connect);?>试过了,报“Warning: mysql_query(): 1 is not a valid MySQL-Link resource in e:\works\info.php on line 29”错估计是最后一个连接的错误 因为在test()里执行了mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");所以当前的库就是test2.而后面的$query="INSERT INTO `test` ( `id` ) VALUES ('0');";是针对test库的操作,所以出错了.应在执行$query="INSERT INTO `test` ( `id` ) VALUES ('0');";之前执行一次mysql_select_db($dbname,$connect),使当前的库为test. 唠叨不是都说了吗你执行完test();这个以后你数据库连接是test2应该再执行一遍这个$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!"); 写程序不规范 函数定义结构不清晰 数据库操作属于指针操作 (小样!你以为你脱了马甲我就不认识你了吗 ?针对:$host2="localhost";$rootname2="root";$rootpass2="";) mysql语句配对 set php的过程中遇到一个问题,请指教,谢谢 php自定义函数问题 手机网站,css的标准问题 请教soap的问题 php访问mysql的问题 新手求教mysql4.0中在什么地方修改character set=latin1 成 gbk? php创建xml并格式化输出 生成HTML时需要注意系统的环境吗?有什么要注意的? 如何实现关闭一个窗口后刷新其父窗口,拜求高手 哪有PHP开发工具下载 字符串分割问题
$query="INSERT INTO `test` ( `id` ) VALUES ('0');";
echo $query;
mysql_query($query,$connect);
$host="localhost";
$rootname="root";
$rootpass="";
$dbname="test";
$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");
$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test()
{
$host2="localhost";
$rootname2="root";
$rootpass2="";
$dbname2="test2";
$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");
@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");
$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";
echo "in:".$query."<br>";
mysql_query($query,$connect2);
mysql_close($connect2);
}
test();
$query="INSERT INTO `test` ( `id` ) VALUES ('0');";
echo $query;
mysql_query($query);
?>试过了,也不行,继续等待
$host="localhost";
$rootname="root";
$rootpass="";
$dbname="test";
$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");
$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test()
{
$host2="localhost";
$rootname2="root";
$rootpass2="";
$dbname2="test2";
$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");
@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");
$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";
echo "in:".$query."<br>";
mysql_query($query,$connect2);
mysql_close($connect2);
}
test();
$query="INSERT INTO `test` ( `id` ) VALUES ('0');";
echo $query;
mysql_query($query, $connect);
?>
$host="localhost";
$rootname="root";
$rootpass="";
$dbname="testa";function test()
{
$host2="localhost";
$rootname2="root";
$rootpass2="";
$dbname2="testb";
$connect2=mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");
mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");
$query="INSERT INTO `testb` ( `id` ) VALUES ('0');";
echo "TESTB:".$query."<br>";
mysql_query($query,$connect2);
mysql_close($connect2);
}
test();$connect=mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");
$db=mysql_select_db($dbname,$connect) or die("连结数据库失败!");$query="INSERT INTO `testa` ( `id` ) VALUES ('0');";
echo "TESTA:".$query;
mysql_query($query,$connect);
?>
test(); // mysql的最后可用连接指向test2$query="INSERT INTO `test` ( `id` ) VALUES ('0');";
echo $query;
mysql_query($query,$connect); // 若不指定指向test的$connect,则取“最后可用连接”,显然是错误的
$host="localhost";
$rootname="root";
$rootpass="";
$dbname="test";
$connect=@mysql_connect($host,$rootname,$rootpass) or die("连接主机失败!");
$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");function test()
{
$host2="localhost";
$rootname2="root";
$rootpass2="";
$dbname2="test2";
$connect2=@mysql_connect($host2,$rootname2,$rootpass2) or die("连接主机失败!");
@mysql_select_db($dbname2,$connect2) or die("连结数据库失败!");
$query="INSERT INTO `test2` ( `id` ) VALUES ('0');";
echo "in:".$query."<br>";
mysql_query($query,$connect2);
mysql_close($connect2);
}
test();
$query="INSERT INTO `test` ( `id` ) VALUES ('0');";
echo $query;
mysql_query($query,$connect);
?>试过了,报“Warning: mysql_query(): 1 is not a valid MySQL-Link resource in e:\works\info.php on line 29”错估计是最后一个连接的错误
而后面的$query="INSERT INTO `test` ( `id` ) VALUES ('0');";是针对test库的操作,所以出错了.
应在执行$query="INSERT INTO `test` ( `id` ) VALUES ('0');";之前执行一次mysql_select_db($dbname,$connect),使当前的库为test.
应该再执行一遍这个
$db=@mysql_select_db($dbname,$connect) or die("连结数据库失败!");
针对:
$host2="localhost";
$rootname2="root";
$rootpass2="";)