Creating a MySQL Table with PHP

Once the database is created, we need to create tables inside it to store data. The CREATE TABLE statement is used to define the table structure (column names, data types). In the example below, we will create a table named mysqli_tabela with four columns: ID, fruit, vegetable, and a timestamp.

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...

Did you create your first table? Congratulations! In the simulator below, you can see the success confirmation, but you can verify this on your local computer (XAMPP) in the following way:

Open phpMyAdmin in your browser (usually at localhost/phpmyadmin).
Select your database on the left side, which you created in the previous step.
Check if the new table sadovnjak has appeared in the list with the columns you defined.