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
# | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | City | Phone | Addressline1 | Addressline2 | State | Country | Postalcode | Territory | Ordering | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 234 | this is a long long text | c564 | xxx@alfa.com | 3 | NYC | +1 212 555 3000 | 523 East 53rd Street | apt. 5A | NY | USA | 10022 | NA | 4 | View Edit Remove | ||
2 | hello how ar | 456 | koh@gmail.com | 7 | sfas | London | +44 20 7877 2041 | 25 Old Broad Street | 76543 | UK | EC2N 1HN | EMEA | 3 | View Edit Remove | |||
3 | saMIRA | SDSDSD | EEE | SA@GG.COM | 3 | 456 | COMkkk | NYC | +1 212 555 3000 | 523 East 53rd Street | apt. 5A | NY | USA | 10022 | NA | 4 | View Edit Remove |
4 | xxx | sdfsdfsd | 1 | San Francisco | +1 650 219 4782 | 100 Market Street | Suite 300 | CA | USA | 94080 | NA | 5 | View Edit Remove |