# include the db client classes file (use own path of the file location)
require_once '../Import.php';
# import MySql client
use Nemiro\Data\MySql;
# import command class
use Nemiro\Data\DBCommand;
# best practice is to use 'try { } catch { }' blocks
try {
# create client instance
$client = new MySql();
# create a new command with parameters
$client->Command = new DBCommand('INSERT INTO users (username, date_created) VALUES (@username, @date_created)');
# @username and @date_created is parameters name,
# you can add a values for this parameters
$client->Command->Parameters->Add('@date_created')->SetValue(date('Y-m-d H-i-s'));
$client->Command->Parameters->Add('@username')->SetValue('anyname');
# execute the command
$newId = $client->ExecuteScalar();
echo 'New row added. ID = ' . $newId . '<br />';
# you can change the parameters and execute the command again
$client->Command->Parameters['@username']->SetValue('newValue');
$newId = $client->ExecuteScalar();
echo 'New row added. ID = ' . $newId . '<br />';
# and again
$client->Command->Parameters['@username']->SetValue('123');
$client->Command->Parameters['@date_created']->SetValue(date('Y-m-d H-i-s'));
$newId = $client->ExecuteScalar();
echo 'New row added. ID = ' . $newId . '<br />';
} catch (Exception $ex) {
echo 'Error: ' . $ex->getMessage();
}
