Warning: include(../../script/pdocrud.php): Failed to open stream: No such file or directory in /var/sentora/hostdata/digjainwi/public_html/allsanginfodev/demo/pages/field-formula.php on line 1

Warning: include(../../script/pdocrud.php): Failed to open stream: No such file or directory in /var/sentora/hostdata/digjainwi/public_html/allsanginfodev/demo/pages/field-formula.php on line 1

Warning: include(): Failed opening '../../script/pdocrud.php' for inclusion (include_path='.:/opt/remi/php81/root/usr/share/pear:/opt/remi/php81/root/usr/share/php:/usr/share/pear:/usr/share/php') in /var/sentora/hostdata/digjainwi/public_html/allsanginfodev/demo/pages/field-formula.php on line 1
PDOCrud - CRUD application generator for PHP and Mysql, Pgsql and Sqlite database.

Field Formula Apply formula for fields before insert/update operation (added in version 2.5)

You can apply basic formula to change value of the field before insert/update operation dynamically. It can be done using the callback function also but this function is added to provide more convenient way to do same. It also helps to set the value to NULL for empty values to help to enter data in case of database restriction for e.g. saving NULL for datetime for empty values.

  
                                    $pdocrud = new PDOCrud();
                                     // format field to 2 decimal point
                                    $pdocrud->fieldFormula("tax", "formula",array("type" =>"round","decimalpoint"=>2));
                                    // format field to 2 decimal point
                                    $pdocrud->fieldFormula("product_discount", "formula",array("type" =>"number_format","decimalpoint"=>2));
                                    // get ceil value of field
                                    $pdocrud->fieldFormula("product_price", "formula",array("type" =>"ceil"));
                                    //get floor value of field
                                    $pdocrud->fieldFormula("product_sell_price", "formula",array("type" =>"floor"));
                                    //string type - adding prefix of sku always and checking for duplicate i.e. string already have sku or not
                                    $pdocrud->fieldFormula("product_id","string",array("type" =>"prefix","str"=>"SKU_","duplicate"=>true));
                                    //make product name first letter upper case
                                    $pdocrud->fieldFormula("product_name", "string",array("type" =>"uppercase"));
                                    //setting value to NULL if empty
                                    $pdocrud->fieldFormula("added_Date", "string",array("type" =>"null"));
                                     
                                    echo $pdocrud->dbTable("products")->render();
                            

Formula based field content formatting


Fatal error: Uncaught Error: Class "PDOCrud" not found in /var/sentora/hostdata/digjainwi/public_html/allsanginfodev/demo/pages/field-formula.php:66 Stack trace: #0 {main} thrown in /var/sentora/hostdata/digjainwi/public_html/allsanginfodev/demo/pages/field-formula.php on line 66