Nested tables Default theme

Example of table nesting

HIDE CODE

<?php  
	$xcrud = Xcrud::get_instance();
    $xcrud->table('orders');
    
    $orderdetails = $xcrud->nested_table('products','orderNumber','orderdetails','orderNumber'); // 2nd level
    $orderdetails->columns('productCode,quantityOrdered,priceEach');
    $orderdetails->fields('productCode,quantityOrdered,priceEach');
    
    $customers = $xcrud->nested_table('customers','customerNumber','customers','customerNumber'); // 2nd level 2
    $customers->columns('customerName,city,country');
    
    $products = $orderdetails->nested_table('orderdetails','productCode','products','productCode'); // 3rd level
    
    $productLines = $products->nested_table('productLines','productLine','productlines','productLine'); // 4th level
    
    echo $xcrud->render();
?>

Orders

#	Orderdate	Requireddate	Shippeddate	Status	Comments	Customernumber
1	09.01.2003 00:00:00	21.01.2003 00:00:00	12.01.2003 00:00:00	Shipped	Check on availability. MACHO rrrr	128
2	10.01.2003 00:00:00	18.01.2003 00:00:00	14.01.2003 00:00:00	Shipped		181
3	29.01.2003 00:00:00	07.02.2003 00:00:00	02.02.2003 00:00:00	Shipped		121
4	11.02.2003 00:00:00	21.02.2003 00:00:00	12.02.2003 00:00:00	Shipped	Item 1 / Notr se para	145
5	17.02.2003 00:00:00	24.02.2003 00:00:00	21.02.2003 00:00:00	Shipped	Great Item	278
6	03.03.2003 00:00:00	12.03.2003 00:00:00	08.03.2003 00:00:00	Shipped		385
7	18.03.2003 00:00:00	24.03.2003 00:00:00	20.03.2003 00:00:00	Shipped		187
8	25.03.2003 00:00:00	31.03.2003 00:00:00	30.03.2003 00:00:00	Shipped		129
9	24.03.2003 00:00:00	03.04.2003 00:00:00	29.03.2003 00:00:00	Shipped	Customer requested that ad materials (such as…	144
10	26.03.2003 00:00:00	02.04.2003 00:00:00	27.03.2003 00:00:00	Shipped		124

Add Export into CSV Print