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

    Mysqli if record exists then update

    31st May 2018

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
     
    $result = $mysqli->query("SELECT * FROM users WHERE clientnumber = '".$clientnumber."'");
    if($result->num_rows > 0 ){
     
    echo $sql = "UPDATE users SET username='$username', company='$company' WHERE clientnumber='$clientnumber'";
     
            if (mysqli_query($mysqli, $sql)) {
                echo "Record updated successfully";
            } else {
                echo "Error updating record: " . mysqli_error($mysqli);
            }
     
            mysqli_close($mysqli);
    }
      else {
      
        $sql = "INSERT INTO users (username, company)
            VALUES ('$username', '$company')";
     
            if ($mysqli->query($sql) === TRUE) {
                echo "<br>New client created successfully";
            } else {
                echo "Error: " . $sql . "<br>" . $mysqli->error;
            }
              
    }
     

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

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

    © 2022 CODEHAVEN