DEMO SITE v1.7.20

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 
1234this is a long long textc564xxx@alfa.com3NYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4 View Edit Remove
2hello how ar456koh@gmail.com7sfasLondon+44 20 7877 204125 Old Broad Street76543UKEC2N 1HNEMEA3 View Edit Remove
3saMIRASDSDSDEEESA@GG.COM3456COMkkkNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4 View Edit Remove
4xxxsdfsdfsd1San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA5 View Edit Remove
Search