Re: mysqli insert into table only if not exists

[Peter Brawley]

For human readability, use BBCode code tags to retain code formatting.

> only if title field doesn't match one that already exists in the DB.

You mean in the table. If there's a Primary or Unique index on the column, INSERT IGNORE will simplify inserting only if not exists.

$_REQUEST[] includes $_COOKIE[]; does that match your requirement? Usually it's best to be specific, ie reference $_GET[] or $_POST[], whichever your form uses.

> mysqli_query($connect,$query);

Always check the return value of a mysql API func, and always trap for errors, eg ...

$res = mysqli_query($connect,$query) or exit( mysqli_error($connect) );

You've not told us where the $_REQUEST[] elements you're canvassing cam from, and you've not reported a problem or error message.