ntrol" placeholder="请输入库存" name="kucun" value="<?php echo $arr[4] ?>">
</div>
<button type="submit" class="btn btn-primary sub">提交</button>
</div>
</div>
</form>
</body>
</html>
update(修改处理页面)
<?php
$code = $_POST["code"];
$name= $_POST["name"];
$price = $_POST["price"];
$chandi = $_POST["chandi"];
$kucun = $_POST["kucun"];
$db = new MYSQLi("localhost","root","","0710_info");
$sql = "update fruit set
name='{$name}',price={$price},source='{$chandi}',numbers={$kucun} where ids='{$code}'";
if($db->query($sql)){
header("location:del_page.php");
}else{
echo "修改失败!";
}
第四步:实现对数据库中数据的批量选择与删除的功能(与主界面连接)
JS操作代码如下:
<script>
function qx(qx){
var ck = document.getElementsByClassName("ck");
for(var i=0;i<ck.length;i++){
ck[i].checked=qx.checked;
}
}
</script>
PHP操作代码如下:
<?php
$arr= $_POST["sub"];
require_once "./DBDA.class.php";//加载类进入操作界面
$db = new DBDA();
$str = implode("','", $arr);
$sql = "delete from fruit where ids in ('{$str}')";
if($db->query($sql,1)){
header("location:del_page.php");
}else{
echo "删除失败!";
}
***这里进行了数据访问类的封装操作(优化使用)
PHP代码如下:
<?php
class DBDA{
public $host="localhost";
public $uid="root";
public $pwd="";
public $dbname="0710_info";
/*
query方法:执行用户给的sql语句,并返回相应的结果
$sql:用户需要执行的sql语句
$type:用户需要执行的sql语句的类型
return:如果是增删语句改返回true或false,如果是查询语句返回二维数组
*/
public function query($sql,$type=1){//默认true为增删改
$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
if(mysqli_connect_error()){
return "连接失败!";