PHP Object Framework (PHPOF) Manual

DBTable::BasicSearch

Perform a search in a database table for exact matches

Description

DB_result DBTable::BasicSearch ( string search_column, string search_for [ , string order_by ] )

BasicSearch returns a database result object of type DB_result when searching for search_for in column search_column.

If order_by is supplied, the results will be ordered by the given column.

Assuming some rows are returned, you can iterate through them using DB_result::fetchIntoObject.

Example 1


$employee_records->BasicSearch('firstname','Bob');

See also DBTable::BasicSearch_Paged, DBTable::BasicSearchLike, DBTable::BasicSearchNot.