PHP MySQL Select Data Using In Page â The following example selects the id, firstname and lastname columns from the MyGuests table and displays it on the page:
Select Data From a MySQL Database
The SELECT statement is used to select data from one or more tables:
SELECT column_name(s) FROM table_name
or we can use the * character to select ALL columns from a table:
SELECT * FROM table_name
Example (MySQLi Object-oriented)
<?php
$servername = âlocalhostâ;
$username = âusernameâ;
$password = âpasswordâ;
$dbname = âmyDBâ;// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(âConnection failed: â . $conn->connect_error);
}$sql = âSELECT id, firstname, lastname FROM MyGuestsâ;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
 while($row = $result->fetch_assoc()) {
echo âid: â . $row[âidâ]. â â Name: â . $row[âfirstnameâ]. â â . $row[âlastnameâ]. â<br>â;
}
} else {
echo â0 resultsâ;
}
$conn->close();
?>
Code lines to explain from the example above:
First, we set up an SQL query that selects the id, firstname and lastname columns from the MyGuests table. The next line of code runs the query and puts the resulting data into a variable called $result.
The post PHP MySQL Select Data Using In Page appeared first on PHPFOREVER.