DEMO SITE v1.7.14

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

#OrderdateRequireddateShippeddateStatusCommentsCustomernumber 
109.01.2003 00:00:0021.01.2003 00:00:0012.01.2003 00:00:00ShippedCheck on availability. MACHO rrrr128
210.01.2003 00:00:0018.01.2003 00:00:0014.01.2003 00:00:00Shipped181
329.01.2003 00:00:0007.02.2003 00:00:0002.02.2003 00:00:00Shipped121
411.02.2003 00:00:0021.02.2003 00:00:0012.02.2003 00:00:00ShippedItem 1 / Notr se para145
517.02.2003 00:00:0024.02.2003 00:00:0021.02.2003 00:00:00ShippedGreat Item278
603.03.2003 00:00:0012.03.2003 00:00:0008.03.2003 00:00:00Shipped385
718.03.2003 00:00:0024.03.2003 00:00:0020.03.2003 00:00:00Shipped187
825.03.2003 00:00:0031.03.2003 00:00:0030.03.2003 00:00:00Shipped129
924.03.2003 00:00:0003.04.2003 00:00:0029.03.2003 00:00:00ShippedCustomer requested that ad materials (such as…144
1026.03.2003 00:00:0002.04.2003 00:00:0027.03.2003 00:00:00Shipped124
Add Export into CSV Print
Search