Project Pages

objSQL Home
Freshmeat
PHP Classes
SourceForge
Downloads
Archived Documentation

DB Connection Methods

objSQL
obj_close

Error Handling Methods

obj_error
obj_error_message

Statement Methods

obj_delete
obj_insert
obj_paging
obj_query
obj_select
obj_update

Resultset Methods

obj_affected_rows
obj_fetch_assoc
obj_fetch_num
obj_fetch_object
obj_field
obj_free_result
obj_num_fields
obj_num_rows

Prepared Statement Methods

obj_bind
obj_close_statement
obj_execute
obj_free_statement
obj_prepare_statement

Transaction Methods

obj_commit
obj_rollback
obj_savepoint
obj_transaction

Utility Methods

obj_escape
obj_info
obj_row_count

objSQL

Description:

Opens a new connection to a named database server.

  • 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, oracle, pgsql, sqlite3 or sqlsrv. Enter pdo:cubrid, pdo:mysql, pdo:oracle, pdo:pgsql, pdo:sqlite3, pdo:sqlsrv for PDO drivers. For MariaDB, enter mysql or pdo:mysql as the driver.
  • Firebird does not allow you to change the default port.
  • objSQL performs an internal validation before it attempts to connect to a database by verifying the database type. A failure triggers an exception.

Parameters:

Comma delimited string

mixed objSQL ( str driver, str host, str user, str pass, str database[, int port ] )

Array

mixed objSQL ( array ( str driver, str host, str user, str pass, str database[, int port ] ) )

Returns:

Connection resource or object.

Example:

<?php 

/** 

Drivers 

CUBRID: cubrid or pdo:cubrid 
Firebird: firebird or pdo:firebird 
MySQL/MariaDB: mysql or pdo:mysql 
Oracle: oracle or pdo:oracle 
Postgres: pgsql or pdo:pgsql 
SQLite3: sqlite3 or pdo:sqlite3 
SQL Server: sqlsrv or pdo:sqlsrv 

*/ 

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

?>

See also: obj_close