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
11' View Edit Remove
2119Nantes View Edit Remove
3121Stavern View Edit Remove
412410168 2003-10-28 00:00:00, 10170 2003-11-04…San Rafael View Edit Remove
5128Frankfurt View Edit Remove
6129San Francisco View Edit Remove
7131NYC View Edit Remove
8145Kobenhavn View Edit Remove
9146Lyon View Edit Remove
10148Singapore View Edit Remove
Add Export into CSV Print Search