| Server IP : 156.238.232.47 / Your IP : 216.73.216.150 Web Server : nginx/1.25.3 System : Linux C202504152095410 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : www ( 1000) PHP Version : 8.3.25 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /www/data/wwwroot/2025_04_20_01/ |
Upload File : |
<?php
// 测试 PDO 数据库连接
require_once __DIR__ . '/vendor/autoload.php';
// 数据库配置
$db_config = [
'host' => '127.0.0.1',
'dbname' => '2024_11_11_01',
'username' => 'travel_user',
'password' => '9b0e4191aa1faf39',
'charset' => 'utf8'
];
try {
// 创建数据库连接
$pdo = new PDO(
"mysql:host={$db_config['host']};dbname={$db_config['dbname']};charset={$db_config['charset']}",
$db_config['username'],
$db_config['password'],
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);
echo "数据库连接成功！\n";
// 测试查询产品
$stmt = $pdo->prepare("SELECT aid, title, users_price FROM ey_archives WHERE aid = ?");
$stmt->execute([1]); // 测试查询 ID 为 1 的产品
$product = $stmt->fetch(PDO::FETCH_ASSOC);
if ($product) {
echo "找到产品：" . $product['title'] . " (ID: " . $product['aid'] . ", 价格: " . $product['users_price'] . ")\n";
} else {
echo "没有找到 ID 为 1 的产品，尝试查找其他产品...\n";
// 查找第一个产品
$stmt = $pdo->prepare("SELECT aid, title, users_price FROM ey_archives LIMIT 1");
$stmt->execute();
$product = $stmt->fetch(PDO::FETCH_ASSOC);
if ($product) {
echo "找到产品：" . $product['title'] . " (ID: " . $product['aid'] . ", 价格: " . $product['users_price'] . ")\n";
} else {
echo "数据库中没有找到任何产品。\n";
}
}
} catch (PDOException $e) {
echo "数据库连接失败：" . $e->getMessage() . "\n";
} catch (Exception $e) {
echo "其他错误：" . $e->getMessage() . "\n";
}
?>