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

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

Assignment 1 Question 2 (Server Side Scripting Part using PHP).

<?php /* @autor Rajendra Kumar Yadav @Check the Substring position @Check First and last occurance Position @ Replace Small Substring with some new substring. */ $n=$_POST['str1']; $n1=$_POST['str2']; $n2=$_POST['str3']; $ch=$_POST['ch']; function POSITION($n,$n1) { $c=strpos($n,$n1); $c1=strrpos($n,$n1); echo "The Substring 2 Occurs at position ".$c." and ".$c1; } function OCCUR_SUBSTR($n,$n1) { $c2=substr_count($n,$n1); echo "The Substring ".$n1 ." occured ".$c2." times."; } if($ch=="first_last_pos") { POSITION($n,$n1); } if($ch=="occ_substring") { OCCUR_SUBSTR($n,$n1); } function REPLACER($n,$n1,$n2) { $c3=strlen($n1); $c4=substr_replace($n,$n2,$c,$c3); echo "First String is ".$n; echo "Second String is ".$n1; echo "New String is ".$n2; } if($ch==...
Read more

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