DEMO SITE v1.7.24

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 
1124San Rafael View Edit Remove
2125Warszawa View Edit Remove
3128Frankfurt View Edit Remove
4129San Francisco View Edit Remove
5131NYC View Edit Remove
6141Madrid View Edit Remove
7144Luleå View Edit Remove
814510108 2003-03-01 00:00:00, 10111 2003-03-25…Kobenhavn View Edit Remove
9146Lyon View Edit Remove
10148Singapore View Edit Remove
Search