PHP-PostgreSQL-Database-Class
PHP-PostgreSQL-Database-Class copied to clipboard
A PostgreSQL version of https://github.com/ThingEngineer/PHP-MySQLi-Database-Class
PostgresDb
![License](https://poser.pugx.org/seinopsys/postgresql-database-class/license)
This project is a PostgreSQL version of ThingEngineer's MysqliDb Class, that supports the basic functionality and syntax provided by said class, tailored specifically to PostgreSQL.
Installation
This class requires PHP 5.4+ or 7+ to work. You can either place the src/PostgresDb.php
in your project and require/include it, or use Composer (strongly recommended)
composer require seinopsys/postgresql-database-class:^3.0
Usage
$db = new \SeinopSys\PostgresDb($database_name, $host, $username, $password);
For a more in-depth guide see USAGE.md
Upgrading from 2.x
-
Removed deprecated methods
These methods were deprecated in version
2.x
and have been removed in3.x
. Use the renamed variants as indicated below:2.x
3.x
$db->rawQuery(…);
$db->query(…);
$db->rawQuerySingle(…);
$db->querySingle(…);
$db->pdo();
$db->getConnection();
-
Namespace change
As of
3.x
- to comply fully with the PSR-2 coding standard - the class now resides in theSeinopSys
namespace. Here's a handy table to show what you need to change and how:2.x
3.x
$db = new PostgresDb(…);
$db = new \SeinopSys\PostgresDb(…);
$db = new \PostgresDb(…);
$db = new \SeinopSys\PostgresDb(…);
use \PostgresDb;
$db = new PostgresDb(…);use \SeinopSys\PostgresDb;
$db = new PostgresDb(…); -
Internal code structure changes
As of
3.x
allprivate
/protected
methods and properties have dropped the_
prefix, so be sure to update your wrapper class (if you use one).