Displaying Database data using Class, Object, Constructor, Destructor in PHP MySql

 <?php

class Employee
{
    private $conn;
    public function __construct()
    {
        $this->conn = new mysqli("localhost", "root", "", "database_ci");
        if ($this->conn->connect_error) {
            die("Connection Failed : " . $this->conn->connect_error);
        }
    }
    public function __destruct()
    {
        $this->conn->close();
    }
    public function getAllEmployees()
    {
        $data = [];
        $sql = "SELECT * FROM register";
        $result = $this->conn->query($sql);
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $data[] = $row;
            }
            return $data;
        } else {
            return $data;
        }
    }
    public function getMaxSalaryEmployee()
    {
        $data = [];
        $sql = "SELECT * FROM register ORDER BY salary DESC LIMIT 1";
        $result = $this->conn->query($sql);
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            return $row;
        } else {
            return $data;
        }
    }
    public function getMinSalaryEmployee()
    {
        $data = [];
        $sql = "SELECT * FROM register ORDER BY salary ASC LIMIT 1";
        $result = $this->conn->query($sql);
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            return $row;
        } else {
            return $data;
        }
    }
}






<?php
include("Constructor_Destructor.php");
$obj = new Employee();
$empList = $obj->getAllEmployees();
// echo "<pre>";
// print_r($empList);
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <title>List of Employees</title>
</head>

<body>
    <h1>List of Employees</h1>
    <?php
    if (count($empList) > 0) {
    ?>
        <table border="2px">
            <tr>
                <th>id</th>
                <th>name</th>
                <th>email</th>
                <th>phone</th>
                <th>language</th>
                <th>gender</th>
                <th>qualification</th>
                <th>image</th>
                <th>added_on</th>
                <th>updated_on</th>
                <th>status</th>
            </tr>
            <?php
            foreach ($empList as $emp) {
            ?>
                <tr>
                    <td><?php echo $emp["id"]; ?></td>
                    <td><?php echo $emp["name"]; ?></td>
                    <td><?php echo $emp["email"]; ?></td>
                    <td><?php echo $emp["phone"]; ?></td>
                    <td><?php echo $emp["language"]; ?></td>
                    <td><?php echo $emp["gender"]; ?></td>
                    <td><?php echo $emp["qualification"]; ?></td>
                    <td><?php echo $emp["image"]; ?></td>
                    <td><?php echo $emp["added_on"]; ?></td>
                    <td><?php echo $emp["updated_on"]; ?></td>
                    <td><?php echo $emp["status"]; ?></td>
                </tr>
            <?php
            }
            ?>
        </table>
    <?php } ?>
</body>

</html>






<?php
include("Constructor_Destructor.php");
$obj = new Employee();

$empList = $obj->getAllEmployees();
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <title>List of Employees</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
</head>

<body>
    <div class="container">
        <div class="row">
            <?php
            if (count($empList) > 0) {
                foreach ($empList as $x) {
            ?>
                    <div class="col-md-3 bg-success" style="margin: 10px;">
                        <p><b>ID</b>: <?php echo $x["id"]; ?></p>
                        <p><b>NAME</b>: <?php echo $x["name"]; ?></p>
                        <p><b>EMAIL</b>: <?php echo $x["email"]; ?></p>
                        <p><b>PHONE</b>: <?php echo $x["phone"]; ?></p>
                        <p><b>LANGUAGE</b>: <?php echo $x["language"]; ?></p>
                        <p><b>GENDER</b>: <?php echo $x["gender"]; ?></p>
                        <p><b>QUALIFICATION</b>: <?php echo $x["qualification"]; ?></p>
                        <p><b>IMAGE</b>: <?php echo $x["image"]; ?></p>
                        <p><b>ADDED ON</b>: <?php echo $x["added_on"]; ?></p>
                        <p><b>UPDATED ON</b>: <?php echo $x["updated_on"]; ?></p>
                        <p><b>STATUS</b>: <?php echo $x["status"]; ?></p>
                    </div>
            <?php
                }
            }
            ?>
        </div>
    </div>
</body>

</html>











Comments

Post a Comment

Popular posts from this blog

GROUP BY Clause and HAVING Clause in PHP

GROUP BY :  The GROUP BY clause is used in conjunction with the SELECT Statement and Aggregate functions to group rows together by common column values. SELECT with GROUP BY Syntax : SELECT columns FROM table_name WHERE condition GROUP BY column_name(s); (Here above "condition" is Optional in above query). In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. SELECT with GROUP BY with Two Tables Syntax : SELECT columns FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name WHERE condition GROUP B...
Read more

Method Overriding in Traits in PHP

Image
  <?php class Base {     public function abc ()     {         echo "ABC method from Base class." ;     } } //The trait method(Here, abc() Method) will get priority compared to Parent class Method(Here, abc() Method) trait Test {     public function abc ()     {         echo "ABC method from test trait." ;     } } class Child extends Base {     use Test ;     public function abc ()     {         echo "ABC method from Child class." ;     } } $obj = new Child (); $obj -> abc ();
Read more

Mysqli database Connection and Display Table Data from Database

  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $dbname = "heer" ; $conn = new mysqli ( $servername , $username , $password , $dbname ); if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); } $sql = " SELECT * FROM student " ; $result = $conn -> query ( $sql ); if ( $result -> num_rows > 0 ) {     while ( $row = $result -> fetch_assoc ())     {         echo "<pre>" ;         echo "Id: { $row ["id"]} - Name: { $row ["name"]} - Age: { $row ["age"]} - Phone No: { $row ["phone"]} - City: { $row ["city"]}" ;         echo "</pre>" ;     } } else {     echo "No result fount" ; } $conn -> close (); //  OUTPUT: //Id: 0 - Name: Raj - Age: 25 - Phone No: 9854233621 - City: Ahmedabad // Id: 1 - Name: Amit - Age: 22 - Phone No: 8533...
Read more