Join other table Bootstrap theme

Allows you to join other tables. Only INNER JOIN supported. Keys in all joined tables must exist and be unique

HIDE CODE

<?php
	$xcrud = Xcrud::get_instance();
    $xcrud->table('employees');
    $xcrud->join('officeCode','offices','officeCode'); // ... INNER JOIN offices ON employees.officeCode = offices.officeCode ...
    echo $xcrud->render();
	
	 
	
?>
<script>
			$(document).ready(function() {
				$(".xcrud-list").tableHeadFixer({"head" : false, "left" : 2}); 
			});
		</script>

Employees

Print Export into CSV

Add

#	Lastname	Firstname	Extension	Email	Officecode	Reportsto	Jobtitle	City	Phone	Addressline1	Addressline2	State	Country	Postalcode	Territory	Ordering
1	Ertel Costa	Test		ajec@gmail.com	1	456	TIx	San Francisco	+1 650 219 4782	100 Market Street	Suite 300	CA	USA	94080	NA	9
2					10			RIO DE JANEIRO		RUA DONA CECILIA, 35	RUA DONA CECILIA, 35 APTO 201	Rio de Janeiro	33	20.250-460		5
3	2342sd	yxds	ds	Jjjjhhss@dx.com	6			Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	6
4	d344	aaa		dsgfdsf@ndd.com	5			Tokyo	+81 33 224 5000	4-1 Kioicho		Chiyoda-Ku	Japan	102-8578	Japan	8
5	Jsjej	Sfc			12			sausar	08085629298	dsfdzzxczxczxzx	x	Madhya Pradesh	India	480106		4
6					10			RIO DE JANEIRO		RUA DONA CECILIA, 35	RUA DONA CECILIA, 35 APTO 201	Rio de Janeiro	33	20.250-460		5
7					7			London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2
8	test	test	test	test@test.com	7	11	test	London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2
9	hhh	Peter	fdgdgf	kovacevicvuk77@rewf.com	7	466	dfgdfgdgf	London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2
10	Loco Mayo	Juan Care Loco			2			Boston	+1 215 837 0825	1550 Court Place	Suite 102	MA	USA	02107	NA	7