How to fetch data from database in php oop
Retrieve data using OOP in PHP | How to fetch data from database using oops in php
In this post, we will be learning, how to fetch or retrieve data from database in php using oop (object oriented programming in php) where we will use MySQLi Object Oriented & MySQLi Procedural code to get data.
We are continuing our student data example using oop in php
Step 1: Create a student-view.php file and paste the below code:
In this file, we are designing the html table to display data in it.
Include the StudentController.php file where we written code to fetch data.
Include dbconn.php for database connection.
<?php
include('dbconn.php');
include_once('StudentController.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>PHP OOPS - Fetch Data from database in php mysql using oops</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container mt-4">
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header">
<h4>Student View</h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Full Name</th>
<th>Email</th>
<th>Phone</th>
<th>Course</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
$students = new StudentController;
$result = $students->index();
if($result)
{
foreach($result as $row)
{
?>
<tr>
<td><?= $row['id'] ?></td>
<td><?= $row['fullname'] ?></td>
<td><?= $row['email'] ?></td>
<td><?= $row['phone'] ?></td>
<td><?= $row['course'] ?></td>
<td>
<a href="student-edit.php?id=<?=$row['id'];?>" class="btn btn-success">Edit</a>
</td>
<td>
<form action="codes/student-code.php" method="POST">
<button type="submit" name="deleteStudent" value="<?= $row['id'] ?>" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<?php
}
}
else
{
echo "No Record Found";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Step 2: Create a StudentController.php file and paste the below code:
Example with MySQLi Object Oriented:
<?php
class StudentController
{
public function __construct()
{
$db = new DatabaseConnection;
$this->conn = $db->conn;
}
public function index()
{
$studentQuery = "SELECT * FROM students";
$result = $this->conn->query($studentQuery);
if($result->num_rows > 0){
return $result;
}else{
return false;
}
}
}
?>
Example with MySQLi Procedural:
<?php
class StudentController
{
public function __construct()
{
$db = new DatabaseConnection;
$this->conn = $db->conn;
}
public function index()
{
$studentQuery = "SELECT * FROM students";
$result = mysqli_query($this->conn, $studentQuery);
if($result->num_rows > 0){
return $result;
}else{
return false;
}
}
}
?>
Thanks for reading.