DEMO SITE v1.7.26

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
110310101 2003-01-09 00:00:00Nantes View Edit Remove
211210100 2003-02-11 00:00:00Las Vegas View Edit Remove
311410100 2003-02-11 00:00:00, 10101 2003-01-09…Melbourne View Edit Remove
411910100 2003-02-11 00:00:00, 10101 2003-01-09…Nantes View Edit Remove
512110100 2003-02-11 00:00:00, 10101 2003-01-09…Stavern 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
Add Export into CSV Print Search Execution time: 0.005 sMemory usage: 0.18 MB