如何在Codeigniter中显示特定行数据

bbuxkriu  于 2022-12-07  发布在  其他
关注(0)|答案(1)|浏览(80)

我有一个引导卡,在我的CodeIgniter视图中有“阅读更多”选项。单击按钮时,url显示所选的卡ID,但只有数据库中的第一行被提取。不确定,我哪里做错了。
控制器代码从此处开始

public function getDetails()
{
        $query = $this->db->query("SELECT swo_brief_intro, swo_image_heading FROM services_offered");

        $row = $query->row();

        if (isset($row))
        {
                echo $row->swo_image_heading;
                echo $row->swo_brief_intro;
        }

        
}

View的代码从此处开始

<div class="row clearfix">

<?php 
    $query = $this->db->query("SELECT * FROM services_offered LIMIT 15");
    foreach ($query->result() as $row) {
        echo "<div class='col-lg-4 bottommargin-sm'>";
        echo "<div class='feature-box media-box fbox-bg'>";
        echo "<div class='fbox-media'>";
        echo "<a href='#'><img src='$row->swo_images' alt='Featured Box Image' style='height:250px; width:450px;'></a></div>";
        echo "<div class='fbox-content fbox-content-lg'>";
        $string = $row->swo_brief_intro;
        $string = word_limiter($string, 15);
        echo "<h3 class='nott ls0 font-weight-semibold'>$row->swo_image_heading<span class='subtitle font-secondary font-weight-light ls0'>$string</span></h3>";
        echo "<a href='Fetch/getDetails/{$row->id}' class='button-link border-0 color btn-edit'>Read More</a>";
        echo "</div>";
        echo "</div>";
        echo "</div>";

    }
?>

请帮忙谢谢

svgewumm

svgewumm1#

a)您忘记在函数中添加Id参数。
B)以及忘记基于此更改查询。

public function getDetails($id)
{

    $row = $this 
            -> db
            -> select('swo_brief_intro, swo_image_heading')
            -> where('<put here id column name>', $id)
            -> limit(1)
            -> get('services_offered')
            -> row();
    
    if (isset($row))
    {
        echo $row->swo_image_heading;
        echo $row->swo_brief_intro;
    }
        
}

相关问题