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

    Mysqli Basic – ON DUPLICATE KEY UPDATE

    30th August 2016

    MySql

    mysql codehaven category

    The column called ‘ref’ will need to be unique. If it has a dupe, then it will complete the second part of the statement.

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
     
    $results = $mysqli->query("INSERT INTO client_login (fname, sname, ref)
                VALUES ('Mike', 'Belmond','T99')
    ON DUPLICATE KEY UPDATE fname='Mike', sname='Belmond',ref='T100'");
     
     
                if($results){
                    print 'Success! record updated / deleted';
                }else{
                    print 'Error : ('. $mysqli->errno .') '. $mysqli->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