问题描述:没有报错,但数据无法写进数据库里。
问题代码:
$id=isset($_POST['id']) ? $_POST['id'] : '';
echo $id;
$caipin=isset($_POST['caipin']) ? $_POST['caipin'] : '';
echo $caipin;
$caixi=isset($_POST['caixi']) ? $_POST['caixi'] : '';
$zhuliao=isset($_POST['zhuliao']) ? $_POST['zhuliao'] : '';
$fuliao=isset($_POST['fuliao']) ? $_POST['fuliao'] : '';
$zuofa=isset($_POST['zuofa']) ? $_POST['zuofa'] : '';
if($id=null){
$sql="INSERT INTO database.cai(caipin,zhuliao,tiaoliao,zuofa,type) VALUES ('$caipin','$zhuliao','$fuliao','$zuofa',$caixi')" ;
mysqli_query($conn,$sql);
$mark=mysqli_affected_rows();/*返回影响行数*/
echo"<script>alert('添加完成');</script>";
}else{
$sql="UPDATE database.cai SET caipin='$caipin',zhuliao='$zhuliao',tiaoliao='$fuliao',zuofa='$zuofa' ,type='$caixi' where id='$id'" ;
mysqli_query($conn,$sql);
$mark=mysqli_affected_rows($conn);
echo"<script>alert('更新完成');</script>";
}if($mark>0){
echo"<script>window.location.href='../root/admin.php?back=<?php echo $Function;?>';</script>";
}
echo "Error: " . mysqli_connect_error();
运行结果: