1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / sathmcmy / public_html / classes /
Filename : Category.php
back
<?php 

$filepath= realpath(dirname(__FILE__));
include_once "$filepath/../lib/Database.php";
include_once "$filepath/../helpers/Format.php";

/* 
    Category Class
*/

class Category {

    private $db;
    private $fm;

    public function __construct()
    {
        $this->db= new Database();
        $this->fm= new Format();
    }

    public function catInsert($catName)
    {

        $catName= $this->fm->validation($catName);

        $catName= mysqli_real_escape_string($this->db->link, $catName);

        if(empty($catName)) {
            $loginmsg= "<span style='text-align: center; color: red; border: 1px solid red; padding: .5rem 3rem;'>Field must not be empty!</span>";
            return $loginmsg;
        } else {

            $query= "INSERT INTO tbl_category (catName) VALUES ('$catName')";

            $catinsert= $this->db->insert($query);

            if($catinsert) {
                $msg= "<span style='color: green; text-align: center; border: 1px solid green; padding: .5rem 2rem;'>Category inserted Successfully</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; text-align: center; border: 1px solid red; padding: .5rem 2rem;'>Category not inserted</span>";
            }

        }

    }


    public function getAllCat()
    {

        $query= "SELECT * FROM tbl_category ORDER BY catId DESC";

        $result= $this->db->select($query);

        return $result;

    }

    public function getCatById($id) 
    {

        $id= $this->fm->validation($id);

        $id= mysqli_real_escape_string($this->db->link, $id);

        $query= "SELECT * FROM tbl_category WHERE CatId= $id";

        $result= $this->db->select($query);

        return $result;

    }

    public function catUpdate($catName, $id)
    {

        $catName= $this->fm->validation($catName);
        $id= $this->fm->validation($id);

        $catName= mysqli_real_escape_string($this->db->link, $catName);
        $id= mysqli_real_escape_string($this->db->link, $id);

        if(empty($catName) || empty($id)) {

            $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Category field must not be empty!</span>";
            return $msg;

        } else {

            $query= "UPDATE tbl_category SET catName='$catName' WHERE catId=$id";
    
            $update_row= $this->db->update($query);
    
            if($update_row) {
                $msg= "<span style='color:green; padding: .5rem 2rem; border: 1px solid green;'>Category Updated Successfully</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Category Not Updated</span>";
                return $msg;
            }

        }

    }

    public function delCatById($id)
    {

        $id= $this->fm->validation($id);
        $id= mysqli_real_escape_string($this->db->link, $id);

        $query="DELETE FROM tbl_category WHERE catId=$id";

        $deldata= $this->db->delete($query);

        if($deldata) {
            $msg= "<span style='color:green; padding: .5rem 2rem; border: 1px solid green;'>Category Deleted Successfully</span>";
            return $msg;
        } else {
            $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Category Not Deleted</span>";
            return $msg;
        }

    }

    // public function checkCatAvailability($catName, $id)
    // {

    //     // $catName= $this->fm->validation($catName);
    //     $id= $this->fm->validation($id);

    //     // $catName= mysqli_real_escape_string($this->db->link, $catName);
    //     $id= mysqli_real_escape_string($this->db->link, $id);

    //     $query= "SELECT tc.catName FROM tbl_category tc JOIN tbl_product tp ON tc.catId=tp.catId";

    //     $res= $this->db->select($query);

    //     while($result= $res->fetch_assoc()) {

    //         if($result['catName'] == $catName) {
    //             return true;
    //         }

    //     }

    // }

    public function checkCatAvailability($ctName, $catId) {

        $catId  = htmlspecialchars($catId);
        $catId  = mysqli_real_escape_string($this->db->link, $catId);

        $ctName = htmlspecialchars($ctName);
        $ctName = mysqli_real_escape_string($this->db->link, $ctName);

        $sql= "SELECT * FROM tbl_product tp JOIN tbl_category tc ON tc.catId=$catId AND tc.catName='$ctName'";
        // echo $sql;exit;
        // $res= $this->db->select($sql);
        $res= $this->db->link->query($sql);

        if($res->num_rows  > 0) {
            return true;
        }

        return false;

        // print_r(gettype($res->num_rows)); exit;
    }

    public function getAllCatLimit()
    {

        $query= "SELECT * FROM tbl_category ORDER BY catId DESC LIMIT 3";

        $result= $this->db->select($query);

        return $result;

    }

}

?>