+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: junction table join? (/showthread.php?tid=82681)
junction table join? - bikebetty - 08-08-2022
I have a junction table. I want to make a datatable. I did this with other tables and I created a join but can I do this with a large junction table?
RE: junction table join? - SubrataJ - 08-08-2022
(08-08-2022, 08:19 PM)bikebetty Wrote: I have a junction table. I want to make a datatable. I did this with other tables and I created a join but can I do this with a large junction table?
Obviously, you can do that with the correct query.
RE: junction table join? - bikebetty - 08-09-2022
(08-08-2022, 10:32 PM)SubrataJ Wrote:(08-08-2022, 08:19 PM)bikebetty Wrote: I have a junction table. I want to make a datatable. I did this with other tables and I created a join but can I do this with a large junction table?
Obviously, you can do that with the correct query.
Can you show me how or lead me to a place where I can learn?
RE: junction table join? - SubrataJ - 08-09-2022
(08-09-2022, 06:48 AM)bikebetty Wrote:(08-08-2022, 10:32 PM)SubrataJ Wrote:(08-08-2022, 08:19 PM)bikebetty Wrote: I have a junction table. I want to make a datatable. I did this with other tables and I created a join but can I do this with a large junction table?
Obviously, you can do that with the correct query.
Can you show me how or lead me to a place where I can learn?
I don't know about your table structure, if we could provide it, I will be more than happy to assist.
RE: junction table join? - bikebetty - 08-09-2022
(08-09-2022, 08:36 AM)SubrataJ Wrote:(08-09-2022, 06:48 AM)bikebetty Wrote:(08-08-2022, 10:32 PM)SubrataJ Wrote:(08-08-2022, 08:19 PM)bikebetty Wrote: I have a junction table. I want to make a datatable. I did this with other tables and I created a join but can I do this with a large junction table?
Obviously, you can do that with the correct query.
Can you show me how or lead me to a place where I can learn?
I don't know about your table structure, if we could provide it, I will be more than happy to assist.
PHP Code:
id agricultural_operation_address_id property_owner_address_id agricultural_operation_owner_address_id operator_address_id wqpp_id creation_date started_date finished_date last_edit_date current_step current_address_index current_operation_details_index current_parcel_index current_wqpp_index current_map_index user_id is_active started finished prepaired_by groundwater_wells_used_for_drinking_water groundwater_monitoring_by has_waterbodies_located_within_100_feet waterbodies_located_within_100_feet has_waterbody_pass_through_or_exist_on waterbody_pass_through_or_exist_on has_irrigation_return_flow_or_storm_water_discharged user_agent pdf_emailed_date active
3 12 13 14 15 3 1500952539 1500952543 1501693782 1501693782 6 4 2 1 3 1 1 1 0 Michael 0 0 0 0 Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36 1501693809 0
17000 17 18 19 20 4 1500991346 1500991353 1503082969 4 4 2 1 1 1 7543 1 0 0 1 lake 0 0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36 Edge/15.15063 1
17001 21 22 23 24 5 1500998879 1500998895 1569350595 1569350595 6 4 2 8 3 2 7245 1 1 Janet 0 0 0 0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18362 1569350648 1
Code:
public function get_all_invoices(){
$this->db->select('
ci_payments.id,
ci_payments.invoice_no,
CONCAT(ci_users.member_first_name, " ", ci_users.member_last_name) as client_name,
ci_users.member_first_name,
ci_users.member_last_name,
ci_payments.payment_status,
ci_payments.grand_total,
ci_payments.currency,
ci_payments.due_date,
'
);
$this->db->from('ci_payments');
$this->db->join('ci_users', 'ci_users.id = ci_payments.user_id ', 'left');
$query = $this->db->get();
return $query->result_array();
}
I did the other one like this. I don't know if that's right but it seems to be working. This other one is just so much information.