Many-to-many relations Default theme

Many-to-many (FK) relations can be displayed as simple multiselect fields. This method changes only fk table.

<?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 
110310125 2003-05-21 00:00:00, 10127 2003-06-03…Nantes
211210101 2003-01-09 00:00:00, 10102 2003-01-10…Las Vegas
311410337 2004-11-21 00:00:00, 10338 2004-11-22…Melbourne
411910100 2003-01-06 00:00:00, 10101 2003-01-09…Nantes
512110101 2003-01-09 00:00:00, 10102 2003-01-10…Stavern
612410100 2003-01-06 00:00:00, 10101 2003-01-09…San Rafael
712510103 2003-01-29 00:00:00, 10105 2003-02-11…Warszawa
812810100 2003-01-06 00:00:00, 10101 2003-01-09…Frankfurt
912910100 2003-01-06 00:00:00, 10103 2003-01-29…San Francisco
1013110100 2003-01-06 00:00:00, 10101 2003-01-09…NYC
Add Export into CSV PrintSearch

 
Buy it nowfor only $13