DEMO SITE v1.7.31

Many-to-many relations Minimal 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

#CustomernumberCustomer ordersCity
1119Nantes View Edit Remove
2121Stavern View Edit Remove
3124San Rafael View Edit Remove
4128Frankfurt View Edit Remove
5129San Francisco View Edit Remove
6131NYC View Edit Remove
7141Madrid View Edit Remove
8144Lula View Edit Remove
9145Kobenhavn View Edit Remove
10146Lyon View Edit Remove
Add Export into CSV Print Search