对数据库的增删改查

1.建test.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr bgcolor="#33FFCC">
    <td>代号</td>
    <td>姓名</td>
    <td>性别</td>
    <td>民族</td>
    <td>生日</td>
    <td>操作</td>
</tr>
<?php

//造连接对象
$db = new MySQLi("localhost","root","1234","testa");
//判断连接是否成功
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
$sql = "select * from Info";
//执行SQL语句
$result = $db->query($sql);
//处理查询的结果
$attr = $result->fetch_all();

for($i=0;$i<count($attr);$i++)
{
    echo "<tr>";
    for($j=0;$j<count($attr[$i]);$j++)
    {
        echo "<td>{$attr[$i][$j]}</td>";
    }
    
    echo "<td><a href='Delete.php?code={$attr[$i][0]}'>删除</a><a href='Update.php?code={$attr[$i][0]}'>修改</a></td>";
    echo "</tr>";
}

?>
</table>
<br />
<a href="Add.php"><input type="button" value="添加数据" /></a>



</body>
</html>

2.建立Add.php，点击‘添加数据’跳转到本页

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<form action="Addchuli.php" method="post">
    <div>
        代号：
        <input type="text" name="code" />
    </div>
    <div>
        姓名：
        <input type="text" name="name" />
    </div>
    <div>
        性别：
        男<input type="radio" value="true" name="sex" checked="checked" /> &nbsp;
        女<input type="radio" value="false" name="sex" />
    </div>
    <div>
        民族：
        <select name="nation">
            <?php
            
            //造连接对象
            $db = new mysqli("localhost","root","1234","testa");
            //判断是否出错
            !mysqli_connect_error() or die("连接失败！");
            //写SQL语句
            $sql = "select * from Nation";
            //执行SQL语句
            $result = $db->query($sql);
            
            //处理结果
            $attr = $result->fetch_all();
            for($i=0;$i<count($attr);$i++)
            {
                echo "<option value='{$attr[$i][0]}'>{$attr[$i][1]}</option>";
            }
            ?>
        </select>
    </div>
    <div>
        生日：
        <input type="text" name="birthday" />
    </div>
    <div>
        <input type="submit" value="确定" />
        <a href="test.php">返回主页</a>
    </div>
</form>
</body>
</html>

3.建立Addchuli.php用于处理Add.php‘添加数据’的处理

<?php

$code = $_POST["code"];
$name = $_POST["name"];
$sex = $_POST["sex"];
$nation = $_POST["nation"];
$birthday = $_POST["birthday"];

//造连接对象
$db = new mysqli("localhost","root","1234","testa");
//判断是否出错
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
$sql = "insert into Info values('{$code}','{$name}',{$sex},'{$nation}','{$birthday}')";
//执行SQL语句
$result = $db->query($sql);

if($result)
{
    header("location:Add.php");
}
else
{
    echo "执行失败！";
}

4.建立删除文件Delete.php

<?php

$code = $_GET["code"];

//造连接对象
$db = new mysqli("localhost","root","1234","testa");
//判断是否出错
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
$sql = "delete from Info where Code = '{$code}'";
//执行SQL语句
$result = $db->query($sql);

if($result)
{
    header("location:test.php");
}
else
{
    echo "删除失败！";
}

5.建立修改文件Update.php，跳转本页面，显示当前数据

注意：性别和民族。

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>

<?php
$code = $_GET["code"];

//造连接对象
$db = new mysqli("localhost","root","1234","testa");
//判断是否出错
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
$sqlxq = "select * from Info where Code = '{$code}'";
//执行SQL语句
$resultxq = $db->query($sqlxq);

$attrxq = $resultxq->fetch_row();

?>
<form action="UpdateChuLi.php" method="post">
    <div>
        代号：
        <input readonly="readonly" type="text" name="code" value="<?php echo $attrxq[0]; ?>" />
    </div>
    <div>
        姓名：
        <input type="text" name="name" value="<?php echo $attrxq[1]; ?>" />
    </div>
    <div>
        性别：
        男<input type="radio" value="true" name="sex" <?php echo $attrxq[2]?"checked='checked'":""; ?> /> &nbsp;
        女<input type="radio" value="false" name="sex" <?php echo $attrxq[2]?"":"checked='checked'"; ?> />
    </div>
    <div>
        民族：
        <select name="nation">
            <?php
            
            //写SQL语句
            $sql = "select * from Nation";
            //执行SQL语句
            $result = $db->query($sql);
            
            //处理结果
            $attr = $result->fetch_all();
            for($i=0;$i<count($attr);$i++)
            {
                if($attrxq[3] == $attr[$i][0])
                {
                    echo "<option selected='selected' value='{$attr[$i][0]}'>{$attr[$i][1]}</option>";
                }
                else
                {
                    echo "<option value='{$attr[$i][0]}'>{$attr[$i][1]}</option>";
                }
            }
            ?>
        </select>
    </div>
    <div>
        生日：
        <input type="text" name="birthday" value="<?php echo $attrxq[4]; ?>" />
    </div>
    <div>
        <input type="submit" value="修改" />
        <a href="test.php">返回主页</a>
    </div>
</form>
</body>
</html>

6.建立修改信息的UpdateChuLi.php文件

<?php

$code = $_POST["code"];
$name = $_POST["name"];
$sex = $_POST["sex"];
$nation = $_POST["nation"];
$birthday = $_POST["birthday"];

//造连接对象
$db = new mysqli("localhost","root","1234","testa");
//判断是否出错
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
$sql = "update Info set Name='{$name}',Sex={$sex},Nation='{$nation}',Birthday='{$birthday}' where Code = '{$code}'";


//执行SQL语句
$result = $db->query($sql);

if($result)
{
    header("location:test.php");
}
else
{
    echo "修改失败！";
}
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/Yue0327/p/5338762.html