Many-to-many relations

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
Actions
110310180 2003-11-11 00:00:00Nantes View Edit Remove
2112Las Vegas View Edit Remove
3114Melbourne View Edit Remove
4119Nantes View Edit Remove
5121Stavern View Edit Remove
6124San Rafael View Edit Remove
7125Warszawa View Edit Remove
8128Frankfurt View Edit Remove
9129San Francisco View Edit Remove
10131NYC View Edit Remove
Search