当前位置：首页 > PHP

php实现分页增删改差

2026-02-14 04:28:46PHP

PHP实现分页增删改查

数据库连接配置

创建config.php文件配置数据库连接信息：

<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'database_name';

$conn = new mysqli($host, $user, $pass, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
?>

分页查询功能

创建list.php实现分页查询：

<?php
require 'config.php';

$per_page = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page;

$sql = "SELECT * FROM your_table LIMIT $start, $per_page";
$result = $conn->query($sql);

$total_sql = "SELECT COUNT(*) FROM your_table";
$total_result = $conn->query($total_sql);
$total_row = $total_result->fetch_row();
$total = $total_row[0];
$pages = ceil($total / $per_page);

while($row = $result->fetch_assoc()) {
    echo "ID: {$row['id']} - Name: {$row['name']}<br>";
}

for ($i=1; $i<=$pages; $i++) {
    echo "<a href='list.php?page=$i'>$i</a> ";
}
?>

添加数据功能

创建add.php实现数据添加：

<?php
require 'config.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $sql = "INSERT INTO your_table (name) VALUES ('$name')";

    if ($conn->query($sql) === TRUE) {
        header("Location: list.php");
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}
?>

<form method="post">
    Name: <input type="text" name="name">
    <input type="submit" value="Add">
</form>

编辑数据功能

创建edit.php实现数据编辑：

<?php
require 'config.php';

if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $sql = "SELECT * FROM your_table WHERE id=$id";
    $result = $conn->query($sql);
    $row = $result->fetch_assoc();
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $id = $_POST['id'];
    $name = $_POST['name'];
    $sql = "UPDATE your_table SET name='$name' WHERE id=$id";

    if ($conn->query($sql) === TRUE) {
        header("Location: list.php");
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}
?>

<form method="post">
    <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
    Name: <input type="text" name="name" value="<?php echo $row['name']; ?>">
    <input type="submit" value="Update">
</form>

删除数据功能

创建delete.php实现数据删除：

<?php
require 'config.php';

if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $sql = "DELETE FROM your_table WHERE id=$id";

    if ($conn->query($sql) === TRUE) {
        header("Location: list.php");
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}
?>

安全注意事项

使用预处理语句防止SQL注入：

$stmt = $conn->prepare("INSERT INTO your_table (name) VALUES (?)");
$stmt->bind_param("s", $name);
$name = $_POST['name'];
$stmt->execute();

分页优化建议

添加分页导航样式和功能增强：

echo "<div class='pagination'>";
if ($page > 1) {
    echo "<a href='list.php?page=".($page-1)."'>Previous</a> ";
}
for ($i=1; $i<=$pages; $i++) {
    if ($i == $page) {
        echo "<span class='current'>$i</span> ";
    } else {
        echo "<a href='list.php?page=$i'>$i</a> ";
    }
}
if ($page < $pages) {
    echo "<a href='list.php?page=".($page+1)."'>Next</a> ";
}
echo "</div>";

以上代码实现了一个完整的PHP分页增删改查系统，包含数据库连接、分页查询、数据添加、编辑和删除功能。使用时需要根据实际数据库表结构调整SQL语句和字段名称。

php实现分页增删改差