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 
1Ertel CostaTestajec@gmail.com1456TIxSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA9
210RIO DE JANEIRORUA DONA CECILIA, 35RUA DONA CECILIA, 35 APTO 201Rio de Janeiro3320.250-4605
32342sdyxdsdsJjjjhhss@dx.com6Sydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC6
4d344aaadsgfdsf@ndd.com5Tokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan8
5JsjejSfc12sausar08085629298dsfdzzxczxczxzxxMadhya PradeshIndia4801064
610RIO DE JANEIRORUA DONA CECILIA, 35RUA DONA CECILIA, 35 APTO 201Rio de Janeiro3320.250-4605
77London+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA2
8testtesttesttest@test.com711testLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA2
9hhhPeterfdgdgfkovacevicvuk77@rewf.com7466dfgdfgdgfLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA2
10Loco MayoJuan Care Loco2Boston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA7
Search