MySQLi Database Select example (simple)

<?php // db1.php

$db_database = 'test';
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';

$conn = mysqli_connect($db_host, $db_user, $db_password, $db_database);
$rows = mysqli_query($conn,'SELECT * FROM students');

echo "Name, address, email, mobile<br/>";

while( $row = mysqli_fetch_array($rows, MYSQLI_ASSOC) ) {
    echo "{$row['name']}, {$row['address']}, {$row['email']}, {$row['mobile']}";
    echo '<br/>';
}

?>