Category: PHP Advanced

How To Select Data From Table Using MySQL & PHP?

Step 1: Connect to MySQL Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
<?php
$DatabaseServer = "localhost";
$DatabaseUsername = "root";
$DatabasePassword = "root";
$DatabaseName = "demo";
$Connection = mysqli_connect($DatabaseServer , $DatabaseUsername ,    $DatabasePassword ,   $DatabaseName);
 
if ($Connection  === false)
{
die("ERROR: Could not connect. " . mysqli_connect_error());
}
 
?>
 

Step 2: Fetch Data From MySQL Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
<?php
$SQL = "SELECT * FROM user";
$Result = mysqli_query($Connection, $SQL);
 
while ($Row = mysqli_fetch_assoc($Result)    
{
  echo $FirstName = $Row['FirstName '];
echo $Email = $Row['Email'];
  
}
 
?>
 

Mysql: Run these queries to

Continue reading