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 are a larger concern than case sensitivity. — OMG Ponies
– OMG Ponies, Commented Feb 21, 2012 at 4:26

Community · Accepted Answer · 2017-05-23 12:24:58Z

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, 2017 at 12:24

CommunityBot

11 silver badge

answered Feb 21, 2012 at 4:05

Joshua Martell

7,2122 gold badges33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yes Barry Over a year ago

+1 If he's using MyISAM (which is very common and the most probable), then constraints won't apply in this situation.

Hunt3r Over a year ago

I'm having trouble implementing this.

Collectives™ on Stack Overflow

PHP/MySQL: Insert record if doesnt exist

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related