DEMO SITE v1.7.20

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

Add Export into CSV Print
Search
#CustomernumberCustomer ordersCity 
115110114 2003-04-01 00:00:00, 10115 2003-04-04…NYC View Edit Remove
2157Allentown View Edit Remove
3161Burlingame View Edit Remove
4175Bridgewater View Edit Remove
5177Kita-ku View Edit Remove
6181NYC View Edit Remove
7186Helsinki View Edit Remove
8187Manchester View Edit Remove
9189Dublin View Edit Remove
10198Brickhaven View Edit Remove