我有一个注册表&如果'ID‘不存在,我会尝试插入数据。它工作得很好。现在,如果'ID‘已经存在,我将尝试更新数据。它根本不工作&我找不到错误。下面是我设置的ID存在与否的条件:
function staff_detail_exist($ic) {
$result = null;
$sql = "SELECT * FROM apply WHERE staffid = '$ic'";
$data = mysql_query($sql);
if (mysql_num_rows($data) == 0) {
$result = "available";
} else {
$result = "exist";
}
return $result;
}下面是我的插入和更新函数:
if (staff_detail_exist($ic) == "available") {
insert_staff_detail($ic, $name, $contact, $mail, $address, $paytype, $applicant);
echo "Workshop application successful! You will be notified shortly via E-mail after confirmation! Thank You!";
}
else if (staff_detail_exist($ic) == "exist") {
update_staff_detail($ic, $name, $contact, $mail, $address, $paytype);
echo "Staff Details Updated!" ;
}
function insert_staff_detail($ic, $name, $contact, $mail, $address, $paytype, $applicant) {
$sql = "INSERT INTO apply (staffid, staffname, staffno, staffemail, staffaddress, paytype, applicant) VALUES ('$ic', '$name', '$contact', '$mail', '$address','$paytype', '$applicant')";
mysql_query($sql);
}
function update_staff_detail($ic, $name, $contact, $mail, $address, $paytype){
$sql = "UPDATE apply
SET staffname='$_POST[name]',
staffno='$_POST[contact]',
staffmail='$_POST[mail]',
address='$_POST[address]',
paytype='$_POST[paytype]'
WHERE staffid='$_POST[ic]'";
mysql_query($sql);
}有什么建议吗?谢谢!
发布于 2012-12-10 11:02:00
观察:当你收到POST变量时,你必须指明。update_staff_detail方法应该以与获取insert_staff_detail方法相同的方式接收POST变量。
变更:update_staff_detail的定义
To:
function update_staff_detail($ic, $name, $contact, $mail, $address, $paytype){
$sql = "UPDATE apply
SET staffname='$name',
staffno='$contact',
staffmail='$mail',
address='$address',
paytype='$paytype'
WHERE staffid='$ic' LIMIT 1";
mysql_query($sql);
}致以问候。
https://stackoverflow.com/questions/13794297
复制相似问题