• 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
• Nested tables in tabs
• 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
• Many-to-many relations
• Ordering example
• Select2 usage

Subselect and sum row Default 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,Paid,Profit'); // 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)
    $xcrud->change_type('Profit','price','0',array('prefix'=>'$')); // number format
    echo $xcrud->render();
?>