<?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 client for PostgreSQL
use Nemiro\Data\PgSql;
# import command class
use Nemiro\Data\DBCommand;
# best practice is to use 'try { } catch { }' blocks
try {
# create client instance
$client = new PgSql();
# create a new command with parameters
$client->Command = new DBCommand('INSERT INTO users (username, date_created) VALUES (@username, @date_created) RETURNING id_users;');
# @username and @date_created is parameters name,
# you can add a values for this parameters
$client->Command->Parameters->Add('@username')->SetValue('anyname');
$client->Command->Parameters->Add('@date_created')->SetValue(date('d.m.Y'));
# 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('d.m.Y'));
$newId = $client->ExecuteScalar();
<?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 client for PostgreSQL
use Nemiro\Data\PgSql;
# import command class
use Nemiro\Data\DBCommand;
# import parameters type list
use Nemiro\Data\DBParameterType;
# best practice is to use 'try { } catch { }' blocks
try {
# create client instance
$client = new PgSql();
# you can specify the text of the query into the Command property
$client->Command = 'SELECT * FROM users';
# and execute the query by any method:
# $client->GetRow(); # return single row
# $client->GetTable(); # return all rows
# $client->GetData(); # return array tables
# for example, get all rows
$table = $client->GetTable();
var_dump($table);
# you can build a query from the input parameters,
# but you will need to check the type and value of incoming data
# it is bad practice
$client->Command = 'DELETE FROM users WHERE id_users = ' . (int) $_GET['id'];
# it is best to use parameterized queries
$client->Command = new DBCommand('DELETE FROM users WHERE id_users = @id_users');
<?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 client for PostgreSQL
use Nemiro\Data\PgSql;
# import command class
use Nemiro\Data\DBCommand;
# best practice is to use 'try { } catch { }' blocks
try {
# create client instance with connection settings from config.php
$client = new PgSql();
# create client instance with specifed connection settings
$client2 = new PgSql('localhost', 'test', '5QKfHhB323EM', 'test_db', 5432);
# create command
$command = new DBCommand('SELECT * FROM users LIMIT @limit');
$command->Parameters->Add('@limit', 10);
# set command to client
$client->Command = $command;
# execute the command and get table
$table = $client->GetTable();
if (count($table) > 0) {
# output columns of the table
$columns = array_keys($table[0]);
echo '<table>';
echo '<thead><tr>';
foreach ($columns as $column) {
echo '<td>' . $column . '</td>';
}
