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

Download and Install JDK and Check the Configuration.

Image
Good Afternoon Friends,            Today I write the blog that how to configure Java Development Kit in Windows XP/7/8/8.1/10.      So First JDK must be download the package from the link. Make sure that you downloading the appropriate JDK compatible for your operating System. You can check the OS type 1.       Open cmd and type systeminfo if Operating System Type If System Type: x64 Based PC The Download JDK for 64 bit Or if it is x86 so download for 32 bit. On Oracle Website Click and Download the JDK as Per Your OS. To Download The JDK . ( Click here. ) As per above image accept License Agreement. After Download the Package install the exe by clicking on the file. ·          To Check the configuration o    Open cmd and type >   java –version Configuration Checking ...
Read more

String Operations in PHP

Image
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Strings</title> <style> h3{ font-size: 25px; color: lime; font-size-adjust: true; text-align: center; text-shadow: 2px; } *{ color: skyblue; font-size: 15px; font-family: "Console"; } </style> </head> <body bgcolor="gray"> <h3>String functions</h3> <hr width="1024px"></hr> <center> <pre> <?php $str1="Welcome to tutorital of PHP"; $str2="Thanks for Visiting this Page!!"; //String function and their output.. echo "<h4><u> Original String is (i): {$str1} & (ii) is {$str2}.</u></h4...
Read more