PDOModel pgsql database connection

Connect to pgsql database

Connect to pgsql database using connect function. You need to pass host/servername, username, password, database-name. Optionally, you can pass charset.

Function Defination

  
                                void function connect($hostName, $userName, $password, $databaseName, $dbType = "mysql", $charset = "utf8");

Parameters Details

Details Type Example
$userName - username of database to connect with string e.g. "root"
$password - password string e.g. ""
$databaseName - database name string e.g. "empDB"
$dbType - type of db string e.g. "pgsql"(default), sqlite, mysql
$charset - character set string e.g. "utf8"

Examples

  
                                $pdomodel = new PDOModel(); //create object of the PDOModel class
                                $pdomodel->connect("localhost", "root", "", "pdocrud","pgsql");//connect to database

More Examples

 
                                $pdomodel->connect("localhost", "root", "", "pdocrud" ,"pgsql","utf8");//connect to database

Result/Output

PGSql Database will be connected

Debug

Option Details Example
print_r($pdomodel->error) Print errors (if any)