时间戳

首页 > 解决方案 > 如何从数据库中获取活动帖子

php - 如何从数据库中获取活动帖子

问题描述

这是我的索引页代码。我已经使用了 where 子句但抛出了一些错误

$query = mysqli_query($con,"SELECT
    tblposts.id AS pid,
    tblposts.PostTitle AS posttitle,
    tblposts.PostImage,
    tblcategory.CategoryName AS category,
    tblcategory.id AS cid,
    tblsubcategory.Subcategory AS subcategory,
    tblposts.PostDetails AS postdetails,
    tblposts.PostingDate AS postingdate,
    tblposts.PostUrl AS url
    FROM tblposts
        LEFT JOIN tblcategory ON tblcategory.id=tblposts.CategoryId
        LEFT JOIN tblsubcategory ON tblsubcategory.SubCategoryId=tblposts.SubCategoryId
    ORDER BY tblposts.id DESC LIMIT $offset, $no_of_records_per_page");

我的 tblposts 表如下：

在此处输入图像描述

标签： phpsql

解决方案

我认为您对 SQL 查询有疑问，因为您的问题可能与从数据库中获取数据有关。根据您提供的表格的查询和屏幕截图，以下代码将过滤is_active列中的帖子。

$query = mysqli_query($con,"SELECT
    tblposts.id AS pid,
    tblposts.PostTitle AS posttitle,
    tblposts.PostImage,
    tblcategory.CategoryName AS category,
    tblcategory.id AS cid,
    tblsubcategory.Subcategory AS subcategory,
    tblposts.PostDetails AS postdetails,
    tblposts.PostingDate AS postingdate,
    tblposts.PostUrl AS url
    FROM tblposts
        LEFT JOIN tblcategory ON tblcategory.id=tblposts.CategoryId
        LEFT JOIN tblsubcategory ON tblsubcategory.SubCategoryId=tblposts.SubCategoryId
    WHERE tblposts.is_active = 0
    ORDER BY tblposts.id DESC LIMIT $offset, $no_of_records_per_page");

在上面的代码中，WHERE tblposts.is_active = 0将过滤 is_active列值为 0 的帖子。

推荐阅读