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

    Show rows affected by mysqli

    28th February 2020

    MySql

    mysql codehaven category

    Nice bit of code that shows how many rows were deleted, if any!

    Note: If the data to be written is the same it will show “0 records added”

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
     
    echo $sql = "UPDATE todolist SET list = '$movetolist' WHERE item = '$itemtext' ";
    if ($mysqli->query($sql) === TRUE) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $sql->error;
    }
     
    echo "Affected rows: " . $mysqli -> affected_rows;
     

    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