• Default theme
• Bootstrap theme
• Minimal theme

• Simple usage
• Base field types
• Uploads demo
• CKEditor and custom
• Simple validation
• Simple relation
• Multiple instances
• Coments like template
• All disabled
• Nested tables
• Dependent dropdowns
• Date range
• Gallery
• One million rows
• Buttons panel
• Join other table
• Subselect and sum row
• Columns and fields
• Tabs
• Column width/cut
• Modal and buttons
• Labels and classes
• Tooltips
• Highlights
• Grid tricks
• JS tricks
• Ajax action

Subselect and sum row Minimal theme

Subselect() will create a new column with some value from other (or current) table. You can use any columns from current tables as parameters. Subselect will be called for each row

<?php
	$xcrud = Xcrud::get_instance();
    $xcrud->table('customers');
    $xcrud->columns('customerName,city,creditLimit'); // specify only some columns
    $xcrud->subselect('Paid','SELECT SUM(amount) FROM payments WHERE customerNumber = {customerNumber}'); // other table
    $xcrud->subselect('Profit','{Paid}-{creditLimit}'); // current table
    $xcrud->sum('creditLimit,Paid,Profit'); // sum row(), receives data from full table (ignores pagination)
    echo $xcrud->render();
?>

Warning: mysqli_connect(): (HY000/2005): Unknown server host 'db.applecorner.com' (-2) in /home/corner/public_html/repair/admin/xcrud/xcrud_db.php on line 50