Table Join

Allows you to join other tables. Only INNER JOIN supported. Keys in all joined tables must exist and be unique.

public function table_join()
{
  $xcrud = get_xcrud();
  $xcrud->table('employees');
  $xcrud->join('officeCode','offices','officeCode'); // ... INNER JOIN offices ON employees.officeCode = offices.officeCode ...
  
  //this line loads the <script> below it from a view
  $data['script'] = view('scripts', ['code' => 'table_join']);
  
  <script>
      $(document).ready(function() {
          $(".xcrud-list").tableHeadFixer({"head" : false, "left" : 2}); 
      });
  </script>
    
  $data['content'] = $xcrud->render();
  
  return view('demos', $data);
}