时间戳

首页 > 解决方案 > 如何将数据插入2个数据库？

php - 如何将数据插入2个数据库？

问题描述

我正在尝试将数据插入到不同数据库中的 2 个表中。但我无法连接到第二个数据库。

$con1 = mysqli_connect("localhost","root","","db1");

$sql_1 = "insert into enquiry(name,email,phone,subject,message,service_category) values('aa','aa@gg.com','12344','xxx','ddd','ddd')";

$res_1 = mysqli_query($con1,$sql_1);

$con = mysqli_connect("localhost","root","","db2");

$sql = "insert into customers(cname,cphone,cemail) values('$name','$phone','$email')";

$res = mysqli_query($con,$sql);

标签： phpmysqli

解决方案

您可以通过单个连接执行此操作

$db = new mysqli($host,$user,$pass);

选择数据库时使用此

mysqli_select_db('DB_NAME', $db);

你编码

$con1 = mysqli_connect("localhost","username","password");
/* For the DB1 */
mysqli_select_db('DB_NAME1', $con1);
$sql_1 = "insert into 
enquiry(name,email,phone,subject,message,service_category) 
values('aa','aa@gg.com','12344','xxx','ddd','ddd')";
$res_1 = mysqli_query($con1,$sql_1);

/* For the DB2 */
mysqli_select_db('DB_NAME2', $con1);
$sql = "insert into customers(cname,cphone,cemail) 
values('$name','$phone','$email')";
$res = mysqli_query($con1,$sql);

推荐阅读