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