Choose Information From a MySQL Database
The SELECT statement is used to get data from one or more tables:
SELECT column_name(s) FROM table_name
Or, we can use the * character to select ALL of a table’s columns:
SELECT * FROM table_name
Visit our SQL tutorial to learn more about SQL.
Select Data With MySQLi
The following example chooses the id, firstname, and lastname columns from the student table and puts them on the page:
Example
<!DOCTYPE html>
<html>
<body><?php
$servername = “localhost”;
$username = “username”;
$password = “password”;
$dbname = “school”;// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(“Connection failed: ” . mysqli_connect_error());
}$sql = “SELECT id, firstname, lastname FROM student”;
$result = mysqli_query($link, $sql);if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo “id: ” . $row[“id”]. ” – Name: ” . $row[“firstname”]. ” ” . $row[“lastname”]. “<br>”;
}
} else {
echo “0 results”;
}mysqli_close($link);
?></body>
</html>
Output
id: 1 – Name: ram lal
id: 2 – Name: shyam lal
id: 3 – Name: ajay lal