我必须在两个不同的数据库表中插入数据.
我已经为database1创建了database1和table1,
我也为database2创建了database2和table2.
为了插入数据,我已经编写了代码,
$connect = mysql_connect("localhost","root",""); //database connection
mysql_select_db("database1",$connect); // select database1
mysql_select_db("database2",$connect); // select database2
$sql = mysql_query("INSERT INTO database1.table1 (contact_first, contact_last, contact_email) VALUES('abc','xyz','abc@abc.com')"); //insert record to first table
$sql1 =mysql_query("INSERT INTO database2.table2 (contact_first, contact_last, contact_email) VALUES('abc','xyz','abc@abc.com')"); //insert record to second table
请建议我更正以上代码以插入数据.
解决方法:
尝试以下代码:
$connect1 = mysql_connect("localhost","root","");
mysql_select_db("database1", $connect1);
$res1 = mysql_query("query",$connect1);
$connect2 = mysql_connect("localhost","root","",true);
mysql_select_db("database2", $connect2);
$res2 = mysql_query("query",$connect2);
注意:因此mysql_connect有另一个可选的布尔参数,
指示是否创建链接.当我们连接到
$connect2将此可选参数设置为“ true”,因此两个链接都将
保持活着.
标签:mysql-connect,mysql,php,insert,mysql-select-db
来源: https://codeday.me/bug/20191123/2064233.html