- Download Codeigniter-3 Set_up
- Install it to xampp folder in your computer
- open the project file in any text editor like – sublime text 3 or vs code or any others text editor.
Open Your Codeigniter 3 Project Folder
- routes
- Controller
- Join_model(model)
- Config
- Databse
Please Note
I have 2 tables in my php_admin database(database name is rainbow). one table has invoice id & another table has invoice no.
these 2 table has one respective column called –
- billing_header
- return_bill
in the billing_header table, we have the respective field call – id
in return_bill, we have a respective field is call – invoice_no
these 2 column has the same field of both invoice_no & id.
Also you must specify your database file with this code below
1.Routes File
2.Controller File
3.Model File
4. Result on Browser
How to join 3 table in codeigniter 3?
Change to model file
Just follow the above code, but only change this line(highlighted with red) to join 3 tables.
4. Result on Browser
How to join 4 table?
Same code on above model but add extra line like this
$this->db->join(‘billing_details as bd’, ‘bd.billing_header_id=rb.invoice_no’,’left’);
you must specify another table name on billing_details as your table & also attention to what is the common on 4th table field.
Good way of explaining, ɑnd fastidious paragraph
t᧐ obtɑin іnformation regarding mʏ presentation subject matter, ᴡhich i am gοing to deliver in school.
Hi, i feel that i noticed you visited my site thus i got here
to return the prefer?.I’m attempting to to find issues to
enhance my website!I guess its ok to make use of a few of your ideas!!
Feel free to visit my blog post :: 오피타임
Your mode of explaining everything in this paragraph is genuinely nice,
all be able to without difficulty be aware of
it, Thanks a lot.
It’s amazing to visit this website and reading the views of
all colleagues about this paragraph, while I am also keen of getting knowledge.
Very great post. I simply stumbled upon your weblog and wished to say that I have really loved browsing your blog posts.
After all I’ll be subscribing to your rss feed and I am hoping you write
once more soon!
My relatives all the time say that I am killing my time here at net, but I know I am
getting know-how daily by reading such pleasant content.
Link exchange is nothing else however it is only placing the
other person’s website link on your page at proper place and other person will also do similar in support of you.
This iѕ realⅼʏ fascinating, Yⲟu are аn overly skilled blogger.
I’vе joined үoᥙr feed andd ⅼook forward to in queѕt of mߋre off уour magnificent post.
Additionally, І’ve shared youг website in my
social networks