Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Development CodeIgniter 2.x Codeigniter multi table model
Codeigniter multi table model
  • Offline JustJohnQ
    Member
  • ***
  • Posts: 204
    Threads: 3
    Joined: Mar 2022
    Reputation: 13
#2
12-21-2022, 12:12 AM

If the view will contain a combination of the 6 tables you will need to join the tables in your model using SQL join.
If your view contains separate data from the six tables, you would call the respective queries in your model 6 times,

PHP Code:
$data['query1result'] = $this->model->getQuery1();
$data['query2result'] = $this->model->getQuery2(); 

etc.
Reply


Messages In This Thread
Codeigniter multi table model - by JamesHimmerla - 12-20-2022, 04:41 AM
RE: Codeigniter multi table model - by JustJohnQ - 12-21-2022, 12:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB