DEMO SITE v1.7.15

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