$expire)) {
session_destroy();
header("Location: login.php");
exit;
}
$_SESSION['login_time'] = time();
$userName = htmlspecialchars($_SESSION['username']);
// 读取配置库
$dbHost = "10.150.117.190";
$dbUser = "root";
$dbPwd = "hp93000";
$dbName = "alert_mail_stat";
$conn = mysqli_connect($dbHost, $dbUser, $dbPwd, $dbName);
mysqli_set_charset($conn, "utf8mb4");
$currentLang = mysqli_fetch_assoc(mysqli_query($conn, "SELECT v FROM sys_config WHERE k='lang'"))['v'] ?? "zh";
// 多语言
$langMap = [
'zh' => [
'page_subtitle' => '爱德万测试 · SMTP邮箱配置',
'smtp_config' => '邮箱SMTP配置',
'smtp_host' => 'SMTP服务器',
'smtp_port' => '端口',
'smtp_ssl' => '启用SSL/TLS',
'smtp_account' => '发件账号',
'smtp_pwd' => '授权密码',
'smtp_from' => '发件人邮箱',
'save_smtp' => '保存配置',
'save_success' => '保存成功',
],
'en' => [
'page_subtitle' => 'Advantest · SMTP Mail Config',
'smtp_config' => 'SMTP Mail Config',
'smtp_host' => 'SMTP Host',
'smtp_port' => 'Port',
'smtp_ssl' => 'Enable SSL/TLS',
'smtp_account' => 'SMTP Account',
'smtp_pwd' => 'Auth Password',
'smtp_from' => 'Sender Email',
'save_smtp' => 'Save Config',
'save_success' => 'Saved successfully',
]
];
$t = $langMap[$currentLang];
// 保存提交
if ($_POST['act'] === "save_smtp") {
$host = trim($_POST['smtp_host'] ?? '');
$port = intval($_POST['smtp_port'] ?? 25);
$ssl = intval($_POST['smtp_ssl'] ?? 0);
$user = trim($_POST['smtp_user'] ?? '');
$pwd = trim($_POST['smtp_pass'] ?? '');
$from = trim($_POST['smtp_from'] ?? '');
mysqli_query($conn, "UPDATE sys_smtp_config SET smtp_host='$host',smtp_port=$port,smtp_ssl=$ssl,smtp_user='$user',smtp_pass='$pwd',send_from='$from' WHERE id=1");
echo "";
exit;
}
// 1. 先判断SQL不为空，避免空查询警告
$sql = "SELECT * FROM sys_smtp_config WHERE id = 1";
if (!empty($sql)) {
$res = mysqli_query($conn, $sql);
// 2. 判断查询成功且返回有效结果集再执行fetch
if ($res instanceof mysqli_result) {
$smtpRow = mysqli_fetch_assoc($res);
} else {
$smtpRow = [];
}
} else {
$smtpRow = [];
}
$smtpConfig = $smtpRow ?? [];
?>
SMTP Config - Advantest