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.