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();
}

?>