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 
1kaizerjosekjkjkerlbott@classicmodelcars.com71102pedreiroLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7
2KingTom7898x103tking@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7
3NishiMamix105323mnishi@classicmodelcars.com51056Sales RepTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan3
4GerardMartinmx2312mgerard@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA4
5sdsdds3NYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA1
6AAA2Boston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA6
7blanchjordis1122pepe@pep.com2111CEOBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA6
Search