PHP MySQL Archives - PHPFOREVER https://phpforever.com/tag/php-mysql/ PHP LARAVEL CODEIGNITER DATABASE JAVASCRIPT Sat, 22 Jan 2022 01:42:19 +0000 en-US hourly 1 https://wordpress.org/?v=6.7.1 https://phpforever.com/wp-content/uploads/2020/06/cropped-PHP4EVER1-1-32x32.png PHP MySQL Archives - PHPFOREVER https://phpforever.com/tag/php-mysql/ 32 32 PHP MySQL Select Data Using In Page https://phpforever.com/php/php-mysql-select-data-using-in-page/ https://phpforever.com/php/php-mysql-select-data-using-in-page/?noamp=mobile#respond Fri, 21 Jan 2022 05:31:43 +0000 https://phpforever.com/?p=2554 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 post PHP MySQL Select Data Using In Page appeared first on PHPFOREVER.

]]> 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();
?>

 

php-code-to-retrieve-data-from-mysql-database-and-display-in-html-table

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.

]]> https://phpforever.com/php/php-mysql-select-data-using-in-page/feed/ 0