php 数据库内容增删改查----增

首先，建立一个主页面（crud.php）

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>Title</title>

</head>

<body>

<?php

$db = new Mysqli("localhost","root","root","student");

!empty(mysqli_connect_error())?die("连接错"):"";

$sql = "select * from student";

$data = $db->query($sql)->fetch_all();

//var_dump($data);

<table border="1">

    <tr>

        <td>ID</td>

        <td>姓名</td>

        <td>性别</td>

        <td>出生年月</td>

        <td>班级</td>

        <td>删除</td>

        <td>修改</td>

    </tr>

    <?php

    foreach ($data as $i){

        if ($i[2] == 1){

            $i[2] = "男";

        }

        else if ($i[2] == 0){

            $i[2] = "女";

        }

        else{

            $i[2] = "保密";

        }

        echo "<tr><td>{$i[0]}</td><td>{$i[1]}</td><td>{$i[2]}</td><td>{$i[3]}</td><td>{$i[4]}</td><td><a href='dele.php?id={$i[0]}'>&nbsp;删除&nbsp;</a></td><td><a href='edit.php'>&nbsp;修改&nbsp;</a></td><tr>";

    }

    ?>

<!--    2-->

</table>

<a href="add.php">新增用户</a>

</body>

</html>

一、增加

1、建立add.php ，插入表单

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>Title</title>

</head>

<body>

    <form method="post" action="addpost.php">

        <input type="text" name="Sno" placeholder="id">

        <input type="text" name="Sname" placeholder="姓名">

        <input type="radio" name="Ssex" value="1" id="man"><label for="man">男</label>

        <input type="radio" name="Ssex" value="0" id="woman"><label for="woman">女</label>

        <input type="text" name="Sbirthday" placeholder="出生年月">

        <input type="text" name="Class" placeholder="班级">

        <input type="submit" value="提交">

    </form>

</body>

</html>

2、在addpost.php里做数据库增加处理

<?php

$id = $_POST['Sno'];

$name = $_POST['Sname'];

$sex = $_POST['Ssex'];

$birthday = $_POST['Sbirthday'];

$class = $_POST['Class'];

$db = new Mysqli("localhost","root","root","student");

$sql = "insert into student.student VALUES ('{$id}','{$name}','{$sex}','{$birthday}','{$class}',0)";

//var_dump($db->query($sql));

if ($db->query($sql)){

    header("location:crud.php");

}else{

    header("location:add.php");

}

测试一下：

1、主页

2、点击增加用户增加内容

3、点击提交，看一下

4、完成 ^-^

巴特西

php 数据库内容增删改查----增

最新文章

热门文章