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

#	Lastname	Firstname	Extension	Email	Officecode	Reportsto	Jobtitle	City	Phone	Addressline1	Addressline2	State	Country	Postalcode	Territory	Ordering
1	DxF	John		fsdf@fsf.gfw	3		xyxyxyxy	NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	18
2	Williams	Jane			3			NYC	+1 212 555 3000	523 East 53rd Street	apt. 5A	NY	USA	10022	NA	18

Add Export into CSV Print