Overview

Packages

  • objSQL

Documentation

  • objSQL Connection
  • objSQL Error Handling
  • General Queries
  • Prepared Statements
  • Transactions
  • Resultset Methods
  • Helper Method - Select Query
  • Helper Method - Update Query
  • Helper Method - Insert Query
  • Helper Method - Delete Query
  • Helper Method - Paging Query
  • Utility Methods

Classes

  • mysql_connection
  • mysql_prepare
  • mysql_resultset
  • mysql_statement
  • mysql_transaction
  • objSQL
  • pgsql_connection
  • pgsql_prepare
  • pgsql_resultset
  • pgsql_statement
  • pgsql_transaction
  • sqlite3_connection
  • sqlite3_prepare
  • sqlite3_resultset
  • sqlite3_statement
  • sqlite3_transaction
  • sqlsrv_connection
  • sqlsrv_prepare
  • sqlsrv_resultset
  • sqlsrv_statement
  • sqlsrv_transaction
  • Overview
  • Package
  • Class
  • Tree

objSQL Error Handling

Error handling is specific to each database type and is dependant on the current connection instance.

  • Call the obj_error() method to test for an error.

Returns: False if no error or true on the last error.

  • Call the obj_error_message() method to display or log an error message.

Returns: Verbose error message on the last error or null if no error.

<?php

try
{
    
$dbh = new objSQL( "mysql,localhost,root,pass,mydb,3306" );
            
    if ( 
error_get_last() !== null )
        throw new 
Exception( error_get_last()['message'] );
            
    
$rs = $dbh->obj_query( "delete from mytable where id=1" );
        
    if ( 
$dbh->obj_error() )
        throw new 
Exception( $dbh->obj_error_message() );
           
    echo 
$rs->obj_affected_rows();    
        
    
$dbh->obj_close();  
}
catch ( 
Exception $e ) 
{
    
//log error and/or redirect user to error page
}

?>   

Downloads | Support | Contact

objSQL 3.0.0 API documentation generated by ApiGen 2.8.0

Documentation licensed under a Creative Commons Attribution 3.0 Unported License.