DEMO SITE v1.7.26

Auto refresh NEW Semantic UI theme

Auto refresh grid after a configured amount of time. For this case 15 seconds

HIDE CODE
<?php
    // Get an instance of the Xcrud class
	$xcrud = Xcrud::get_instance();	

    // Set the table to work with
	$xcrud->table("orderdetails");

    // Define which columns to display in the table
    $xcrud->columns("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total");

    // Define which fields are available for data entry or editing
    $xcrud->fields("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total");

    $xcrud->relation("officeCode","offices","officeCode","city");
    // Hide the 'extension' field when the 'officeCode' IN '7,3,4'(London, NYC, Paris)
    $xcrud->set_formular("total","{quantityOrdered}+{priceEach}","onmouseout"); //{lastName}+''+{firstName}@gmail.com
    $xcrud->set_routine("autorefresh","15");//number of seconds
    /*$xcrud->set_routine("save","5");//save after ever of seconds
    $xcrud->set_routine("query","5","update x set y =1");*/

    $xcrud->readonly("total");
    $xcrud->label("total","Total");
    // Render the xcrud instance to display the table and form
    echo $xcrud->render();	
?>

Warning: Undefined variable $bool in /home/mixcprassd/public_html/backendDemo/xcrud/xcrud.php on line 1165

Orderdetails

#OrdernumberProductcodeOrderlinenumberQuantityorderedPriceeachTotal
Actions
110100S18_1749435341360 View Edit Remove
210100S18_224825355.090 View Edit Remove
310100S18_440942275.460 View Edit Remove
410100S24_396914935.290 View Edit Remove
510101S18_2325425108.120 View Edit Remove
610101S18_2795126167.090 View Edit Remove
710101S24_193734532.530 View Edit Remove
810101S24_202224644.350 View Edit Remove
910102S18_134223995.550 View Edit Remove
1010102S18_136714143.130 View Edit Remove
Search Execution time: 0.042 sMemory usage: 0.18 MB