In this Php Tutorial we will Learn How To Connect PHP With MySQL Database And Show Database Table Data using MySQLI .
I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .
- MySQL Database .
*INFO : Learn Php And Buid Cms Project Course
Php Source Code:
<?php
// create a connection between php and mysql database
$hostname = "localhost";
$username = "root";
$password = "";
// your database name
$databaseName = "test_db";
// create The connection
$connect = mysqli_connect($hostname, $username, $password);
mysqli_select_db($connect, $databaseName);
// the mysql query
$query = "SELECT * FROM `users`";
$result = mysqli_query($connect, $query);
// using while loop to dispaly data from database
while($row = mysqli_fetch_array($result))
{
echo "$row[0] - $row[1] - $row[2] - $row[3]<br>";
}
// free your result
mysqli_free_result($result);
// close the connection
mysqli_close($connect);
// create a connection between php and mysql database
$hostname = "localhost";
$username = "root";
$password = "";
// your database name
$databaseName = "test_db";
// create The connection
$connect = mysqli_connect($hostname, $username, $password);
mysqli_select_db($connect, $databaseName);
// the mysql query
$query = "SELECT * FROM `users`";
$result = mysqli_query($connect, $query);
// using while loop to dispaly data from database
while($row = mysqli_fetch_array($result))
{
echo "$row[0] - $row[1] - $row[2] - $row[3]<br>";
}
// free your result
mysqli_free_result($result);
// close the connection
mysqli_close($connect);
///////////////OUTPUT:
 |
| Data From Database |
