DEMO SITE v1.7.20

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 
1112Las Vegas View Edit Remove
211410103 2003-01-29 00:00:00, 10104 2003-01-31…Melbourne View Edit Remove
3119Nantes View Edit Remove
4125Warszawa View Edit Remove
5128Frankfurt View Edit Remove
6129San Francisco View Edit Remove
7131NYC View Edit Remove
8141Madrid View Edit Remove
9145Kobenhavn View Edit Remove
10146Lyon View Edit Remove
Search