PHP修改与删除

最新推荐文章于 2021-04-10 05:45:28 发布

weixin_30480651

最新推荐文章于 2021-04-10 05:45:28 发布

阅读量298

点赞数

文章标签： php xhtml

原文链接：http://www.cnblogs.com/sglq/p/7526811.html

版权

</head>

<table class="table table-hover">
<thead>
<tr>
<th>代号</th>
<th>名称</th>
<th>单价</th>
<th>产地</th>
<th>库存</th>
<th>操作</th>
</tr>
</thead>
<tbody>

<?php

$db = new MySQLi("localhost","root","","lian");
$sql = "select * from fruit";
$result = $db->query($sql);
$arr = $result->fetch_all();
foreach($arr as $v){
echo "<tr>
<td>{$v[0]}</td>
<td>{$v[1]}</td>
<td>{$v[2]}</td>
<td>{$v[3]}</td>
<td>{$v[4]}</td>
<td>
<a href='shanchu.php?code={$v[0]}' οnclick=\"return confirm('确定删除么？')\"><button type='button' class='btn btn-primary btn-xs'>删除</button></a>
<a href='xiugai.php?code={$v[0]}' οnclick=\"return confirm('确定修改么？')\"><button type='button' class='btn btn-primary btn-xs'>修改</button></a>
</td>
</tr>";
}
?>

</tbody>
</table>

</body>
</html>

　　修改页面

<!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>
<script src="../bootstrap/js/jquery-1.11.2.min.js"></script>
<script src="../bootstrap/js/bootstrap.min.js"></script>
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<style type="text/css">
*{ margin:0px auto; padding:0px}
.input-group{ margin-top:10px}
.queding{ margin-top:20px; margin-left:260px}
</style>
</head>

<?php
$code = $_GET["code"];
$db = new MySQLi("localhost","root","123","mydb");
$sql = "select * from fruit where ids='{$code}'";
$result = $db->query($sql);
$arr = $result->fetch_row();
?>

</form>
</body>
</html>

　修改处理页面

<?php
$code = $_POST["code"];
$name = $_POST["name"];
$price = $_POST["price"];
$chandi = $_POST["chandi"];
$kucun = $_POST["kucun"];

$db = new MySQLi("localhost","root","","lian");
$sql = "update fruit set name='{$name}',price={$price},source='{$chandi}',numbers={$kucun} where ids='{$code}'";

if($db->query($sql)){
header("location:test.php");
}else{
echo "error";
}

　　删除页面

<?php
$code = $_POST["code"];
$name = $_POST["name"];
$price = $_POST["price"];
$chandi = $_POST["chandi"];
$kucun = $_POST["kucun"];

$db = new MySQLi("localhost","root","123","mydb");
$sql = "update fruit set name='{$name}',price={$price},source='{$chandi}',numbers={$kucun} where ids='{$code}'";

if($db->query($sql)){
header("location:test.php");
}else{
echo "error";
}

转载于:https://www.cnblogs.com/sglq/p/7526811.html