Example how to insert, update and delete records in MySQLi with PHP

<?php
    // create connection
    $server = "server IP address";
    $uname = "username";
    $passw = "password";
    $conn = mysqli_connect($server, $uname, $passw); 
    if (!$conn) die ("Connection failed:" . mysqli_connect_error()); // error if not connected

    // insert data
    $sql = "INSERT INTO table_name (firstname, lastname) VALUES ('Albert', 'Eintstein')";
    if (mySQLi_query($conn, $sql)) {
        echo "Record inserted successfully...";
    }
    else {
        echo "Problems inserting!";
    }
    
    // update data
    $sql = "UPDATE table_name SET lastname='Frankenstein' WHERE id=1";
    if (mySQLi_query($conn, $sql)) {
        echo "Record updated successfully...";
    }
    else {
        echo "Problems updating!";
    }
    
     // delete data
    $sql = "DELETE FROM table_name WHERE id=1";
    if (mySQLi_query($conn, $sql)) {
        echo "Record deleted successfully...";
    }
    else {
        echo "Problems deleting!";
    }
?>