php实现分页增删改差
PHP实现分页增删改查
数据库连接配置
创建一个config.php文件用于数据库连接配置：
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$dbname = 'test_db';
$conn = new mysqli($host, $user, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>分页查询实现
创建index.php实现分页显示数据：
<?php
include 'config.php';
$limit = 5;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$start = ($page - 1) * $limit;
$sql = "SELECT * FROM users LIMIT $start, $limit";
$result = $conn->query($sql);
// 显示数据表格
echo "<table border='1'>";
echo "<tr><th>ID</th><th>Name</th><th>Email</th><th>Actions</th></tr>";
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['name']."</td>
<td>".$row['email']."</td>
<td>
<a href='edit.php?id=".$row['id']."'>Edit</a>
<a href='delete.php?id=".$row['id']."'>Delete</a>
</td>
</tr>";
}
echo "</table>";
// 分页链接
$sql = "SELECT COUNT(id) AS total FROM users";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$total_pages = ceil($row['total'] / $limit);
for ($i = 1; $i <= $total_pages; $i++) {
echo "<a href='index.php?page=".$i."'>".$i."</a> ";
}
$conn->close();
?>添加数据功能
创建create.php实现数据添加：
<?php
include 'config.php';
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST['name'];
$email = $_POST['email'];
$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
if ($conn->query($sql) === TRUE) {
header("Location: index.php");
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
?>
<form method="post">
Name: <input type="text" name="name"><br>
Email: <input type="text" name="email"><br>
<input type="submit" value="Add">
</form>编辑数据功能
创建edit.php实现数据编辑：
<?php
include 'config.php';
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$sql = "UPDATE users SET name='$name', email='$email' WHERE id=$id";
if ($conn->query($sql) === TRUE) {
header("Location: index.php");
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$id = $_GET['id'];
$sql = "SELECT * FROM users WHERE id=$id";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
?>
<form method="post">
<input type="hidden" name="id" value="<?php echo $row['id']; ?>">
Name: <input type="text" name="name" value="<?php echo $row['name']; ?>"><br>
Email: <input type="text" name="email" value="<?php echo $row['email']; ?>"><br>
<input type="submit" value="Update">
</form>删除数据功能
创建delete.php实现数据删除：
<?php
include 'config.php';
$id = $_GET['id'];
$sql = "DELETE FROM users WHERE id=$id";
if ($conn->query($sql) === TRUE) {
header("Location: index.php");
} else {
echo "Error deleting record: " . $conn->error;
}
$conn->close();
?>数据库表结构
确保数据库中有一个users表：
CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
email VARCHAR(50) NOT NULL
);安全注意事项
- 使用预处理语句防止SQL注入
- 对用户输入进行验证和过滤
- 添加CSRF保护
- 实现用户认证和授权
以上代码实现了基本的PHP分页增删改查功能，可以根据实际需求进行扩展和完善。
