该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
require ('../config/conn.php');
$staffcode=$_POST['staffcode'];
$old=$_POST['age'];
$phone=$_POST['phone'];
$address=$_POST['address'];
$role=$_POST['role'];
$locationid=$_POST['locationid'];
$password=$_POST['password'];
if(($old<=18) && ($old>=60)) {echo"";
echo"";}
if(strlen($phone)!=11){echo"";echo"";}
if(strlen($password)!=6){echo"";echo"";}
$sql="update farmerinfo set old='$old',phone='$phone',address='$address',role='$role',locationID='$locationid',$password='$password' where staffcode='$staffcode'";
$info=mysql_query($sql,$conn);
if(!empty($info)){ header("Location:staffinformation.php");}
else{echo"";}
?>
update语句在SQL中试过可以执行,但是在程序里就是更新不到数据库中。本人是php入门新手,求大神详解。万谢~~