php - 无法使用不同的方法连接到 mysql

Question

host = ***.**.**.**
username = ****
password = ****
db name = test1
port = 3307

我可以使用这个 php 连接到我的 MySQL 数据库

<?php
$servername = "***.**.*.**";
$username = "***";
$password = "***";
$dbname = "test1";
$dbport = "3307";

$conn = new mysqli($servername, $username, $password, $dbname, $dbport);
?>

但我无法使用此连接

<?php
define ("DB_ACCESS", "mysqli");
define ("DB_HOST", "***.**.*.**");
define ("DB_NAME", "test1");
define ("DB_USER", "****");
define ("DB_PASSWORD", "****");
define ("DB_PORT", "3307");

global $dbdtk_dbaccess, $dbdtk_dbhost, $dbdtk_dbuser, $dbdtk_dbpasswd,
$dbdtk_dbname, $dbdtk_dbport;

$dbdtk_dbaccess     = DB_ACCESS;
$dbdtk_dbhost   = DB_HOST;
$dbdtk_dbuser   = DB_USER;
$dbdtk_dbpasswd = DB_PASSWORD;
$dbdtk_dbname   = DB_NAME;
$dbdtk_dbport   = DB_PORT;

$db = &ADONewConnection($dbdtk_dbaccess);
$db->debug = 0;
$db->Connect($dbdtk_dbhost, $dbdtk_dbuser, $dbdtk_dbpasswd,
$dbdtk_dbname, dbdtk_dbport);
$ADODB_FETCH_MODE = ADODB_FETCH_BOTH;
?>

我的代码有什么问题吗？我必须在我的应用程序中使用两者。感谢大家的帮助。

Answer 1

MySQL 的默认端口是 3306 而不是 3307，所以也要检查一下。并确保您已包含adodb.inc.php。在您的代码中您没有添加此文件

<?php

     include('adodb/adodb.inc.php');

     $db = ADONewConnection($dbdriver); # eg 'mysql' or 'postgres'

     $db->debug = true;

     $db->Connect($server, $user, $password, $database);

     $rs = $db->Execute('select * from some_small_table');

     print "<pre>";

     print_r($rs->GetRows());

     print "</pre>";

?>

此代码示例来自 http://phplens.com/lens/adodb/docs-adodb.htm这里。