Table Joins & Relations
Default theme

Table Joins & Relations

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();	
?>

Employees

Add Export into CSV Print

1
2
3

Search

#	Lastname	Firstname	Extension	Email	Officecode	Reportsto	Jobtitle	City	Phone	Addressline1	Addressline2	State	Country	Postalcode	Territory	Ordering	Actions
1	Bondur2544	javier	2425	'	2	1056	Sale Manager (EMEA)	Boston	+1 215 837 0825	1550 Court Place	Suite 102	MA	USA	02107	NA	3	View Edit Remove
2	Bow	Anthony	x5428	anthony.bow@myoffice.com	6	1056	Sales Manager (NA)	Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	4	View Edit Remove
3	Jennings	Leslie	x3291	ljennings@classicmodelcars.com	2	1143	Sales Rep	Boston	+1 215 837 0825	1550 Court Place	Suite 102	MA	USA	02107	NA	3	View Edit Remove
4	Thompson	Leslie	x4065	lthompson@classicmodelcars.com	7	1143	Sales Rep	London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2	View Edit Remove
5	Firrelli	Julie	x2173	jfirrelli@classicmodelcars.com	3	1143	Sales Rep	NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	1	View Edit Remove
6	Patterson	Steve	x4334	spatterson@classicmodelcars.com	2	1143	Sales Rep	Boston	+1 215 837 0825	1550 Court Place	Suite 102	MA	USA	02107	NA	3	View Edit Remove
7	Tsengchu	Foon Yue	o224	ftseng@classicmodelcars.com	3	1143	Sales Rep	NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	1	View Edit Remove
8	Vanauf	George	x4102	gvanauf@classicmodelcars.com	3	1143	Sales Rep	NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	1	View Edit Remove
9	Bondur	Loui	x6493	lbondur@classicmodelcars.com	4	1102	Sales Rep	Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	5	View Edit Remove
10	Hernandez	Gerard	x2028	ghernande@classicmodelcars.com	4	1102	Sales Rep	Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	5	View Edit Remove

?>