PHP MySQLi LIMIT - Limiting the Number of Results

Limiting Results with the LIMIT Clause

MySQL provides the LIMIT clause, which is used to specify the number of records to display. The LIMIT clause makes it easy to code multipage results (pagination) with SQL and is highly useful for large tables, as returning a large number of records can impact performance. For this purpose, we will create an SQL table named "Občine" (Municipalities); you can find everything about table creation in the previous tutorials.

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