PHP MySQLi INSERT - Inserting Data into the Database

Inserting Data with PHP

Once the table is created, we insert data into it using the INSERT INTO statement. We must ensure that the values match the data types specified during table creation. In the example below, we will add one fruit and one vegetable type to the mysqli_tabela table.

EXAMPLE

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

// 1. Connection
$connection = mysqli_connect($server, $username, $password, $database);

// 2. Checking
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// 3. SQL command for insertion
$sql = "INSERT INTO mysqli_table (fruit, vegetable) VALUES ('Apples', 'Carrots')";

if (mysqli_query($connection, $sql)) {
    echo "New record was added successfully.";
} else {
    echo "Error inserting data: " . mysqli_error($connection);
}

// 4. Reading and outputting data
$sql = "SELECT table_id, fruit, vegetable FROM mysqli_table";
$result = mysqli_query($connection, $sql);

// 4. Closing
mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Database Verification: The simulator below immediately shows you the inserted row in the table. On your computer, you can verify the process like this:

Insert the code into your PHP file and run it.

Open phpMyAdmin and select the mysqli_tabela table.

Click the "Browse" tab and you will see Jabolko and Korenje.