PHP MySQLi REPLACE - Replacing Data in the Database

Replacing Data with the REPLACE Statement

The REPLACE statement is MySQL-specific and works similarly to INSERT, except that if a record with the given primary key (PRIMARY KEY) already exists, it deletes the old record first and then inserts the new one. If the record does not exist, it simply adds it.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "enterPassword";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

$table = "CREATE TABLE mysqli_table (
    id_table INT(100) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    fruit VARCHAR(255) NOT NULL,
    vegetable VARCHAR(150) NOT NULL,
    date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";

if (mysqli_query($connection, $table)) {
    echo "Table 'mysqli_table' has been created successfully.";
} else {
    echo "Error: " . mysqli_error($connection);
}

mysqli_close($connection);

RESULT

The result will be displayed here...