codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Stop duplicate entry into database

    11th March 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
     
    <?php
    $newtag = mysql_real_escape_string($_POST['newtag']);
    $query = "SELECT tagname FROM tags WHERE tagname = '$newtag'";
    $result = mysql_query($query);
    if ( mysql_num_rows ( $result ) > 0 )
    {
        /* Username already exists */
        echo 'Tag already exists';
    }
    else
    {
    /* insert it */
      $query = "INSERT INTO tags (tagname) VALUES ('$newtag')";  
    mysql_query($query) or die(mysql_error());
    }
    ?>
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN