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!

图片转代码服务由CSDN问答提供 功能建议

我遇到了问题。 我有两个表:

1称为'优惠' 1称为'网络'

在'优惠'表中,我有一个名为'的字段' NetworkId'和我的表'Networks'中列出了所有具有fild'Id'和'Name'的网络。

我的模型中有一个方法可以获取表'优惠'中的所有行。 我想知道的是如何使用我在我的模型中使用我的方法获取的'NetworkID'来获取位于表'Networks'中的字段'Name'的值。

我需要 创建一个新方法? 创造功能? idk该怎么做。

这是我的控制器atm:

 公共功能索引()
 {
 //获取列表 优惠
 $ this-> load-> model('offers_model'); 
 
 $ data ['results_offers'] = $ this-> offers_model-> list('all'); \  n 
 $ this-> load-> view('offers_home',$ data); 
 
} 
   
 
 

这是我的型号代码 :

 函数列表($ id){
 
 if if($ id!=“all”)
 {
 $ query = $ this-> db  - > get_where('offers',array('offerid'=> $ id)); 
} 
 else 
 {
 $ query = $ this-> db-> get('offers'  ); 
} 
 
 
返回$ query-> result(); 
} 
   
 
 

感谢您的帮助!

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

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

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题