1#@!#!123s

��JFIF�� 1#@!#!123s
: / home1 / ajmalhsiery / public_html / admin / common / classes /
Filename : blogs.class.php
back
<?php
class Blogs
{
	public $conn;
	function __construct($conn)
	{
		$this->conn = $conn;
	}

public function add($title,$slug, $description, $tags, $imagePath)
{
    $tagsString = is_array($tags) ? implode(',', $tags) : $tags;

    $sql = "INSERT INTO blogs (title,slug, description, tags, f_img) 
            VALUES (?,?, ?, ?, ?)";

    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("sssss", $title,$slug, $description, $tagsString, $imagePath);

    if ($stmt->execute()) {
        header("Location: blog_list.php"); // Wapas usi page par
        return true;
        exit();
    } else {
        header("Location: blog_list.php"); // Wapas usi page par
        return false;
        exit();
    }
}

function createSlug($title) {
    $slug = strtolower($title);
    $slug = preg_replace('/[^a-z0-9]+/', '-', $slug);
    $slug = trim($slug, '-');
    $slug = preg_replace('/-+/', '-', $slug);
    return $slug;
}


	public function getBlogById($itemId)
    {
        $sql = "SELECT * FROM blogs WHERE id = ?";
        $stmt = $this->conn->prepare($sql);
        $stmt->bind_param("i", $itemId);
        $stmt->execute();
        $result = $stmt->get_result();

        return $result->fetch_assoc();
    }

	public function editBlog($title,$slug, $description, $tags, $imagePath, $itemId)
    {
        $tagsString = is_array($tags) ? implode(',', $tags) : $tags;
        if ($imagePath) {
            $sql = "UPDATE blogs SET title = ?,slug = ?, description = ?, tags = ?, f_img = ? WHERE id = ?";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("sssssi", $title,$slug, $description, $tagsString, $imagePath, $itemId);
        } else {
            $sql = "UPDATE blogs SET title = ?,slug = ?, description = ?, tags = ? WHERE id = ?";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ssssi", $title,$slug, $description, $tagsString, $itemId);
        }

        return $stmt->execute();
    }

	 // Delete an item
	 public function deleteBlog($itemId)
	 {
		 $sql = "DELETE FROM blogs WHERE id = ?";
		 $stmt = $this->conn->prepare($sql);
		 $stmt->bind_param("i", $itemId);
 
		 if ($stmt->execute()) {
        header("Location: blog_list.php"); // Wapas usi page par
        return true;
        exit();
    } else {
        header("Location: blog_list.php"); // Wapas usi page par
        return false;
        exit();
    }
	 }

	  // Fetch all items
	  public function getAllBlogs()
	  {
		  $sql = "SELECT * FROM blogs";
		  $result = $this->conn->query($sql);
  
		  return $result->fetch_all(MYSQLI_ASSOC);
	  }
	  
	  public function paginatedBlogs($limit, $offset) {
            $sql = "SELECT * FROM blogs LIMIT ? OFFSET ?";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ii", $limit, $offset);
            $stmt->execute();
            $result = $stmt->get_result();
            return $result->fetch_all(MYSQLI_ASSOC);
        }
        
        public function getTotalBlogsCount() {
                $sql = "SELECT COUNT(*) as total FROM blogs";
                $result = $this->conn->query($sql);
                $row = $result->fetch_assoc();
                return $row['total'];
            }
            
            public function getblogbyTitle($post)
    {
        $sql = "SELECT * FROM blogs WHERE title = ?";
        $stmt = $this->conn->prepare($sql);
        $stmt->bind_param("s", $post);
        $stmt->execute();
        $result = $stmt->get_result();

        return $result->fetch_assoc();
    }
            public function getBlogByslug($post)
    {
        $sql = "SELECT * FROM blogs WHERE slug = ?";
        $stmt = $this->conn->prepare($sql);
        $stmt->bind_param("s", $post);
        $stmt->execute();
        $result = $stmt->get_result();

        return $result->fetch_assoc();
    }
	  
	  public function getLatestBlogs()
	  {
		  $sql = "SELECT * FROM blogs ORDER BY id DESC";
		  $result = $this->conn->query($sql);
  
		  return $result->fetch_all(MYSQLI_ASSOC);
	  }



}