How to display data from database in web page

  viewdb.php

<!DOCTYPE html>

<html>

<head>

<title>Table with database</title>

<style>

table {

border-collapse: collapse;

width: 75%;

color: #588c7e;

font-family: monospace;

font-size: 25px;

text-align: left;

}

th {

background-color: #588c7e;

color: white;

}

tr:nth-child(even) {background-color: #f2f2f2}

</style>

</head>

<body>

<table>

<tr>

<th>Id</th>

<th>Firstname</th>

<th>Lastname</th>

<th>email</th>

</tr>

<?php

$conn = mysqli_connect("localhost", "root", "", "testdb");

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id, first_name, last_name,email FROM emp";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "<tr><td>" . $row["id"]. "</td><td>" . $row["first_name"] . "</td><td>"

. $row["last_name"] .  "</td><td>"

. $row["email"] .  "</td></tr>";

}

echo "</table>";

} else { echo "0 results"; }

$conn->close();

?>

</table>

</body>

</html>


viewdb1.php

<!DOCTYPE html>

<html>

<head>

<title>Table with database</title>

<style>

table {

border-collapse: collapse;

width: 75%;

color: #588c7e;

font-family: monospace;

font-size: 25px;

text-align: left;

}

th {

background-color: #588c7e;

color: white;

}

tr:nth-child(even) {background-color: #f2f2f2}

</style>

</head>

<body>

<table>

<tr>

<th>Id</th>

<th>Firstname</th>

<th>Lastname</th>

<th>email</th>

</tr>

<?php

$conn = mysqli_connect("localhost", "root", "", "testdb");

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id, first_name, last_name,email FROM emp";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "<tr><td>" . $row["id"]. "</td><td>" . $row["first_name"] . "</td><td>"

. $row["last_name"] .  "</td><td>"

. $row["email"] .  "</td></tr>";

}

echo "</table>";

} else { echo "0 results"; }

$conn->close();

?>

</table>

</body>

</html>












Comments

Post a Comment

Popular posts from this blog

How to create Animated 3d chart with R.

  The rgl package is the best option to build 3d charts in R. Please see this post for an introduction to 3d scatterplots using it. It also provides the plot3d() and play3d() functions that allow to animate the 3d chart, and eventually to export the result at a .gif format. Here is an application to the famous iris dataset, with a nice animated 3d scatterplot chart. Arguments x, y, z vectors of points to be plotted. Any reasonable way of defining the coordinates is acceptable. See the function  xyz.coords  for details. xlab, ylab, zlab labels for the coordinates. type For the default method, a single character indicating the type of item to plot. Supported types are: 'p' for points, 's' for spheres, 'l' for lines, 'h' for line segments from z = 0, and 'n' for nothing. For the mesh3d method, one of 'shade', 'wire', or 'dots'. Partial matching is used. col the color to be used for plotted...
Read more

Linux/Unix Commands frequently used

  Linux/Unix Commands ls  --- lists your files ls -l  --- lists your files in 'long format', which contains lots of useful information, e.g. the exact size of the file, who owns the file and who has the right to look at it, and when it was last modified. ls -a  --- lists all files, including the ones whose filenames begin in a dot, which you do not always want to see. There are many more options, for example to list files by size, by date, recursively etc. more  filename  --- shows the first part of a file, just as much as will fit on one screen. Just hit the space bar to see more or  q  to quit. You can use  / pattern  to search for a pattern. gzip  filename  --- compresses files, so that they take up much less space. Usually text files compress to about half their original size, but it depends very much on the size of the file and the nature of the co...
Read more

R Programming Introduction

R Download Link- https://cran.r-project.org/bin/windows/base/old/3.4.0/ R Studio Download link- https://www.rstudio.com/products/rstudio/download/  R is a programming language and software environment for statistical analysis, graphics representation and reporting. R was created by Ross Ihaka and Robert Gentleman at the University of Auckland, New Zealand, and is currently developed by the R Development Core Team. The core of R is an interpreted computer language which allows branching and looping as well as modular programming using functions. R allows integration with the procedures written in the C, C++, .Net, Python or FORTRAN languages for efficiency. R is freely available under the GNU General Public License, and pre-compiled binary versions are provided for various operating systems like Linux, Windows and Mac. R is free software distributed under a GNU-style copy left, and an official part of the GNU project called  GNU S . Evolution of R R was initially writ...
Read more