PHP/MySQL: Insert record if doesnt exist

Question

$sql = "INSERT INTO toplist 
       (serverName, serverPassword, serverIp, serverPort, serverBanner,
        serverShortDescription, serverDescription)
       VALUES
       ('$_POST[serverName]', '$_POST[serverPassword]', '$_POST[serverIp]',
        '$_POST[serverPort]', '$_POST[serverBanner]', 
        '$_POST[serverShortDescription]', '$_POST[serverDescription]')";

if (!mysql_query($sql, $con)) {
    die('Error: ' . mysql_error());
}

echo "The server " . $_POST[serverName] . "," . $_POST[serverIp] 
    . " has been added.";

mysql_close($con);

How can I make it so that if the entry "serverIp" does not already exist, it will add it to the database, if it does already exist, then it doesn't do anything. Also, will this be case sensitive too? Will you be able to bypass it bY tYpInG LiKe tHiS?

[SQL injection attacks](http://xkcd.com/327/) are a larger concern than case sensitivity. — OMG Ponies, Feb 21 '12 at 04:26

score 7 · Accepted Answer · edited May 23 '17 at 12:24

7

INSERT IGNORE ... will not insert if you have a unique constraint on your column. I would lower case the string before inserting it if you want it to be case insensitive.

http://dev.mysql.com/doc/refman/5.5/en/insert.html

This may also be helpful.

edited May 23 '17 at 12:24

Community

1
1

answered Feb 21 '12 at 04:05

Joshua Martell

7,035
2
28
37

1

+1 If he's using MyISAM (which is _very_ common and the most probable), then constraints won't apply in this situation. – Yes Barry Feb 21 '12 at 04:08
I'm having trouble implementing this. – Hunt3r Feb 21 '12 at 04:38

PHP/MySQL: Insert record if doesnt exist

1 Answers1