Many-to-many relations Default theme
Many-to-many (FK) relations can be displayed as simple multiselect fields. This method changes only fk table.
HIDE CODE
<?php $xcrud = Xcrud::get_instance(); $xcrud->table('customers'); $xcrud->columns('customerNumber,Customer orders,city'); $xcrud->fk_relation('Customer orders','customerNumber','customers_orders_fk','customer_id','order_id','orders','orderNumber',array('orderNumber','orderDate')); echo $xcrud->render(); ?>
Customers
# | Customernumber | Customer orders | City | |
---|---|---|---|---|
1 | 151 | 10114 2003-04-01 00:00:00, 10115 2003-04-04 | NYC | View Edit Remove |
2 | 157 | Allentown | View Edit Remove | |
3 | 161 | Burlingame | View Edit Remove | |
4 | 175 | Bridgewater | View Edit Remove | |
5 | 177 | Kita-ku | View Edit Remove | |
6 | 181 | NYC | View Edit Remove | |
7 | 186 | Helsinki | View Edit Remove | |
8 | 187 | Manchester | View Edit Remove | |
9 | 189 | Dublin | View Edit Remove | |
10 | 198 | Brickhaven | View Edit Remove |