Developers

Developers only section

This section will help you as a PHP developer to understand the code architecture and how to use the functions to achieve the maximum use of this software.

with more than 150 ready made functions, covering everything you can think you will ever need in an ERP software.

System Standards

• Time

// we use the standard UNIX time integer value in our DB
// we don't use mysql timestamp
// if you want to regsiter a current time
// either use our time function
$add['register_date']=$mktime;
// or use php standard function
$add['register_date']=time();
// call back the time as you wish
echo $mb->getDateOnly($DBdate) // 23/09/2021
echo $mb->getDateTime($DBdate) // 23/09/2021 11:49 AM
// or use the standard date function as you wish
echo date("d/m/Y h:i A", $DBdate);

• Primary Key

// primary key in all tables is (( id )) and its Auto Incremental
// you don't need to include it within your insertion query

• Sanitize

// all data sanitized and formatted before inserting into DB
$global_key = filter_var($_GET['key'], FILTER_SANITIZE_STRING);

• PDO Features

// we use PDO features, all sql query request will be prepaired before execution
// no SQL injection and XSS attack is possible, your website will be safe.
$query = $pdo->prepare($sql);