Major modifications… tested with SambaPOS 4.1.82 and SQL Express 2014.
dbops.zip (8.1 KB)
// v3.2 (2015-05-13) QMcKay
// - adding setting for default_charset using UTF-8
// v3.1 (2015-04-13) QMcKay
// - changed PHP filename to dbops.php
// - added auto-create WorkPeriod
// - added auto-create Menu
// - added more error checking
// - added ExecQuery function to encapsulate Query Execution and error handling
// - added separate functions (ops) and split into separate files:
// - dbops_deleteproducts.php
// - dbops_deletetransactions.php
// - dbops_importproducts.php
// - dbops_readproducts.php
// - dbops_functions.php
Set your configuration options in file: dbops.php
No other files need edits.
Open Web Browser and go to address http://localhost/dbops.php
Select desired operation from the links at the top of the page…
