PHP MySQLi SELECT - Selecting and Displaying Data from a Database

Reading and Displaying Data from a Database

The SELECT statement is used to select data from one or more tables, or we can use the * (asterisk) character to select all columns from a table. First, we set up an SQL query that selects the id, fruit, and vegetable columns from the table. The next line of code runs the query and transfers the obtained data into a variable named $rezultat. Then the num_rows() function checks whether more than zero rows are returned, and if so, the fetch_assoc() function puts all results into an associative array that we can work with. A while() loop iterates through the result set and prints the data from the id, fruit, and vegetable columns.

EXAMPLE

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

// Establishing a connection
$connection = mysqli_connect($server, $username, $password, $database);

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

// Since the data is already inserted in previous lessons, we now just read it!
$sql = "SELECT table_id, fruit, vegetable, date FROM mysqli_table";
$result = mysqli_query($connection, $sql);

// Closing the connection
mysqli_close($connection);
?>

RESULT

The result will be displayed here...