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 | 112 | Las Vegas | View Edit Remove | |
2 | 114 | 10103 2003-01-29 00:00:00, 10104 2003-01-31 | Melbourne | View Edit Remove |
3 | 119 | Nantes | View Edit Remove | |
4 | 125 | Warszawa | View Edit Remove | |
5 | 128 | Frankfurt | View Edit Remove | |
6 | 129 | San Francisco | View Edit Remove | |
7 | 131 | NYC | View Edit Remove | |
8 | 141 | Madrid | View Edit Remove | |
9 | 145 | Kobenhavn | View Edit Remove | |
10 | 146 | Lyon | View Edit Remove |