DEMO SITE v1.7.31

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

Add
#CustomernumberCustomer ordersCity
Actions
11' View Edit Remove
2119Nantes View Edit Remove
3121Stavern View Edit Remove
4124San Rafael View Edit Remove
5128Frankfurt View Edit Remove
6129San Francisco View Edit Remove
7131NYC View Edit Remove
8141Madrid View Edit Remove
9144Lula View Edit Remove
10145Kobenhavn View Edit Remove
showing_records 1 to 10 of 135
Search