MySQL - Insert into data or update if exists

Question

INSERT only once into MySQL or update if exists. Here ticket_id is unique key but data not insert nor update.

 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);
    }

**Here I have solved the above code as per 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);
        }

possible duplicate of http://stackoverflow.com/questions/1361340/how-to-insert-if-not-exists-in-mysql?rq=1 have a look.. — Sonu Bamniya, Jun 20 '16 at 11:17
I think you need to add this piece of code: `mysql_query('COMMIT')` or this one: `mysql_query('SET autocommit=1')`. Also, are you sure that each `isset` is returning a `True` value? — omar, Jun 20 '16 at 11:28
@omar I have added Answer in my question section. Actually it does not need key to update the row So, I removed `WHERE ticket_id = '".$ticket_id."'` and it works !! — Firefog, Jun 20 '16 at 11:32

score -1 · Answer 1 · answered Jun 20 '16 at 11:13

-1

Use INSERT {...} ON DUPLICATE KEY UPDATE

Read here

Also, this is a Duplicate Question: Check this

answered Jun 20 '16 at 11:13

SiNONiMiTY

521
2
11

Read the question and the queries again. Flag as dupe, do not post answer. This answer has almost no useful parts, please read [answer] in [help] – Pred Jun 20 '16 at 11:16

MySQL - Insert into data or update if exists

1 Answers1