Project Pages

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_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


obj_insert

Description:

Executes an insert statement which requires no SQL markup and is called from the objSQL class.

  • The table name argument is required.
  • The data argument is required and MUST be a key value pair array with the table column as the key.

See also: Inserting Multiple Rows


Parameters:

mixed obj_insert ( str table, array data )


Returns:

Result resource/object or false on failure.


Example:

<?php

try
{
    
$data = array( "product" => "balloon",
                   
"color"   => "red",
                   
"size"    => "small",
                   
"price"   => 2.50 );
    
    
$rs $dbh->obj_insert"mytable"$data );
    
    if ( 
$dbh->obj_error() )
        throw new 
Exception$dbh->obj_error_message() );
        
    echo 
$rs->obj_affected_rows();
    
}
catch ( 
Exception $e 
{
    
//log error and/or redirect user to error page


?>  

See also: obj_delete, obj_paging, obj_query, obj_select, obj_update


Inserting Multiple Rows:

The obj_insert method allows you to easily insert multiple rows.

  • The data value argument can be a comma delimited string or an array.
  • SQLite3, Firebird and Oracle do not support bulk inserts.
<?php

try
{
    
$data = array( "product" => "balloon,balloon,balloon,balloon",
                   
"color"   => "red,green,blue,pink",
                   
"size"    => "small,small,small,small",
                   
"price"   => 2.50,2.50,2.50,2.50 );
    
    
$rs $dbh->obj_insert"mytable"$data );
    
    if ( 
$dbh->obj_error() )
        throw new 
Exception$dbh->obj_error_message() );
        
    echo 
$rs->obj_affected_rows();
    
}
catch ( 
Exception $e 
{
    
//log error and/or redirect user to error page



try
{
    
$data = array( "product" => array( "balloon","balloon","balloon","balloon" ),
                   
"color"   => array( "red","green","blue","pink" ),
                   
"size"    => array( "small","small","small","small" ),
                   
"price"   => array( 2.50,2.50,2.50,2.50 ) );
    
    
$rs $dbh->obj_insert"mytable"$data );
    
    if ( 
$dbh->obj_error() )
        throw new 
Exception$dbh->obj_error_message() );
        
    echo 
$rs->obj_affected_rows();
    
}
catch ( 
Exception $e 
{
    
//log error and/or redirect user to error page


?>