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 
1CastilloPamelafspcastilloclas@sodelcars.com11102Sales Rep1San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA3
2BottLarryx2311lbott@classicmodelcars.com51102Sales RepTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan6
3JonesBarrysdfsdx102bjones@classicmodelcars.com101105Sales RepRIO DE JANEIRORUA DONA CECILIA, 35RUA DONA CECILIA, 35 APTO 201Rio de Janeiro20.250-4601
4FixterAndyx101afixter@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC0
5MarshPeterdsfdsx102pmarsh@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC0
6KingTomx103tking@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC0
7NishiMamix101mnishi@classicmodelcars.com51056Sales RepTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan6
8KatoYoshimix102mgerard@classicmodelcars.com51621Sales RepTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan6
9GerardMartinx2312mgerard@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA4
10ssss7London+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7
Search