如何从博客表中获取最近的 3 篇文章:洋红色 - How to fetch recent 3 post from a blog table: magento

How to fetch recent 3 post from a blog table: magento

本文关键字：文章洋红色最近获取 | 更新日期: 2023-09-27

我在数据库中有一个表格作为"neotheme_blog_post"，里面有很多帖子，现在我想从这个表格中获取最近的 3 个帖子并在主页上显示它们：我尝试按如下方式获取数据，但没有任何效果：

    <?php $connection = 
      Mage::getSingleton('core/resource')->getConnection('core_read');
      $query      = "Select * FROM 'neotheme_blog_post'";
      $rows       = $connection->fetchAll($query);
      foreach ($rows as $values) {
      echo $name = $values['name'];
      }?>

你可以在这里使用LIMIT。

$connection = Mage::getSingleton('core/resource')->getConnection('core_read');
$query      = "Select * FROM neotheme_blog_post LIMIT 3";
$rows       = $connection->fetchAll($query);
foreach ($rows as $values){
echo $name = $values['name'];
}

就我而言，我使用neotheme博客扩展获得了以下三篇最近的帖子：

     $connection = 
     Mage::getSingleton('core/resource')->getConnection('core_read');
     $query = "Select * FROM neotheme_blog_post ORDER BY created_at DESC LIMIT 3 ";
     $rows = $connection->fetchAll($query);
     foreach ($rows as $values) {
     $post_titile = $values['cms_identifier'];
     echo '<div>';
     echo '<h1>' . $name = $values['title'] . '</h1>';
     echo $summery = $values['summary'];
     echo '<a href="' . $this->getUrl().'blog/'.  $post_titile . '">Read More</a>';
      echo '</div>';