<?php
# include config file
require_once 'config.php';
# include the db client classes file (use own path of the file location)
require_once '../Import.php';
# import MySql client
use Nemiro\Data\MySql as MySql;
# import command class
use Nemiro\Data\DBCommand as 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();
}
?>
|