Home > Article > Backend Development > PHP database addition, deletion, modification and query methods

PHP database addition, deletion, modification and query methods

一个新手Original: 2017-10-18 09:16:471858browse

First create a database db_0808, and import the table student in db_0808 into the web page.

CURD.php

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Title</title>
</head>
<body>
<?php
$db = new Mysqli("localhost","root","root","db_0808");
//!$db?"":die("链接错误");
empty(mysqli_connect_error())?"":die("链接错误");
$sql = "select * from student where is_delete=&#39;0&#39;";
//$data = $db->query($sql)->fetch_all();//索引数组形式的所有数据
?>
<table border="1">
    <tr>
        <td>id</td>
        <td>名字</td>
        <td>性别</td>
        <td>班级</td>
        <td>生日</td>
        <td>操作</td>
    </tr>
    <?php
    $result=$db->query($sql);
    while ($data=$result->fetch_row()){  //索引数组形式的第一条数据
//    foreach ($data as $i){
        if ($data[2]==1){
            $data[2]="男";
        }else if ($data[2]==0){
            $data[2]="女";
        }else{
            $data[2]="保密";
        }
        echo "<tr>
                 <td>{$data[0]}</td>
                 <td>{$data[1]}</td>
                 <td>{$data[2]}</td>
                 <td>{$data[3]}</td>
                 <td>{$data[4]}</td>
                 <td><a href=&#39;delete.php?id={$data[0]}&#39;>删除</a>
                     <a href=&#39;xiugai.php?id={$data[0]}&#39;>修改</a>
                 </td>
              </tr>";
    }
    ?>
</table>
<a href="add.php">新增用户</a>
</body>
</html>

Add new information to the database 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="name" placeholder="姓名">
    <input type="radio" name="sex" value="1" id="man"><label for="man">男</label>
    <input type="radio" name="sex" value="0" id="nv"><label for="nv">女</label>
    <input type="text" name="banji" placeholder="班级">
<!--    <input type="text" name="age" placeholder="年龄">-->
    <input type="text" name="birthday" placeholder="出生年月">
    <input type="submit" value="提交">
</form>
</body>
</html>

Process add.php information addpost.php

<?php
/**
 * Created by fcc
 * User: Administrator
 * Date: 2017/10/13
 * Time: 15:49 */$name = $_POST[&#39;name&#39;];//
 var_dump($name);
 $sex = $_POST[&#39;sex&#39;];
 $ban=$_POST[&#39;banji&#39;];//
 $age = $_POST[&#39;age&#39;];
 $birthday = $_POST[&#39;birthday&#39;];
 $db=new Mysqli("localhost","root","root","db_0808");
 $sql = "INSERT INTO student VALUES (null,&#39;{$name}&#39;,{$sex},{$ban},&#39;{$birthday}&#39;,DEFAULT,null)";
 if ($db->query($sql)){header("location:CURD.php");
}else{    header("location:add.php");
}

Add information successfully

Delete information delete.php

<?php/**
 * Created by fcc
 * User: Administrator
 * Date: 2017/10/14
 * Time: 10:56 */$id=$_GET[&#39;id&#39;];$db=new Mysqli("localhost","root","root","db_0808");empty(mysqli_connect_error())?"":die("链接错误");//$sql="DELETE FROM student WHERE Sno=&#39;{$id}&#39;";//彻底删除，数据库中内容删除$sql = "update student set is_delete = &#39;1&#39; where Sno= &#39;{$id}&#39;";//表面删除,数据库中内容仍存在if ($db->query($sql)){    header("location:CURD.php");
};

Change information page xiugai.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<?php
    $s = null;if(isset($_GET[&#39;id&#39;])){    
    $id = $_GET[&#39;id&#39;];    
    $db=new Mysqli("localhost","root","root","db_0808");    
    empty(Mysqli_connect_error())?"":die("连接错误");    
    $sql="select * from student where Sno=&#39;{$id}&#39;";    
    $r=$db->query($sql);//var_dump($r);
    $s=$r->fetch_row();
}?>
<form method="post" action="xiugaichuli.php">
    <input type="hidden" name="id" value="<?php echo $s[0]?>">
    <input type="text" name="name" placeholder="<?php echo $s[1]?>">
    <input type="radio" name="sex" value="0" <?php echo $s[2]?"":"checked=&#39;checked&#39;";   ?> id="nv"><label for="nv">女</label>
    <input type="radio" name="sex" value="1" <?php echo $s[2]?"checked=&#39;checked&#39;":"";   ?> id="nan"><label for="nan">男</label>
    <input type="text" name="banji" placeholder="<?php echo $s[3]?>">
    <!--    <input type="text" name="age" placeholder="年龄">-->
    <input type="text" name="birthday" placeholder="<?php echo $s[4]?>">
    <input type="submit" value="提交">
</form>
</body>
</html>

Change information processing page xiugaichuli.php

<?php
/**
 * Created by fcc
 * User: Administrator
 * Date: 2017/10/17
 * Time: 9:07
 */
$id=$_POST[&#39;id&#39;];
$name=$_POST[&#39;name&#39;];
$sex=$_POST[&#39;sex&#39;];
$banji=$_POST[&#39;banji&#39;];
$birthday=$_POST[&#39;birthday&#39;];
$db=new Mysqli("localhost","root","root","db_0808");
empty(Mysqli_connect_error())?"":"连接错误";
$sql="UPDATE student SET Sname=&#39;{$name}&#39;,Ssex=&#39;{$sex}&#39;,class=&#39;{$banji}&#39;,birthday=&#39;{$birthday}&#39;WHERE Sno=&#39;{$id}&#39;";
//var_dump($sql);
if ($db->query($sql)){
    header("location:CURD.php");
}

The above is the detailed content of PHP database addition, deletion, modification and query methods. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Implementation example of PHP greedy algorithmNext article：Implementation example of PHP greedy algorithm

See more

PHP database addition, deletion, modification and query methods

Related articles