douxuanou2787 2014-12-14 16:38
浏览 49
已采纳

如何使用codeigniter从数据库中检索值

Controller

public function index()
{

    $config["base_url"] = base_url() . "index.php/admin_requirements/index";
    $config["total_rows"] = $this->admin_requirements_full->record_count();
    $config['per_page'] = 5;
    $this->pagination->initialize($config);
    $page = $this->uri->segment(3);

    $data['results'] = $this->admin_requirements_full->display($config["per_page"], $page);
    $data['links'] = $this->pagination->create_links();

    $session_data = $this->session->userdata('logged_in');
    $data['username'] = $session_data['username'];

    $this->load->view('adminpanel/header',$data);
    $this->load->view('adminpanel/menubar');
    $this->load->view('adminpanel/footer');
}

Model

function display($limit, $start)
{

    $this->db->limit($limit, $start);
    $query  =   $this->db->get('db_requirements');
    return $query->result();
}

public function record_count() 
{
    return $this->db->count_all("db_requirements");
}

View

<?php
    foreach($results as $data) 
    {
?>
    <tr align="center">
        <td height="29"><?php echo $data->id; ?></td>
        <td><?php echo $data->cat_id; ?></td>
        <td><?php echo $data->subcat_id; ?></td>
        <td><?php echo $data->city; ?></td>
        <td><?php echo $data->email_id; ?></td>
        <td><?php echo $data->phone; ?></td>
        <td><?php echo $data->publish; ?></td>
        <td>Delete</td>
    </tr>
<?php
    }
?>
</table>
<p class="pages">Pages : <?php echo $links; ?></p>

Result

[Sl.No] [category] [subcategory]
1               1               1
2               3               1

In the above result CATEGORY and SUBCATEGORY fields are in numerals. The actual value of these numbers are stored in another database table.

My question is , how can i retreive actual value for the above numbers.

My CATEGORY and SUBCATEGORY databse are given below.

// db_bus_category

id, item

// db_bus_subcategory

id, cat_id, subcat_id, item
  • 写回答

1条回答 默认 最新

  • doujia9833 2014-12-14 18:06
    关注

    If you need to get values from other tables you will need to use an SQL JOIN. A cursory glance at the active record section of the codeigniter documentation shows a function $this->db->join();

    https://ellislab.com/codeigniter/user-guide/database/active_record.html

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 有没有人会打学生成绩管理系统呀
  • ¥15 在使用Fiddler和夜神模拟器抓包的时候一直出现443该怎么办啊QAQ搜了好几个笔记都没有解决
  • ¥15 3x7的二维数组A、B、C,A中的任意1个数组元素与B的任意1个数组元素、同时又与C的任意1个数组元素比较,把不同位置出现相同数的比较称为无意义,反之称为有意义,把有意义的比较打印输出。
  • ¥20 预测模型怎么处理原始数据(随机森林)
  • ¥20 请问discuz3.5如何实现插入ckplayer全能播放器功能呢?
  • ¥15 thingsboard代码编译出错误
  • ¥15 博途v18仿真报错怎么解决
  • ¥15 欧姆龙plc枕式包装机 ST编程
  • ¥15 为啥快手广告联盟的广告这么难出来
  • ¥15 k8s集群重启后,kubelet一直报systemctl restart kubelet.service "Failed to delete cgroup paths"