MySql and Post Method

Question

I'm Inserting data using method post to MySql database, but I don't want to insert duplicated data in this database.

I used this:

$insertar="INSERT INTO datos(`nombre`, `cedula`, `Correo`, `telefono`, `ptd`) 
VALUES ('".$_POST['Nombre']."','".$_POST['Identificacion']."','".$_POST['Email']."','".$_POST['Telefono']."','".$_POST['ptd']."')ON DUPLICATE KEY UPDATE nombre=nombre AND cedula=cedula AND Correo=Correo AND telefono=telefono and ptd=ptd;";

$resultado=mysqli_query($conexion,$insertar) or die ('Error en el query database- insertar datos');

but it gives me this mistake:

This is

I need: if the value already is in the database do nothing and continue normally.

May I recommend StackOverflow en Español: https://es.stackoverflow.com/ — alanfcm, Aug 15 '18 at 21:59
Maybe space between your parentheses and ON solve your problem — M4HdYaR, Aug 15 '18 at 22:13
Here is great explanation https://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update — Eldlabs, Aug 16 '18 at 03:42

Luke Luo · Accepted Answer · 2018-08-16T06:40:03.353

0

use INSERT IGNORE INTO instead of ON DUPLICATE KEY UPDATE

edited Aug 16 '18 at 06:40

answered Aug 16 '18 at 03:33

Luke Luo

14
3

MySql and Post Method

1 Answers1