Show Record From database using PHP and MYSQL using Table Format:-
We will use the select queries to select a record from the database.
select * from tablename;
PHP provides three different functions to display a record from the database.
1) mysqli_fetch_array():- It is used to show record using associative array and index array pattern.
while($var = mysqli_fetch_array($result)
{
echo $var['columnname']; // we can write column name also to display data
echo $var[index] // we can write index also where first column index start from 0
}
We always use the while loop to display a record from the database and the while loop will be true until condition false.
Example with complete PHP Code-
<?php
$conn = mysqli_connect('localhost',"root","","php12batch");
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_array($res))
{
echo $x[0]. " ".$x[1]." ".$x[2]." ".$x[3]. " ".$x[4];
}
?>
Example with complete PHP Code-
<?php
$conn = mysqli_connect('localhost',"root","","php12batch");
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_array($res))
{
echo $x['rno']. " ".$x['name']." ".$x['branch']." ".$x['fees']. " ".$x['mobile'];
}
?>
2) mysqli_fetch_row():- It is used to show record using index array
It is used to display a single row using an index array pattern.
We can display data without using Loop.
$var = mysqli_fetch_row($result);
echo $var[0]; //0 is the index
Example with complete PHP Code-
<?php
$conn = mysqli_connect('localhost',"root","","php12batch");
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_row($res))
{
echo $x[0]. " ".$x[1]." ".$x[2]." ".$x[3]. " ".$x[4];
}
?>
3) mysqli_fetch_assoc():- It is used to display data using an associative array.
while($var = mysqli_fetch_assoc($result)
{
echo $var['columnname']; // we can write column name also to display data
echo $var[index] // we can write index also where first column index start from 0
}
Example with complete PHP Code-
<?php
$conn = mysqli_connect('localhost',"root","","php12batch");
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_assoc($res))
{
echo $x['rno']. " ".$x['name']." ".$x['branch']." ".$x['fees']. " ".$x['mobile'];
}
?>
4) mysqli_fetch_object():- It is used to display data using object pattern;
while($var = mysqli_fetch_object($result)
{
echo $var->columnname; // we can write column name also to display data
}
Example with complete PHP Code-
<?php
$conn = mysqli_connect('localhost',"root","","php12batch");
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_object($res))
{
echo $x->rno. " ".$x->name." ".$x->branch." ".$x->fees. " ".$x->mobile;
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">
table
{
width:600px;
}
table th
{
background-color:yellow;
color:blue;
font-size: 25px;
}
table td
{
background-color:orange;
color:black;
font-size: 20px;
text-align: center;
}
</style>
</head>
<body>
<h1>View Student Record</h1>
<hr>
<table border="1">
<tr><th>Rno</th><th>Sname</th><th>Branch</th><th>Fees</th></tr>
<?php
$conn= mysqli_connect('localhost','root','','php12batch');
$res = mysqli_query($conn,"select * from student");
while($x = mysqli_fetch_array($res))
{
echo "<tr><td>".$x[0],'</td><td>' ,$x[1],'</td><td>',$x[2],'</td><td> ',$x[3],"</td></tr>";
}
?>
</table>
</body>
</html>
Post a Comment
If you have any doubt in programming or join online classes then you can contact us by comment .