objSQL Database Connection Instance
To connect to a database, create an objSQL() instance.
- The database connection information can be entered as a comma delimited string or an array.
- Database types are case-insensitive but must be entered as: cubrid, mysql, pgsql, sqlite3, sqlsrv or pdo:cubrid, pdo:mysql, pdo:pgsql, pdo:sqlite3, pdo:sqlsrv for PDO drivers. Enter mysql or pdo:mysql as the driver for MariaDB.
- objSQL performs an internal validation before it attempts to connect to a database by verifying the database type. A failure triggers an error.
Returns: Connection resource/object or false on failure.
- Call obj_close() to close the current connection instance.
Returns: True on success or false on failure.
<?php
/**
Drivers
CUBRID: cubrid or pdo:cubrid
MySQL/MariaDB: mysql or pdo:mysql
Postgres: pgsql or pdo:pgsql
SQLite3: sqlite3 or pdo:sqlite3
SQL Server: sqlsrv or pdo:sqlsrv
usage: str - $connection = "dbtype,localhost,username,password,database,port";
usage: array - $connection = array( "dbtype","localhost","username","password","database","port" );
*/
try
{
$dbh = new objSQL( "mysql,localhost,root,pass,mydb,3306" );
if ( error_get_last() !== null )
throw new Exception( error_get_last()['message'] );
//Query block
$dbh->obj_close();
}
catch ( Exception $e )
{
echo $e->getMessage();
}
try
{
$dbh = new objSQL( "pdo:mysql,localhost,root,pass,mydb,3306" );
if ( error_get_last() !== null )
throw new Exception( error_get_last()['message'] );
//Query block
$dbh->obj_close();
}
catch ( Exception $e )
{
echo $e->getMessage();
}
?>