只在MySQL或update中插入一次。在这里,ticket_id是唯一键,但数据不是插入或更新。
if(isset($_POST['A1'])){
$seat_no = $_POST['A1'];
$sql_2 = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ticket_details SET ".$seat_no." = '".$ticket_status."' WHERE ticket_id = '".$ticket_id."'";
mysql_query($sql_2);
}
if(isset($_POST['A2'])) {
$seat_no = $_POST['A2'];
$sql_2 = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ticket_details SET ".$seat_no." = '".$ticket_status."' WHERE ticket_id = '".$ticket_id."'";
mysql_query($sql_2);
}
if(isset($_POST['A3'])){
$seat_no = $_POST['A3'];
$sql_2 = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ticket_details SET ".$seat_no." = '".$ticket_status."' WHERE ticket_id = '".$ticket_id."'";
mysql_query($sql_2);
}**这里我已经按照this Answer解决了上面的代码**
if(isset($_POST['A1'])){
$seat_no = $_POST['A1'];
$sql = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ".$seat_no." = '".$ticket_status."' ";
$res = mysql_query($sql);
}
if(isset($_POST['A2'])) {
$seat_no = $_POST['A2'];
$sql = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ".$seat_no." = '".$ticket_status."' ";
$res = mysql_query($sql);
}
if(isset($_POST['A3'])){
$seat_no = $_POST['A3'];
$sql = "INSERT INTO ticket_details (ticket_id,".$seat_no.") VALUES('".$ticket_id."','".$ticket_status."') ON DUPLICATE KEY UPDATE ".$seat_no." = '".$ticket_status."' ";
$res = mysql_query($sql);
}发布于 2016-06-20 19:13:16
https://stackoverflow.com/questions/37921002
复制相似问题