php - 如何在opencart中使用多个数据库？

Question

我有两个项目，一个在 Yii，另一个在 Open cart在打开购物车？

Answer 1

你可以像这样使用多个数据库:

 // Define database
    $host = 'localhost';
    $db1 = 'username1';
    $pwd = 'pass';

    $db2 = 'user2';
    $pwd2 = 'pass';

    $con1 = mysql_connect($host, $db1, $pwd) or die ('Error connecting to mysql');
    $con2 = mysql_connect($host, $db2, $pwd2) or die ('2nd Db Error connecting to mysql');

    $db_name1 = '`mydatabase`';
    mysql_select_db($db_name, $con1);

    $db_name2 = '`mydatabase2`';
    mysql_select_db($db_name2, $con2);

这是您的数据库操作:

    $result = mysql_query("Select * from ......", $con1) or die(mysql_error());

    $result = mysql_query("Select * from ......", $con2) or die(mysql_error());