<div style="color:#ffffff;font-size: 20px;">Table Joins & Relations</div> - Bootstrap 4.5 theme - eXtended CRUD & Data Management System

Table Joins & Relations
Bootstrap 4.5 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

refresh Print Export into CSV

Add

#	Lastname	Firstname	Extension	Email	Officecode	Reportsto	Jobtitle	City	Phone	Addressline1	Addressline2	State	Country	Postalcode	Territory	Ordering	Actions
1	Vanauf	George N	x4103	gvanauf@classicmodelcars.com	3	1143	Sales Rep	NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	4	View Edit Remove
2	Bondur	Loui	x6496	lbondur@classicmodelcars.com	4	1102	Sales Rep	Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	5	View Edit Remove
3	Hernandez	Gerardo	x2028	gerard.hernandez@myoffice.com	7	1102	Sales Rep	London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2	View Edit Remove
4	Castillo	Pamela	x2759	pcastillo@classicmodelcars.com	4	1102	Sales Rep	Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	5	View Edit Remove
5	Bott	Larry	x2311	lbott@classicmodelcars.com	7	1102	Sales Rep	London	+44 20 7877 2041	25 Old Broad Street	Level 7		UK	EC2N 1HN	EMEA	2	View Edit Remove
6	Fixter	Andy	x101	afixter@classicmodelcars.com	6	1088	Sales Rep	Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	0	View Edit Remove
7	Marsh	Peter	x102	pmarsh@classicmodelcars.com	6	1088	Sales Rep	Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	0	View Edit Remove
8	King	Tom	x103	tking@classicmodelcars.com	6	1088	Sales Rep	Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	0	View Edit Remove
9	Gerard	Martinm	x2312	mgerard@classicmodelcars.com	4	1102	Sales Rep	Paris	+33 14 723 4404	43 Rue Jouffroy D'abbans			France	75017	EMEA	5	View Edit Remove
10	Peter	Joe	x5800	g@m.com	6		DR	Sydney	+61 2 9264 2451	5-11 Wentworth Avenue	Floor #2		Australia	NSW 2010	APAC	0	View Edit Remove

1
2

Search