Project Pages

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

Statement Argument Methods

obj_cols
obj_data
obj_limit
obj_offset
obj_sort_order
obj_table
obj_where

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_order_by

Description:

Sets the order_by argument for the obj_select and obj_paging methods and is called directly from the objSQL class.

  • The order_by argument is required.

Parameters:

void obj_order_by ( str order_by )


Example:

<?php 

try 

    
$dbh->obj_table"mytable" ); 
    
$dbh->obj_cols"color,size,price" );
    
$dbh->obj_order_by"color" );
    
    
$rs $dbh->obj_select(); 
     
    if ( 
$dbh->obj_error() ) 
        throw new 
Exception$dbh->obj_error_message() ); 
         
    while ( 
$obj $rs->obj_fetch_object() )  
    { 
        
printf "%s %s %s \n"$obj->color,  
                                
$obj->size,  
                                
$obj->price ); 
    } 
     
    
$rs->obj_free_result(); 

catch ( 
Exception $e )  

    
//log error and/or redirect user to error page 
}  

?> 

See also: obj_cols, obj_data, obj_limit, obj_offset, obj_sort_order, obj_table, obj_where