HOW TO DO READING/LISTING OPERATIONS IN PHP ?

Hello everyone,

Today we will teach how to do crud operations in php. Above all, i would like to explain all our processing step by step.

HOW TO DO READING OPERATIONS IN PHP ?

  • Firstly, we have need to data. So, we will create sample data on mockaroo.
  • Then, we will create a new database on the Mysql.
  • Then, we will connect the database we have created with our PHP file.
  • Then, with the foreach loop, we will print the data from the database into the table we created.

READ

FIRST STEP

I created a table as personal data. This table have 4 columns. This columns ; id, first_name, last_name and email.

SECOND STEP

I will create a connect.php file for the connection to mysql database.

<?php
try {
$db = new PDO("mysql:host=localhost;dbname=personal", "root", "");
} catch ( PDOException $e ){
print $e->getMessage();
}
?>

THIRD STEP

I will create a index.php file for the list our mysql data. And i will include the con.php file I created insert this page. After created index.php before we will include con.php this page.

<?php

//We include our database file
include 'connect.php';

//We connect to the database and write our query
$query = $db->prepare("select * from personal");

$query->execute();
//We pass our data to array

$takequery = $query->fetchAll(PDO::FETCH_OBJ);

?>

FOURTH STEP

Then we will create a new bootstrap page and we will add bootstrap table. Shortly after We will list the data in the database in this table

<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">

<!-- Bootstrap CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">

<title>LIST SCREEN</title>
</head>
<body>
<h1 class="display-1 text-center">USER LIST</h1>
<div class="container">
<div class="row">
<table class="table table-striped table-hover mt-3">

<tr>
<td>ID</td>
<td>NAME</td>
<td>CITY</td>
<td>E-MAIL</td>
</tr>

<?php

//We loop the data we transferred to the array in the table

foreach ($takequery as $queries) {?>

<tr>
<td><?= $queries->id ?></td>
<td><?= $queries->name?></td>
<td><?= $queries->city?></td>
<td><?= $queries->email?></td>

</tr>

<?php } ?>

</table>
</div>
</div>

 

 

<!-- Optional JavaScript; choose one of the two! -->

<!-- Option 1: Bootstrap Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>

<!-- Option 2: Separate Popper and Bootstrap JS -->
<!--
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js" integrity="sha384-7+zCNj/IqJ95wo16oMtfsKbZ9ccEh31eOz1HGyDuCQ6wgnyJNSYdrPa03rtR1zdB" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.min.js" integrity="sha384-QJHtvGhmr9XOIpI6YVutG+2QOK9T+ZnN4kzFN1RtK3zEFEIsxhlmWl5/YESvpZ13" crossorigin="anonymous"></script>
-->
</body>
</html>

That’s all! 😀

You did it!

This is screen!

Leave a Reply

Your email address will not be published.