<?
php
// 配置数据库连接
$host = 'localhost';
$dbname = 'syxywl.cn_sdk-14'; // 含特殊字符需用反引号包裹
$username = 'root';
$password = 'qq28009618';
// === 跨库
查询：获取每个 uid 对应的 name 字段 ===
try {
$uids = array_column($rows, 'uid');
if (!empty($uids)) {
$placeholders = str_repeat('?,', count($uids) - 1) . '?';
// 关键修改：这里选择的是 `name` 字段
$sql = "SELECT `uid`, `name` FROM `db_hk4e_user_gio`.`t_player_uid` WHERE `uid` IN ($placeholders)";
$stmt = $pdo->prepare($sql);
$stmt->execute($uids);
$playerMap = [];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$playerMap[$row['uid']] = $row['name']; // 使用 `name` 作为昵称
}
} else {
$playerMap = [];
}
} catch (PDOException $e) {
$playerMap = [];
error_log("跨库
查询失败: " . $e->getMessage());
}
$dsn = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";
try {
$pdo = new PDO($dsn, $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("数据库连接失败: " . $e->getMessage());
}
// 设置分页参数
$limit = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$page = max(1, $page);
$offset = ($page - 1) * $limit;
// === 获取主键字段名 ===
function getPrimaryKey($pdo, $table) {
$stmt = $pdo->prepare("DESCRIBE `$table`");
$stmt->execute();
$columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($columns as $col) {
if ($col['Key'] === 'PRI') {
return $col['Field']; // 返回主键字段名
}
}
return null; // 没有主键
}
$primaryKey = getPrimaryKey($pdo, 't_accounts');
if (!$primaryKey) {
die("错误：t_accounts 表没有定义主键！");
}
// 处理更新请求
if ($_
POST['action'] === 'update') {
$pkValue = $_
POST[$primaryKey]; // 使用实际主键
值
// 获取所有字段
$stmt = $pdo->prepare("DESCRIBE `t_accounts`");
$stmt->execute();
$columns = $stmt->fetchAll(PDO::FETCH_COLUMN);
$setParts = [];
$params = [];
foreach ($columns as $col) {
if ($col !== $primaryKey && isset($_
POST[$col])) { // 排除主键本身
$setParts[] = "`$col` = ?";
$params[] = $_
POST[$col];
}
}
$params[] = $pkValue; // WHERE
条件：主键 = ?
try {
$sql = "UPDATE `t_accounts` SET " . implode(', ', $setParts) . " WHERE `$primaryKey` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
echo "<div style='color:green;'>主键为 <strong>$pkValue</strong> 的记录已成功更新！</div>";
} catch (PDOException $e) {
echo "<div style='color:red;'>更新失败: " . $e->getMessage() . "</div>";
}
}
//
查询总行数
$totalStmt = $pdo->query("SELECT COUNT(*) FROM `t_accounts`");
$totalRows = $totalStmt->fetchColumn();
$totalPages = ceil($totalRows / $limit);
// 获取当前页数据
$stmt = $pdo->prepare("SELECT * FROM `t_accounts` LIMIT ? OFFSET ?");
$stmt->bindValue(1, $limit, PDO::PARAM_INT);
$stmt->bindValue(2, $offset, PDO::PARAM_INT);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
// 获取字段名
$columns = empty($rows) ? [] : array_keys($rows[0]);
?>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>动态编辑 t_accounts 数据表（智能主键）</title>
<style>
body { font-family: Arial, sans-serif; margin: 20px; background-color: #f7f7f7; }
table { width: 100%; border-collapse: collapse; margin-top: 20px; background-color: #fff; }
th, td { border: 1px solid #ccc; padding: 10px; text-align: left; }
th { background-color: #007BFF; color: white; }
input[type="text"], input[type="password"] {
width: 100%; padding: 5px; box-sizing: border-box;
}
button.save { background-color: #28a745; color: white; border: none; padding: 5px 10px; cursor: pointer; }
.pagination { margin: 20px 0; text-align: center; }
.pagination a, .pagination span {
display: inline-block; margin: 0 3px; padding: 8px 12px; text-decoration: none; border: 1px solid #ccc;
background-color: #fff; color: #007BFF;
}
.pagination a:hover { background-color: #007BFF; color: white; }
.pagination .current { background-color: #007BFF; color: white; font-weight: bold; }
.pagination .ellipsis { color: #999; background-color: transparent; border: none; }
</style>
</head>
<body>
<h1>MySQL 数据表：t_accounts（自动识别主键）</h1>
<p>本页面自动识别主键字段，支持安全更新。</p>
<?
php if (!empty($rows)): ?>
<?
php $visibleColumns = ['uid', 'name', 'email', 'type']; ?>
<table>
<thead>
<tr>
<?
php foreach ($visibleColumns as $col): ?>
<th><?= htmlspecialchars(ucfirst($col)) ?></th>
<?
php endforeach; ?>
<th>玩家昵称</th> <!-- 新增列 -->
<th>操作</th>
</tr>
</thead>
<tbody>
<?
php foreach ($rows as $row): ?>
<tr>
<form method="
post" style="display:inline;">
<input type="hidden" name="action" value="update">
<input type="hidden" name="<?= htmlspecialchars($primaryKey) ?>"
value="<?= htmlspecialchars($row[$primaryKey]) ?>">
<!-- 显示白名单字段 -->
<?
php foreach ($visibleColumns as $col): ?>
<td>
<?
php if ($col === $primaryKey): ?>
<?= htmlspecialchars($row[$col]) ?>
<input type="hidden" name="<?= htmlspecialchars($col) ?>"
value="<?= htmlspecialchars($row[$col]) ?>">
<?
php else: ?>
<input type="text" name="<?= htmlspecialchars($col) ?>"
value="<?= htmlspecialchars($row[$col] ?? '') ?>"
style="width:100%; padding:5px;">
<?
php endif; ?>
</td>
<?
php endforeach; ?>
<!-- 显示从 db_hk4e_user_gio.t_player_uid 查到的 nickname -->
<td>
<?
php echo htmlspecialchars($playerMap[$row['uid']] ?? '<i style="color:#999;">未找到</i>'); ?>
</td>
<!-- 隐藏其他字段防止
丢失 -->
<?
php foreach ($columns as $col): ?>
<?
php if (!in_array($col, $visibleColumns)): ?>
<input type="hidden"
name="<?= htmlspecialchars($col) ?>"
value="<?= htmlspecialchars($row[$col] ?? '') ?>">
<?
php endif; ?>
<?
php endforeach; ?>
<td><button type="submit" class="save">保存</button></td>
</form>
</tr>
<?
php endforeach; ?>
</tbody>
</table>
<!-- 分页导航：最多显示 3 个页码 -->
<div class="pagination">
<?
php if ($page > 1): ?>
<a href="?page=<?= $page - 1 ?>">上
一页</a>
<?
php else: ?>
<span>上
一页</span>
<?
php endif; ?>
<?
php
// 设置最多显示 3 个页码
$maxVisible = 3;
$half = (int)($maxVisible / 2); // 1
$start = $page - $half;
$end = $page + $half;
// 调整范围以确保始终显示 3 个（除非靠近边界）
if ($start < 1) {
$start = 1;
$end = min($totalPages, $start + $maxVisible - 1);
}
if ($end > $totalPages) {
$end = $totalPages;
$start = max(1, $end - $maxVisible + 1);
}
?>
<!-- 首页 + 左侧省略号 -->
<?
php if ($start > 1): ?>
<a href="?page=1">1</a>
<?
php if ($start > 2): ?>
<span class="ellipsis">...</span>
<?
php endif; ?>
<?
php endif; ?>
<!-- 显示最多 3 个页码 -->
<?
php for ($i = $start; $i <= $end; $i++): ?>
<?
php if ($i == $page): ?>
<span class="current"><?= $i ?></span>
<?
php else: ?>
<a href="?page=<?= $i ?>"><?= $i ?></a>
<?
php endif; ?>
<?
php endfor; ?>
<!-- 尾页 + 右侧省略号 -->
<?
php if ($end < $totalPages): ?>
<?
php if ($end < $totalPages - 1): ?>
<span class="ellipsis">...</span>
<?
php endif; ?>
<a href="?page=<?= $totalPages ?>"><?= $totalPages ?></a>
<?
php endif; ?>
<?
php if ($page < $totalPages): ?>
<a href="?page=<?= $page + 1 ?>">下
一页</a>
<?
php else: ?>
<span>下
一页</span>
<?
php endif; ?>
<span style="margin-left: 20px;">共 <?= $totalRows ?> 条记录，<?= $totalPages ?> 页</span>
</div>
<?
php else: ?>
<p>
该表中没有数据。</p>
<?
php endif; ?>
</body>
</html>
无法连接db_hk4e_user_gio 数据库
本文介绍了一个在PHP分页查询中遇到的问题：点击下一页时原本POST过来的值丢失。通过将搜索值存储在SESSION中并在另一个页面获取该值的方法成功解决了此问题。
扫一扫
310
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
