1#@!#!123s

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

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

/* 
    Product Class
*/

class Product {

    private $db;
    private $fm;

    public function __construct()
    {

        $this->db= new Database();
        $this->fm= new Format();

    }

    public function productInsert($data, $file) 
    {

        // $productName = $this->fm->validation($data['productName']);
        // $catId       = $this->fm->validation($data['catId']);
        // $brandId     = $this->fm->validation($data['brandId']);
        // $body        = $this->fm->validation($data['body']);
        // $price       = $this->fm->validation($data['price']);
        // $type        = $this->fm->validation($data['type']);

        $productName = $data['productName'];
        $catId       = $data['catId'];
        $brandId     = $data['brandId'];
        $body        = $data['body'];
        $price       = $data['price'];
        $type        = $data['type'];
        $prod_qty    = $data['prod_qty']; 

        $added_price = $data['added_price'];

        $productName = mysqli_real_escape_string($this->db->link, $productName);
        $catId       = mysqli_real_escape_string($this->db->link, $catId);
        $brandId     = mysqli_real_escape_string($this->db->link, $brandId);
        $body        = mysqli_real_escape_string($this->db->link, $body);
        $price       = mysqli_real_escape_string($this->db->link, $price);
        $type        = mysqli_real_escape_string($this->db->link, $type);
        $prod_qty    = mysqli_real_escape_string($this->db->link, $prod_qty);
        $added_price = mysqli_real_escape_string($this->db->link, $added_price);

        // $productName = htmlspecialchars($this->db->link, $productName);
        // $catId       = htmlspecialchars($this->db->link, $catId);
        // $brandId     = htmlspecialchars($this->db->link, $brandId);
        // $body        = htmlspecialchars($this->db->link, $body);
        // $price       = htmlspecialchars($this->db->link, $price);
        // $type        = htmlspecialchars($this->db->link, $type);
        // $prod_qty    = htmlspecialchars($this->db->link, $prod_qty);
        // $added_price = htmlspecialchars($this->db->link, $added_price);

        $permited= ['jpg', 'jpeg', 'png', 'gif'];

        $file_name= $file['image']['name'];
        $file_size= $file['image']['size'];
        $file_temp= $file['image']['tmp_name'];

        $div= explode('.', $file_name);

        $file_ext= strtolower(end($div));

        $unique_image= substr(md5(time()), 0, 10) . '.'. $file_ext;

        $uploaded_image= "upload/".$unique_image;

        if($productName=='' || $catId=='' || $brandId=='' || $body=='' || $price=='' || $type=='' || $prod_qty=="") {
            $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Field must not be empty.</span>";
            return $msg;
        } else {

            move_uploaded_file($file_temp, $uploaded_image);

            $query= "INSERT INTO tbl_product (productName, catId, brandId, body, price, image, type, prod_qty, added_price) VALUES ('$productName', $catId, $brandId, '$body', $price, '$uploaded_image', $type, $prod_qty, $added_price)";

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

            if($inserted_row) {
                $msg= "<span style='color: green; border: 1px solid green; padding: .5rem 2rem;'>Product inserted successfully.</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Product not inserted!</span>";
                return $msg;
            }

        }


    }

    public function getAllProduct()
    {

        $query= "SELECT tbl_product.* , tbl_category.catName, tbl_brand.brandName 
        FROM tbl_product 
        INNER JOIN
        tbl_category ON
        tbl_product.catId= tbl_category.catId
        INNER JOIN tbl_brand
        ON tbl_product.brandId= tbl_brand.brandId
        ORDER BY tbl_product.productId DESC LIMIT 10
        ";

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

        return $result;

    }

    public function getAllProductAjax($offset) {
        
        $query= "SELECT tbl_product.* , tbl_category.catName, tbl_brand.brandName 
        FROM tbl_product 
        INNER JOIN
        tbl_category ON
        tbl_product.catId= tbl_category.catId
        INNER JOIN tbl_brand
        ON tbl_product.brandId= tbl_brand.brandId
        ORDER BY tbl_product.productId DESC LIMIT $offset, 10
        ";

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

        return $result;
    }

    public function productUpdate($data, $file, $id)
    {

        $productName = $this->fm->validation($data['productName']);
        $catId       = $this->fm->validation($data['catId']);
        $brandId     = $this->fm->validation($data['brandId']);
        $body        = $this->fm->validation($data['body']);
        $price       = $this->fm->validation($data['price']);
        $type        = $this->fm->validation($data['type']);
        $prod_qty    = $this->fm->validation($data['qty']);

        $productName = mysqli_real_escape_string($this->db->link, $productName);
        $catId       = mysqli_real_escape_string($this->db->link, $catId);
        $brandId     = mysqli_real_escape_string($this->db->link, $brandId);
        $body        = mysqli_real_escape_string($this->db->link, $body);
        $price       = mysqli_real_escape_string($this->db->link, $price);
        $type        = mysqli_real_escape_string($this->db->link, $type);
        $prod_qty    = mysqli_real_escape_string($this->db->link, $prod_qty);

        $permited= ['jpg', 'jpeg', 'png', 'gif'];

        $file_name= $file['image']['name'];
        $file_size= $file['image']['size'];
        $file_temp= $file['image']['tmp_name'];

        $div= explode('.', $file_name);

        $file_ext= strtolower(end($div));

        $unique_image= substr(md5(time()), 0, 10) . '.'. $file_ext;

        $uploaded_image= "upload/".$unique_image;

        if ($productName == "" || $catId == "" || $brandId == "" || $body == "" || $price == "" || $type == "" ) {
            $msg = "<span class='error'>Field Must Not be empty .</span> ";
            return $msg;
        }else {

            if (!empty($file_name)) {
                
                if ($file_size > 1054589) {
                    echo "<span class='error'>Image Size should be less then 1MB .</span>";
                } else if (in_array($file_ext, $permited) == false) {
                    echo "<span class='error'> You can Upload Only".implode(',', $permited)."</span>";
                } else{

                    move_uploaded_file($file_temp, $uploaded_image);

                    $query = "UPDATE `tbl_product` SET 
                    productName= '$productName', 
                    catId 	= $catId, 
                    brandId 	= $brandId, 
                    body 		= '$body', 
                    price 	= $price, 
                    image 	= '$uploaded_image', 
                    type 		= $type, 
                    prod_qty= $prod_qty 
                    WHERE productId = $id";

                    $updated_row = $this->db->update($query);
                    if ($updated_row) {
                        $msg = "<span class='success'>Product Updated Successfully.</span> ";
                        return $msg;
                    }else {
                        $msg = "<span class='error'>Product Not Updated .</span> ";
                        return $msg;
                    }

                }

            } else {

                $query = "UPDATE `tbl_product` SET 
                productName = '$productName', 
                catId 	  = $catId, 
                brandId 	  = $brandId, 
                body 		  = '$body', 
                price 	  = $price, 
                type 		  = $type,
                prod_qty= $prod_qty 
                WHERE productId = $id";

                $updated_row = $this->db->update($query);

                if ($updated_row) {
                    $msg = "<span class='success'>Product Updated Successfully.</span> ";
                    return $msg;
                } else {
                    $msg = "<span class='error'>Product Not Updated .</span> ";
                    return $msg;
                }
            
            }
        }

    }

    public function getProById($id)
    {

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

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

        $query= "SELECT * FROM tbl_product WHERE productId= $id";

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

        return $result;

    }

    public function delProById($id)
    {

        $query= "SELECT * FROM tbl_product WHERE productId=$id";

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

        if($getData) {

            $delImg= $getData->fetch_assoc();

            $dellink= $delImg['image'];
                
            unlink($dellink);

        }

        $delquery= "DELETE FROM tbl_product WHERE productId= $id";

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

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


    }

    public function getFeaturedProduct()
    {

        $query= "SELECT * FROM tbl_product WHERE type=0 ORDER BY productId DESC LIMIT 4";
        $result= $this->db->select($query);
        return $result;

    }
    
    public function getFiveClothes() 
    {

        $query= "SELECT * FROM tbl_product tp JOIN tbl_category tc ON tp.catId=tc.catId WHERE tc.catName='clothing' LIMIT 5";

        // echo $query;

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

        // echo "<pre>";
        //     print_r($result);
        // echo "</pre>";

        // die();

        return $result;

    }

    public function getNewProduct()
    {

        $query= "SELECT * FROM tbl_product where type=1 ORDER BY productId DESC LIMIT 4";
        $result= $this->db->select($query);
        return $result;
    }
    
    public function getMoreProduct()
    {

        // $query= "SELECT * FROM tbl_product where type=2 ORDER BY productId ASC LIMIT 20";
        $query= "SELECT * FROM tbl_product where type=2 ORDER BY productId ASC LIMIT 4";
        $result= $this->db->select($query);
        return $result;
    }

    public function getMoreProductTotals() {
        $query= "SELECT count(*) as total_count FROM tbl_product where type=2 ORDER BY productId";
        $result= $this->db->select($query);
        $count= $result->fetch_assoc();
        return $count;
    }

    public function getMoreProdAjax($prodCount, $lastProductId) {
        $query= "SELECT * FROM tbl_product where type=2 AND productId > $lastProductId ORDER BY productId ASC LIMIT $prodCount";
        $result= $this->db->select($query);
        return $result;
    }

    public function getTotalSearchProductsCount($search) {
        $query= "SELECT count(*) FROM tbl_product WHERE productName LIKE '%$search%' OR body LIKE '%$search%'";
        $result= $this->db->select($query);
        print_r($result);
        // return $result;
    }

    public function getMoreSearchProdAjax($prodCount, $search) {
        $query= "SELECT * FROM tbl_product WHERE MATCH(productName) AGAINST('$search') LIMIT $prodCount";
        $result= $this->db->select($query);
        return $result;
    }

    public function getSingleProduct($id)
    {

        $query= "SELECT tbl_product.* , tbl_category.catName, tbl_brand.brandName 
        FROM tbl_product 
        INNER JOIN
        tbl_category ON
        tbl_product.catId= tbl_category.catId
        INNER JOIN tbl_brand
        ON tbl_product.brandId= tbl_brand.brandId
        AND tbl_product.productId=$id 
        ORDER BY tbl_product.productId DESC
        ";

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

        return $result;

    }

    public function productByCat($id) 
    {

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

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

        $query= "SELECT * FROM tbl_product WHERE catId= $id LIMIT 4";

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

        return $result;

    }
    
    public function getMoreProdByCatAjax($lastProductId, $catId, $prodCount, $catName) {

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

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

        // $query= "SELECT * FROM tbl_product WHERE catId= $id LIMIT $prodCount";
        // $query= "SELECT * FROM tbl_product where productId > $lastProductId AND catId=$catId AND catName='$catName' ORDER BY productId ASC LIMIT $prodCount";
        // $query= "SELECT * FROM tbl_product tp JOIN tbl_category tc ON tc.catId=$catId WHERE productId > $lastProductId LIMIT $prodCount";
        $query= "SELECT * FROM tbl_product WHERE catId=$catId AND productId > $lastProductId LIMIT 8";
        // echo $query;
        // exit;
        $result= $this->db->select($query);

        return $result;

    }

    public function countProductByCat($id) {

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

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

        $query  = "SELECT count(*) as total_count FROM tbl_product WHERE catId= $id";

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

        $data   = $res->fetch_assoc();

        return $data['total_count'];

    }

    public function insertCompareData($productId, $cmrId)
    {

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

        $cquery= "SELECT * FROM tbl_compare WHERE cmrId=$cmrId AND productId=$productId";
        $check= $this->db->select($cquery);


        if($check) {

            $msg= "<p id='err-1' style='color: red; padding: .5rem 2rem; text-align: center; background: #DC143C; color: #fff'>Already added, Goto <a href='compare.php' style='color: white; text-decoration: underline'>compare</a></p>";
            return $msg;

        } else {

            $query= "SELECT * FROM tbl_product WHERE productId=$productId";
            $getPro= $this->db->select($query);
    
            $result= $getPro->fetch_assoc();
    
            if($getPro) {
                $productId   = $result['productId'];
                $productName = $result['productName'];
                $price       = $result['price'];
                $image       = $result['image'];
                
                // Added part
                $productName = mysqli_real_escape_string($this->db->link, $productName);
                $productId   = mysqli_real_escape_string($this->db->link, $productId);
                $price       = mysqli_real_escape_string($this->db->link, $price);
                $image       = mysqli_real_escape_string($this->db->link, $image);
    
                $query= "INSERT INTO tbl_compare (cmrId, productId, productName, price, image) VALUES($cmrId, $productId, '$productName', $price, '$image')";
                
                $inserted_row= $this->db->insert($query);
                // return $inserted_row;
    
                if($inserted_row) {
                    $msg= "<span id='comp-err' style='color:green; padding: .5rem 2rem; border: 1px solid green;'>Added to compare.</span>";
                    return $msg;
                } else {
                    $msg= "<span id='comp-err' style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Sorry, product couldn't be added!</span>";
                    return $msg;
                }
    
            }

        }
    }


    public function getCompareProduct($cmrId)
    {

        $query= "SELECT * FROM tbl_compare WHERE cmrId=$cmrId";

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

        return $result;

    }

    public function delCompareData($cmrId)
    {

        $query= "DELETE FROM tbl_compare WHERE cmrId= $cmrId";

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

    }

    public function saveWishListData($id, $cmrId)
    {

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

        $cquery= "SELECT * FROM tbl_wlist WHERE cmrId=$cmrId AND productId=$id";
        $check= $this->db->select($cquery);

        if($check) {
            $msg= "<p id='err-1' style='color: red; padding: .5rem 2rem; text-align: center; background: #DC143C; color: #fff'>Already added, Goto <a href='wishlist.php' style='color: white; text-decoration: underline'>Wishlist</a></p>";
            return $msg;
        }

        $query= "SELECT * FROM tbl_product WHERE productId=$id";
        $getPro= $this->db->select($query);

        $result= $getPro->fetch_assoc();

        if($getPro) {

            $productId   = $result["productId"];
            $productName = $result["productName"];
            $price       = $result["price"];
            $image       = $result["image"];
            
            // Added part
            $productName = mysqli_real_escape_string($this->db->link, $productName);
            $productId   = mysqli_real_escape_string($this->db->link, $productId);
            $price       = mysqli_real_escape_string($this->db->link, $price);
            $image       = mysqli_real_escape_string($this->db->link, $image);

            $query= "INSERT INTO tbl_wlist (cmrId, productId, productName, price, image) VALUES($cmrId, $productId, '$productName', $price, '$image')";
            
            $inserted_row= $this->db->insert($query);

            if($inserted_row) {
                $msg= "<span id='comp-err' style='color:green; padding: .5rem 2rem; border: 1px solid green;'>Added to Wishlist.</span>";
                return $msg;
            } else {
                $msg= "<span id='comp-err' style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Sorry, product couldn't be added!</span>";
                return $msg;
            }

        }

    }

    public function checkWlistData($cmrId){
        $query = "SELECT * FROM tbl_wlist WHERE cmrId =$cmrId ORDER BY id DESC ";
        $result = $this->db->select($query);
        return $result;
    }

    public function delWlistData($cmrId, $productId)
    {

        $query= "DELETE FROM tbl_wlist WHERE cmrId=$cmrId AND productId=$productId";

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

    public function productBySearch($search)
    {   

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

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

        $query= "SELECT * FROM tbl_product WHERE MATCH(productName) AGAINST('$search') LIMIT 4";

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

        return $result;

    }

    public function productBySearchCount($search)
    {   

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

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

        $query= "SELECT * FROM tbl_product WHERE productName LIKE '%$search%' OR body LIKE '%$search%' ";

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

        return $result->num_rows;

    }

    public function checkProductAvailability($id)
    {

        $query= "SELECT * FROM tbl_product WHERE productId=$id";
        $res= $this->db->select($query);

        return $res;
    }

    public function checkWishlistDataAvailability($productId)
    {

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

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

        $query= "SELECT * FROM tbl_wlist WHERE productId= $productId";

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

        if($res) {
            return true;
        }

    }


    public function checkWishlist() 
    {

        $cmrId= Session::get("cmrId");

        $query= "SELECT * FROM tbl_wlist WHERE cmrId=$cmrId";

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

        return $res;

    }

    public function insertComment($review_text, $cmrName, $id)
    {

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

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

        if($id == "" || $review_text== "" || $cmrName=="") {

            $msg= "Something went wrong!";

            return $msg;

        } else {

            // date time function
            date_default_timezone_set("Asia/Kathmandu");
            $date        = date("Y-m-d h:i:s A");
            $final       = strtotime($date);
            $time_posted = date("Y-m-d H:i:s", $final);
            $query       = "INSERT INTO tbl_comment(cus_name, comment, date, approved_status, product_id) VALUES('$cmrName', '$review_text', '$time_posted', 0, $id)";
            $res         = $this->db->insert($query);

            if($res) {
                return "<p id='rem-msg' style='width: 300px; color: green; border: 1px solid green; padding: .5rem 2rem'>Review added Successfully! It might take some time to display here.</p>";
            } else {
                return "<p style='width: 300px; color: red; border: 1px solid red; padding: .5rem 2rem'>Sorry, Something went wrong!</p>";
            }

        }

    }

    public function getAllReviews($id)
    {

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

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

        // $query= "SELECT * FROM tbl_comment WHERE product_id=$id AND approved_status=1";
        $query= "SELECT * FROM tbl_comment t_cmt JOIN tbl_customer t_cus ON t_cus.id= t_cmt.customer_id WHERE product_id=$id AND approved_status=1";

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

        return $res;

    }


    public function showReviews() {

        $query= "SELECT tc.product_id, 
        tp.productId,  
        tc.id ID, 
        tp.productName AS PN, 
        tbl_cust.name AS C_NAME, 
        tc.comment AS CMT, 
        tc.date AS DAT, 
        tc.approved_status AS A_S,
        tbl_cust.id  as cus_table_id
        FROM tbl_comment AS tc 
        INNER JOIN tbl_product AS tp ON tc.product_id = tp.productId 
        INNER JOIN tbl_customer tbl_cust ON tbl_cust.id= tc.customer_id ORDER BY date DESC LIMIT 10";

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

    }

    public function showReviewsAjax($offset) {
        $query= "SELECT tc.product_id, 
        tp.productId,  
        tc.id ID, 
        tp.productName AS PN, 
        tbl_cust.name AS C_NAME, 
        tc.comment AS CMT, 
        tc.date AS DAT, 
        tc.approved_status AS A_S,
        tbl_cust.id  as cus_table_id
        FROM tbl_comment AS tc 
        INNER JOIN tbl_product AS tp ON tc.product_id = tp.productId 
        INNER JOIN tbl_customer tbl_cust ON tbl_cust.id= tc.customer_id ORDER BY date DESC LIMIT $offset, 10";

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

    public function approveComment($prodid)
    {

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

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

        $query= "UPDATE tbl_comment SET approved_status=1 WHERE id=$prodid";

        $res= $this->db->update($query);

        if($res) {
            return "<p id='rem-msg' style='width: 300px; color: green; border: 1px solid green; padding: .5rem 2rem'>Status Updated Successfully!</p>";
        }

    }

    public function unapproveComment($prodid)
    {

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

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

        $query= "UPDATE tbl_comment SET approved_status=0 WHERE id=$prodid";

        $res= $this->db->update($query);

        if($res) {
            return "<p id='rem-msg' style='width: 300px; color: green; border: 1px solid green; padding: .5rem 2rem'>Status Updated Successfully!</p>";
        }

    }


    public function sendMessage($fullName, $email, $phoneNumber, $subject) {

        $fullName     = $this->fm->validation($fullName);
        $email        = $this->fm->validation($email);
        $phoneNumber  = $this->fm->validation($phoneNumber);
        $subject      = $this->fm->validation($subject);

        $fullName     = mysqli_real_escape_string($this->db->link, $fullName);
        $email        = mysqli_real_escape_string($this->db->link, $email);
        $phoneNumber  = mysqli_real_escape_string($this->db->link, $phoneNumber);
        $subject      = mysqli_real_escape_string($this->db->link, $subject);

        if($fullName=="" || $email=="" || $phoneNumber=="" || $subject=="") {
            $msg= "<p id='err-msg' style='color: red; text-align: center; margin-top: 1rem'>Field must not be empty!</p>";
            return $msg;
        } else {

            $query= "INSERT INTO tbl_message(full_name, email, phone, message, seen_status) VALUES('$fullName', '$email', '$phoneNumber', '$subject', 0)";

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

            if($res) {
                $msg= "<p id='err-msg' style='color: green; text-align: center; margin-top: 1rem'>Your message is sent.</p>";
                return $msg;
            } else {
                $msg= "<p id='err-msg' style='color: red; text-align: center; margin-top: 1rem'>Sorry, something went wrong.</p>";
            }

        }

    }

    public function getAllMessages()
    {

        $query= "SELECT * FROM tbl_message ORDER BY id DESC";

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

        return $res;

    }

    public function viewMessage($viewid)
    {

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

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

        $query  = "SELECT * FROM tbl_message WHERE id=$viewid";

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

        return $result;

    }

    public function updateToSeen($id)
    {

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

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

        $query= "UPDATE tbl_message SET seen_status=1 WHERE id=$id";

        $res= $this->db->update($query);

        return $res;

    }

    public function updateToUnSeen($id)
    {

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

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

        $query= "UPDATE tbl_message SET seen_status=0 WHERE id=$id";

        $res= $this->db->update($query);

        return $res;

    }

    // check Product By Id
    public function checkProductById($id)
    {

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

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

        $query  = "SELECT * FROM tbl_product WHERE productId=$id";

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

        return $result;

    }


}

?>