DEMO SITE v1.7.15

Join other table Bootstrap 4.5 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

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitleCityPhoneAddressline1Addressline2StateCountryPostalcodeTerritoryOrdering 
1TsengFoon Yueo224ftseng@classicmodelcars.com21143Sales RepBoston+1 617 837 08251550 Court PlaceSuite 102MAUSA02107NA2
2VanaufGeorgex4102gvanauf@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA3
3BondurLouix6493lbondur@classicmodelcars.com21102Sales RepBoston+1 617 837 08251550 Court PlaceSuite 102MAUSA02107NA2
4CastilloPamelax2759pcastillo@classicmodelcars.com21102Sales RepBoston+1 617 837 08251550 Court PlaceSuite 102MAUSA02107NA2
5BottLarryx2311lbott@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5
6JonesBarryx102bjones@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5
7FixterAndyx101afixter@classicmodelcars.com71088Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5
8MarshPeterx102pmarsh@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC0
9KingTomx103tking@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC0
10NishiMamix101mnishi@classicmodelcars.com51056Sales RepTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan4
Search