DEMO SITE v1.7.26

Many-to-many relations Bootstrap 4.5 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
Actions
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
Search Execution time: 0.007 sMemory usage: 0.19 MB