PHP Select Data From MySQL

Select Data From MySQL Using Mysqli Procedural

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




The following example selects the id, firstname and lastname columns from the MyGuests table and displays it in Table formate

Example (MySQLi Procedural)

<?php
include("mysqli_pop_connection.php");
$sql="select id, firstname, lastname from fa_MyGuests";
$query=mysqli_query($conn,$sql);
if($query)
{
?>
<?php include('header1.php'); ?>
<?php include("mysql_sidemenu.php"); ?>
<div class="container">
<div class="row">
<div class="col-sm-12">
<div class="table-responsive">

<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>First Name</th>
<th>Last Name</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
</tr>
<?php
}
}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php include('footer.php');?>


Show Code
mysqli_pop_connection.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$db="lipsphpstudent"
// Create connection
$conn = mysqli_connect($servername, $username, $password,$db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_error());
}
?>
mysqli_pop_select_live_example.php
<?php
include("mysqli_pop_connection.php");
$sql="select id, firstname, lastname from fa_MyGuests";
$query=mysqli_query($sql);
if($query)
{
?>
<?php include('header1.php'); ?>
<?php include("mysql_sidemenu.php"); ?>
<div class="container">
<div class="row">
<div class="col-sm-12">
<div class="table-responsive">

<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>First Name</th>
<th>Last Name</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
</tr>
<?php
}
}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php include('footer.php');?>

Previous Next