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

PHP function and Keywords used to print on Webpage.

echo or echo() :- It is a function which print the output on the screen and allow to print multi-value or Strings at a time. <?php  $str="Welcome to Learn Computer Tricks and Tips Blog by Rajendra Kumar Yadav."; /* String deceleration */ echo "$str<br>"; echo($str); echo "<br>Welcome to Blog for learning" . $str; ?> ------------------------------------------------------------------------------------------------------------- output of the above program code: Welcome to Learning Computer Tricks and Tips Blog by Rajendra Kumar Yadav. Welcome to Learning Computer Tricks and Tips Blog by Rajendra Kumar Yadav. Welcome to Blog of learning  Welcome to Learning Computer Tricks and Tips Blog by Rajendra Kumar Yadav. print or print() :- It allow to print a message at a time only a single message on the screen. e.g.--- <?php  $str="Welcome to Learn Computer Tricks and Tips Blog by Rajendra K
Read more

Assignment 1 Question 3 (Server side and Client Side Scripting)

Image
<?php /** * @author   :        Rajendra Kumar Yadav * @filename :     a1q3.php * @date     :         23:53:58 Sat 27- Jun - 2015 IST * College Work: Assignment 1 Question 3 * College :           ATSS College PHP Practical */  ?>  <html Copyright (c) 2015 Copyright Rajendra Kumar Yadav All Rights Reserved. lang="en">  <head> <title> Assignment 1 Question 3 </title> </head>  <h3 class='test'> Assignment 1 Question 3 </h3>  <hr align=center color=red size=2px>  <body align=center bgcolor= antiquewhite>    <style media="screen">    .test {       font-weight: normal;       font-family: "Times new Roman";       align-items: center;       font-language-override: normal;       color: inherit;    }    </style>    <pre class="test">      <form method="post" action="<?php $_PHP_SELF ?>">        <label for="
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 install
Read more