DEMO SITE v1.7.31

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
Actions
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