<
?php
// 配置数据库连接
$host = 'localhost';
$dbname = 'syxywl.cn_sdk-14'; // 含特殊字符需用反引号包裹
$username = 'root';
$password = 'qq28009618';
$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)):
?>
<table>
<thead>
<tr>
<
?php foreach ($columns as $col):
?>
<th><
?= htmlspecialchars($col)
?></th>
<
?php endforeach;
?>
<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 ($columns as $col):
?>
<td>
<
?php if ($col === 'password'):
?>
<input type="password" name="<
?= htmlspecialchars($col)
?>"
value="<
?= htmlspecialchars($row[$col])
?>" placeholder="保持原密码">
<
?php else:
?>
<input type="text" name="<
?= htmlspecialchars($col)
?>"
value="<
?= htmlspecialchars($row[$col])
?>">
<
?php endif;
?>
</td>
<
?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>
增加一个uid读
取db_hk4e_user_gio数据名`t_player_uid数据表uid数据单
隐藏输入时间的PHP代码示例
本文将展示如何在PHP中使用`echo time()`函数插入一个隐藏的时间戳输入字段，确保网页数据的时效性和安全性。
扫一扫
956
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
