Join other table Default 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

#	Lastname	Firstname	Extension	Email	Officecode	Jobtitle	City	Phone	Addressline1	Addressline2	State	Country	Postalcode	Territory	Ordering
1	ss	4545	f4545	soso@oo.net	10	ffss	RIO DE JANEIRO		RUA DONA CECILIA, 35	RUA DONA CECILIA, 35 APTO 201	Rio de Janeiro	33	20.250-460		5
2					3		NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	8
3	testing	vxvcxcv222			7		London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	4
4	test	5541itest	gfhfg		2		Boston	+1 215 837 0825	1550 Court Place	Suite 102	MA	USA	02107	NA	0
5	sdfds	tdfsdf			10		RIO DE JANEIRO		RUA DONA CECILIA, 35	RUA DONA CECILIA, 35 APTO 201	Rio de Janeiro	33	20.250-460		5
6		lhjkl			4		Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	3
7	VCXVCX	XCXCVX			3		NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	8
8	fdsfsfds	fdsfs			7		London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	4
9	ujhgjhgjk				7		London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	4
10	nnh	hjh			6		Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	7

Add Export into CSV Print