Display MySQL data using PHP in Browser


Code for fetching data from MySQL database using PHP API in Browser :-

 ############################################################################

<!DOCTYPE html>
<html>
<head>
<title> PHP-MySQL Tutorials </title>
<!--
Here I'm using CSS Framework Bootstrap for Screen design.  Below Code from

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">

is for CDN link to get content from internet.
-->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<!-- Customized css -->
<style type="text/css">
body {
margin: 20px;
background: #e9d5f1;
}
.main-content {
background: #e4cede63;
border: 1px solid gray;
}
table td {
text-align: justify-all;
border-color: #007bff;
}
</style>
</head>
<!-- Header end Here -->

<!-- Body Start from here -->
<body>
<!-- Header Start Here -->
<div class="jumbotron" style="background: #e8ccef;">

<h3 class="text-center text-danger"> PHP - MySQL Tutorials </h3>
<p class="text-right text-primary reduce-border"> - By Rajendra Kumar Yadav </p>

</div>
<!-- Header End here -->
<div></div>

<!-- Container Area -->
<div class="jumbotron container main-content">
<!-- Content -->

<div class="col-sm-8">

<table class="table table-striped table-bordered">
<tr style="background: #e0ccef;;">
<th> # </th>
<th> Name </th>
<th> Period of Service (Month) </th>
</tr>

<!-- PHP Code begin here -->
<?php

$hostname = "localhost"; $username = "root"; $password = ""; $dbname = "employee";

$con = mysqli_connect($hostname, $username, $password, $dbname) or die("Error, in connection string!");

if($con) {

$query = "SELECT * from record";
$result = mysqli_query($con, $query) or die("Error, During query execution!");

while ($row = mysqli_fetch_assoc($result)) {


echo "<tr>";
echo "<td> $row[srno]  </td>";
echo "<td> $row[name] </td>";
echo "<td> $row[month_since_working] </td>";
echo "</tr>";


}

}

?>

</table>


</div>

</div> <!-- container end here -->
</body>  <!-- Body End here -->
</html>

############################################################################

Click Here to View video in YouTube

Comments

Post a Comment

Popular posts from this blog

Check Apache2 Syntax

Image
Check Apache2 Configuration Syntax I will use Ubuntu 14.04.5 Desktop Version for this tutorials. You can check by typing command $ cat /etc/*-release Checking Linux Release information (It works in any flavour of Linux)  I already has recorded an video for Installation can see following Link But I will guide to install as here # apt install apache2 Press Y and enter for installation If all is good then you will see like this. Installation done successfully After successful installation, you can verify by typing sudo service apache2 status / or Open Browser and type http://localhost Test Window Now Open Terminal run apachectl -t , You can either type apache2ctl -t Default configuration having an warning Now open /etc/apache2/apache.conf file in any editor, I Prefer to open it in nano # nano /etc/apache2/apache.conf Add a line anywhere in page ServerName localhost Same time, I make an error Press CTRL+W    type Timeo...
Read more

Install the packages in Linux

Install the PHP/Java/Apache in Linux (For the student of BSc. (Computer Science). You can use the tricks for the Fedora Based System/Debian Based System ( Fedora Based System (.rpm) - Redhat, CentOS,Fedora etc/ Debian Based System(.deb)  - Ubuntu ,mint,debian etc). For Fedora Based System:- yum install package-name e.g. yum install php-cli* (for the php-cli package in CentOS/Redhat etc). yum is used to install the online package from the respected OS repo location. If you have offline package as .rpm so follow this instruction.. rpm -q packagename (it is use to query whether package is installed or not) e.g. rpm -q php-cli (To query that PHP interpreter is installed or not for install a rpm package rpm -ivh package-name.rpm e.g. rpm -ivh php-cli_xxx_xxx.rpm  (to install the jdk in centos/redhat). xxx_xxx version and build name that means you have to enter the correct name of package and install. For Debian Based System:- sudo apt-get...
Read more