我想从db获取数据，按名称，而不是通过单击超级链接的id。

Question

我是一个新的代码点火器，我试图获取同一位置的所有作业的数据，在我看来，我写了一些代码，但是当我试图获取数据时，它给了我单个数据，我想获取所有相同位置的数据，这里是我的控制器。

public function location($location){
    $data['jobs'] = $this->edituser_model->getBlogBylocation($location); 
    $this->load->view('locwise' , ['data'=>$data]);
}

模型是

 public function getBlogBylocation($location){
            $this->db->select('*');

        $this->db->like('location', $location);
        $query = $this->db->get('jobs');
       if($query->num_rows() > 0){
        return $query->row();
       }else {
        return false;
       }

    }

我的看法是

<?php foreach ($data as $key => $data): ?> 
                <div class="job-box">
                    <div class="company-logo">

                    </div>




        <div class="row">



            <div class="col-lg-12">
                  <div class="alert alert-success alert-2" role="alert">
                            <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                           Recently Posted Jobs in <?php echo $data->location?>
                        Citi</div>
        <div class="row">
                <div class="job-box">

                    <div class="description">
                        <div class="float-left">

                                <h5 class="title"><a href="<?php echo site_url('candidate/jobs_detail/' .$data->id);?>"><?php echo $data->job_title?></a></h5>
                            <div class="candidate-listing-footer">



                                <ul>

                                    <li><i class="flaticon-pin">&nbsp;</i><?php echo $data->location?></li>
                                    <li><i class="flaticon-money">&nbsp;</i><?php echo $data->salary?></li>
                                    <li><i class="flaticon-work">&nbsp;</i><?php echo $data->timing?></li>
                                    <!--<li><i class="flaticon-honor">&nbsp;</i><?php echo $jobs->qualification?></li>
                                     <li><i class="flaticon-notepad">&nbsp;</i><?php echo $jobs->experience?></li>-->

                                </ul>&nbsp;

                                <h6>Deadline:<?php echo $data->deadline?></h6>
                            </div>
                        </div>
                        <div class="div-right">
                            <a href="<?php echo site_url('candidate/edit/' .$data->id);?>" class="apply-button">Apply Now</a>
                            <!--<a href="#"><i class="flaticon-heart favourite"></i></a>-->

                        </div>

                    </div>

                </div>



                       </div>
                       </div><!--end row-->


            </div>

        </div>
         <?php endforeach ?>
    </div> 

我想通过点击超链接来显示多张唱片而不是单张，提前感谢朱丽德·阿明

Answer 1

请更新您的控制器方法、模型方法和视图如下：

Controller::Method

public function location($location){
    $data['jobs'] = $this->edituser_model->getBlogBylocation($location); 
    $this->load->view('locwise' , $data);
}

Model::Method

 public function getBlogBylocation($location){
    $this->db->select('*');
    $this->db->like('location', $location);
    $query = $this->db->get('jobs');

    if($query->num_rows() > 0){
        return $query->result();
    } else {
        return false;
    }
 }

View

<?php foreach ($jobs as $row): ?>

//Your staff goes here (i.e. $row->name_of_properties)

<?php endforeach ?>

Answer 2

在您的标签中传递名称而不是id，并为该配置/路由文件创建路由

$route['location/(:any)'] = 'controller_name/function_name/$1';
public function location($location){
    $data['jobs'] = $this->edituser_model->getBlogBylocation($location); 
    $this->load->view('locwise' , ['data'=>$data]);
}