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 | Tseng | Foon Yue | o225 | ftseng@classicmodelcars.com | 2 | 1143 | Sales Rep | Boston | +1 215 837 0825 | 1550 Court Place | Suite 102 | MA | USA | 02107 | NA | 4 | View Edit Remove |
2 | Bondur | Loui | x6493 | lbondur@classicmodelcars.com | 4 | 1102 | Sales Rep | Paris | +33 14 723 4404 | 43 Rue Jouffroy D'abbans | France | 75017 | EMEA | 1 | View Edit Remove | ||
3 | Hernandez | Gerard | x2028 | ghernande@classicmodelcars.com | 4 | 1102 | Sales Rep | Paris | +33 14 723 4404 | 43 Rue Jouffroy D'abbans | France | 75017 | EMEA | 1 | View Edit Remove | ||
4 | Castillo | Pamela2 | x2759 | pcastillo@classicmodelcars.com | 4 | 1102 | Sales Rep | Paris | +33 14 723 4404 | 43 Rue Jouffroy D'abbans | France | 75017 | EMEA | 1 | View Edit Remove | ||
5 | Bott | Larry | x2311 | lbott@classicmodelcars.com | 7 | 1102 | Sales Rep | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 0 | View Edit Remove | |
6 | Jones | Barry | x102 | bjones@classicmodelcars.com | 7 | 1102 | Sales Rep | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 0 | View Edit Remove | |
7 | Fixter | Andy | x101 | afixter@classicmodelcars.com | 6 | 1088 | Sales Rep | Sydney | +61 2 9264 2451 | 5-11 Wentworth Avenue | Floor #2 | Australia | NSW 2010 | APAC | 2 | View Edit Remove | |
8 | Marsh123 | Peter | x102 | pmarsh@classicmodelcars.com | 6 | 1088 | Sales Rep | Sydney | +61 2 9264 2451 | 5-11 Wentworth Avenue | Floor #2 | Australia | NSW 2010 | APAC | 2 | View Edit Remove | |
9 | King | Tom | x103 | tking@classicmodelcars.com | 6 | 1088 | Sales Rep | Sydney | +61 2 9264 2451 | 5-11 Wentworth Avenue | Floor #2 | Australia | NSW 2010 | APAC | 2 | View Edit Remove | |
10 | Nishi | Mami | x101 | mnishi@classicmodelcars.com | 5 | 1056 | Sales Rep | Tokyo | +81 33 224 5000 | 4-1 Kioicho | Chiyoda-Ku | Japan | 102-8578 | Japan | 6 | View Edit Remove |