How to Show/Display data form Database using PHP and MySQLi | Part 2

In this tutorial, I will show how to show data from database, but to show data you have already some data in your database.if you don't know how to insert data please visit my previous post "how to insert data in database".

Steps to Show or Display data :

• Write following code into insert.php and it will show data from `data` table already created in database .

<?php

$sel="SELECT * FROM `data`";

$sel1=mysqli_query($con,$sel);

while($result=mysqli_fetch_array($sel1))

{?>

<table>

<tr>

<td><?php echo $result['name'] ?></td>

<td><?php echo $result['class'] ?></</td>

<td><?php echo $result['marks'] ?></</td>

<td><a href="insert.php?var=<?php echo $result['id'] ?>">Delete</a></td>

<td><a href="update.php?up=<?php echo $result['id'] ?>">edit</a></td>

</tr>

</table>

<?php

}

PHP,

Rate this posting:

{[['']]}