I want to return an identity column passid after inserting a few values into a table. passid is an autoincrement column. I'm using the OUTPUT clause to get it done.
This is my code:
$sql = "INSERT INTO `PASSENGERS`(`passname`, `passdob`, `passgen`, `passadd`, `passproof`, `passmobile`, `passemail`, `flight_no`, `org`, `dest`, `bookingemail`, `dot`) VALUES ('$passname1','$passdob1','$passgen1','$passadd1','$passproof1','$passmobile1','$passemail1','$flight_no','$origin','$destination','$bookingemail','$dateoftravel') OUTPUT INSERTED.passid VALUES('$passname1','$passdob1','$passgen1','$passadd1','$passproof1','$passmobile1','$passemail1','$flight_no','$origin','$destination','$bookingemail','$dateoftravel');";
If I execute this SQL query:
INSERT INTO `PASSENGERS`(`passname`, `passdob`, `passgen`, `passadd`, `passproof`, `passmobile`, `passemail`, `flight_no`, `org`, `dest`, `bookingemail`, `dot`) VALUES ('ABC','2019-11-30','Male','DFA','Aadhar Card','1234567890','ABC@gmail.com','SB1123','Bengaluru','Hyderabad','mkchaaru@yahoo.com','2019-11-15') OUTPUT INSERTED.passid VALUES('ABC','2019-11-30','Male','DFA','Aadhar Card','1234567890','ABC@gmail.com','SB1123','Bengaluru','Hyderabad','mkchaaru@yahoo.com','2019-11-15');
I'm getting these errors:
Unexpected token. (near "OUTPUT" at position 312)
Unexpected beginning of statement. (near "OUTPUT" at position 312)
Unexpected beginning of statement. (near "INSERTED" at position 319)
Unexpected beginning of statement. (near "passid" at position 328)
Unrecognized statement type. (near "VALUES" at position 335)
My table structure
