douyue5856 2013-08-30 20:14
浏览 13
已采纳

如何在codeigniter中交互数据库结果?

i have an problem. I have two tables:

1 called 'Offers' 1 called 'Networks'

In the 'Offers' table i have an field called 'NetworkId' and in my table 'Networks' i have an list of all networks with fild 'Id' and 'Name'.

I have an method in my Model to get all the rows in table 'Offers'. What i want know is how can i get the value of field 'Name' located in table 'Networks' using the 'NetworkID' that i grab with my method in my model.

I need create an new method ? create function ? idk what to do.

this is my controller atm:

public function index()
    {
        // Get List of the Offers
        $this->load->model('offers_model');

        $data['results_offers'] = $this->offers_model->list('all');

        $this->load->view('offers_home', $data);

    }

and this is my model code:

function list($id){

    if($id != "all")
    {
        $query = $this->db->get_where('offers', array('offerid' => $id));
    }
    else
    {
        $query = $this->db->get('offers');
    }


    return $query->result();
}

Thanks for help me!

  • 写回答

1条回答 默认 最新

  • doudg60800 2013-08-30 20:24
    关注

    Try this

    function getAllOffers(){
        $query = $this->db->select('a.fieldname, b.name')->from('offers as a')->join('networks as b','a.networkid = b.id')->get();
        return $query->result_array();
    }
    

    Further Information check Active Record

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

报告相同问题?

悬赏问题

  • ¥20 Windows 驱动开发版本疑问相关
  • ¥15 MAC 未能打开磁盘映像
  • ¥15 fastcap使用,二维导体输入问题
  • ¥15 hosts修改后不能访问
  • ¥15 关于化学反应速率C++编译问题/FLUENT
  • ¥20 Yolov5训练报错
  • ¥15 Unity发布gzip压缩的webgl之后让浏览器可以正常显示画面
  • ¥15 ASP.net Gridview插件数据更新失败问题
  • ¥15 有没有人知道这种提示怎么关?现在不做ts项目了不知道咋关了,求解,现在我以前的js项目都是这种提示了
  • ¥15 为什么mysql做了碎片化处理data_free还是很高