mysql语句在PHPMYADMIN中能执行更新,放在页面中PHP运行不报错,但是数据库不更新
我把MYSQL语句拿到phpmyadmin中去执行,数据库能更新,
<?php
include ('../config/config.php');
$id = $_POST['id'];
$gzff = 1;
if ($_POST['gz'] == 0)
{
echo "<script>alert('工资不能为空!');location.href='".$_SERVER["HTTP_REFERER"]."';</script>";
}else{
$gz = $_POST['gz'];
}
$gzff = 1;
$sql = "UPDATE `plan` SET `gz`='$gz',`gzff`='$gzff',`ffren`='$chaozuo' WHERE 'id' ='$id'";
echo $sql;
if (mysqli_query($conn, $sql)) {
echo "<script>alert('工资发放成功!');location.href='".$_SERVER["HTTP_REFERER"]."';</script>";
} else {
echo "<script>alert('工资发放失败!');location.href='".$_SERVER["HTTP_REFERER"]."';</script>" ;
}
mysqli_close($conn);
?>
$sql = "UPDATE `plan` SET `gz`='$gz',`gzff`='$gzff',`ffren`='$chaozuo' WHERE `id` ='$id'";
问题可能在于 WHERE 'id' ='$id' 你的id 字段不应该用单引号
卡住了吧,多刷新下试试
事务没提交