首页 > 技术文章 > PHP 增删改查 import!!

zhaimiaoer 2016-05-10 11:13 原文

主页面

<h1>主页面family</h1> <table width="100%" border="1px" cellpadding="0" cellspacing="0" > <tr> <td>ID</td> <td>INFOCODE</td> <td>NAME</td> <td>TITLE</td> <td>FIRM</td> <td>ORDERS</td> <td width="80" >UPDATE</td> <td width="80" >DELETE</td> </tr> <?PHP //造连接对象 $fam = new MySQLi("localhost","root","","zw"); //判断是否连接 !mysqli_connect_error() or die("连接失败"); //写SQL语句 $sql="select * from family"; //执行语句 $result = $fam->query($sql); //取数据 $attr = $result->fetch_all(); foreach($attr as $v) { //关系名称 $sql2="select Name from title where Code='{$v[3]}'"; $rname=$fam->query($sql2); $attn=$rname->fetch_row(); echo "<tr> <td>{$v[0]}</td> <td>{$v[1]}</td> <td>{$v[2]}</td> <td>{$attn[0]}</td> <td>{$v[4]}</td> <td>{$v[5]}</td> <td align='center'><a href='Update.php?Ids={$v[0]}'>更改</a></td> <td align='center'><a href='Delete.php?Ids={$v[0]}'>删除</a></td> </tr>"; } ?> </table> <div><a href="Add.php">添加数据</a></div>
添加页面

<h1>添加数据</h1> <form action="AddChuLi.php" method="post"> Ids:<div><input type="text" name="Ids" /></div> 代号:<div><input type="text" name="Infocode" /></div> 姓名:<div><input type="text" name="Name" /></div> 关系:<div> <select name="gx"> <?php $fam=new MySQLi("localhost","root","","zw"); !mysqli_connect_error() or die("失败"); $sql="select * from title"; $r=$fam->query($sql); $attr=$r->fetch_all(); foreach($attr as $v) { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } ?> </select> </div> 工作单位:<div><input type="text" name="Firm" /></div> Orders:<div><input type="text" name="Orders" /></div> <div><input type="submit" value="提交" /></div> </form> <div><a href="main.php">主页面</a></div>
纯PHP 添加处理页面
<?php $Ids=$_POST["Ids"]; $Infocode=$_POST["Infocode"]; $Name=$_POST["Name"]; $Title=$_POST["gx"]; $Firm=$_POST["Firm"]; $Orders=$_POST["Orders"]; $fam=new MySQLi("localhost","root","","zw"); !mysqli_connect_error() or die("连接失败!"); $sql="insert into family values('{$Ids}','{$Infocode}','{$Name}','{$Title}','{$Firm}','{$Orders}')"; $result=$fam->query($sql); if($result) { header("location:Add.php"); } else { echo "添加失败"; }
修改页面
<h1>修改数据</h1> <?php $Ids=$_GET["Ids"]; $fam=new MySQLi("localhost","root","","zw"); !mysqli_connect_error() or die("失败"); $sql1="select * from family where Ids={$Ids}"; $r=$fam->query($sql1); $att=$r->fetch_row(); ?> <form action="UpdateChuLi.php" method="post"> Ids:<div><input readonly="readonly" type="text" name="Ids" value="<?php echo $att[0] ?>"/></div> 代号:<div><input readonly="readonly" type="text" name="Infocode" value="<?php echo $att[1] ?>" /></div> 姓名:<div><input type="text" name="Name" value="<?php echo $att[2] ?>" /></div> 关系:<div> <select name="gx"> <?php $sql="select * from title"; $r=$fam->query($sql); $attr=$r->fetch_all(); foreach($attr as $v) { if($v[0]==$att[3]) { echo "<option selected='selected' value='{$v[0]}'>{$v[1]}</option>"; } else { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } } ?> </select> </div> 工作单位:<div><input type="text" name="Firm" value="<?php echo $att[4] ?>" /></div> Orders:<div><input type="text" name="Orders" value="<?php echo $att[5] ?>"/></div> <div><input type="submit" value="提交" /></div> </form> <div><a href="main.php">主页面</a></div>
纯PHP 修改处理页面
<?php
$Ids=$_POST["Ids"];
$Infocode=$_POST["Infocode"];
$Name=$_POST["Name"];
$Title=$_POST["Title"];
$Firm=$_POST["Firm"];
$Orders=$_POST["Orders"];

$fam=new MySQLi("localhost","root","","zw");
!mysqli_connect_error() or die("连接失败!");
$sql="Update family set Name='{$Name}',Title='{$Title}',Firm='{$Firm}',Orders='{$Orders}'where Ids='{$Ids}'"; 
$result=$fam->query($sql);

if($result)
{
    header("location:main.php");
}
else
{
    echo "失败";
}
纯PHP 修改处理页面
<?php
$Ids=$_GET["Ids"];
$fam=new MySQLi("localhost","root","","zw");
!mysqli_connect_error() or die("失败");
$sql="delete from family where Ids={$Ids}";
$r=$fam->query($sql);
if($r)
{
    header("location:main.php");
}
else
{
    echo "删除失败";
}

 

推荐阅读