phpincluding the Mysql connect parameters$link = mysqli_connectlocalhost admin admin data_breach;if !$link die连接失败 mysqli_connect_error;!DOCTYPE htmlhtml lang=zh-CNhead meta http-equiv=Conten
<?php
//including the Mysql connect parameters.
$link = mysqli_connect("localhost", "admin", "admin", "data_breach");
if (!$link) {
die("连接失败: " . mysqli_connect_error());
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<link rel="stylesheet" href="new3.css">
<title>操作</title>
<style>
.scrollable-table {
max-height: 400px;
overflow-y: auto;/*滚动条*/
background-color: white;
}
table {
border-collapse: collapse;
width: 100%;
}
<pre><code> th, td {
border: 1px solid black; /* 添加单元格边框 */
padding: 8px;
text-align: left;
}
tr:nth-child(even) {
background-color: #f2f2f2; /* 添加偶数行背景色 */
}
.modify-data{
margin-top: 20px;
margin-bottom: 20px;
}
.hidden {
display: none;
}
</style>
</code></pre>
</head>
<body background="../../images/DNA1.jpg">
<div class="query">
<div class="query-a">
<form action="query1.php" method="post" id="query-num-form">
<h3>查询数据</h3>
<select name="query-menu" class="query-menu">
<option value="S_num">编号</option>
<option value="Method">泄露原因</option>
<option value="Year">泄露时间</option>
<option value="Records">泄露量</option>
<option value="Organization_type">公司类型</option>
<option value="Entity">公司名</option>
</select>
<div class="modify-data">
查询：
<input type="text" name="input" placeholder="请输入...">
</div>
<button type="submit" class="normal-button">提交</button>
<button type="button" class="leave-button" onclick="showVerification()">暂时离开</button>
</form>
<br>
<form action="query1.php" method="post" class="verification-form hidden">
<label>请输入密码：</label>
<input type="password" name="password">
<button type="button" onclick="verifyPassword()">验证</button>
</form>
</div>
<pre><code><div class="xianshi">
<?php
if (isset($_POST['leave-button'])) {
echo '<script>showVerification()</script>';
} else if (isset($_POST['password']) && $_POST['password'] == '8679root') {
$query_result = mysqli_query($link, "SELECT * FROM databreaches");
if ($query_result) {
if (mysqli_num_rows($query_result) > 0) {
echo '<div class="scrollable-table">';
echo '<table>';
// 输出表头
echo '<tr>';
while ($row = mysqli_fetch_assoc($query_result)) {
if (!isset($data)) {
echo '<th>' . implode('</th><th>', array_keys($row)) . '</th>';
}
$data[] = $row;
}
echo '</tr>';
// 输出数据行
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . implode('</td><td>', $row) . '</td>';
echo '</tr>';
}
echo '</table>';
echo '</div>';
} else {
echo '查询结果为空';
}
} else {
echo mysqli_error($link);
mysqli_rollback($link); //回滚事务
mysqli_close($link);
}
} else {
if (isset($_POST['query-menu']) && isset($_POST['input'])) {
$name = $_POST['query-menu'];
$value = mysqli_real_escape_string($link, $_POST['input']);
// 关闭自动提交
mysqli_autocommit($link, FALSE);
// 获取表名
$table_sname_query = "SELECT table_sname FROM connection WHERE columns_sname='$name'";
$table_sname_result = mysqli_query($link, $table_sname_query);
$table_sname_row = mysqli_fetch_assoc($table_sname_result); // 将查询结果返回到数组中
$table_sname = $table_sname_row['table_sname']; // 只获取table_name
if ($name == "Year" or $name == "Records" or $name == "S_num") {
$value = (int)$value;
// 查询数据
$query_ = "SELECT * FROM $table_sname WHERE $name=$value";
$query_result = mysqli_query($link, $query_);
} else {
// 查询数据
$query_ = "SELECT * FROM $table_sname WHERE $name='$value'"; // 字符串类型必须加''
$query_result = mysqli_query($link, $query_);
}
mysqli_commit($link); //提交事务
} else {
// 如果查询结果为空，默认显示所有数据
$query_result = mysqli_query($link, "SELECT * FROM databreaches");
}
if ($query_result) {
if (mysqli_num_rows($query_result) > 0) {
echo '<div class="scrollable-table">';
echo '<table>';
// 输出表头
echo '<tr>';
while ($row = mysqli_fetch_assoc($query_result)) {
if (!isset($data)) {
echo '<th>' . implode('</th><th>', array_keys($row)) . '</th>';
}
$data[] = $row;
}
echo '</tr>';
// 输出数据行
foreach ($data as $row) {
echo '<tr>';
echo '<td>' . implode('</td><td>', $row) . '</td>';
echo '</tr>';
}
echo '</table>';
echo '</div>';
} else {
echo '查询结果为空';
}
} else {
echo mysqli_error($link);
mysqli_rollback($link); //回滚事务
mysqli_close($link);
}
}
?>
</div>
</code></pre>
</div>
<script>
function showVerification() {
document.getElementById("query-num-form").classList.add('hidden');
document.querySelector(".leave-button").classList.add('hidden');
document.querySelector(".verification-form").classList.remove('hidden');
}
<pre><code>function verifyPassword() {
const passwordInput = document.querySelector("input[name='password']");
if (passwordInput.value === '8679root') {
alert("欢迎回来！");
document.querySelector(".verification-form").classList.add('hidden');
const form = document.createElement('form');
form.action = 'query1.php';
form.method = 'post';
document.body.appendChild(form);
form.submit();
} else {
alert("密码错误，请重新输入！");
}
}
</code></pre>
</script>
</body>
</html
原文地址: https://www.cveoy.top/t/topic/g9sc 著作权归作者所有。请勿转载和采集!