Please enable JavaScript to view this site.

Navigation: Advanced topics > Programming topics > Database API > Methods

Database API:Select()

Scroll Prev Next More


Retrieves data from the database.


DB::Select($table, $values)
// or
DB::Select($table, $where)



the table from which the data is selected.


an array with values that define the condition of the Select query.


the condition for the Select query.

Return value

An array with the result of the Select query.

Example 1

Retrieve all data from the Cars table where the make is Toyota and the model is RAV4.


$data = array();
$data["make"] = "Toyota";
$data["model"]  = "RAV4";
$rs = DB::Select("Cars", $data );
while( $record = $rs->fetchAssoc() )
    echo $record["id"];
    echo $record["make"];

Example 2

Retrieve all data from the Cars table where the price is less than 20,000.


$rs = DB::Select("Cars", "Price<20000" );
while( $record = $rs->fetchAssoc() )
echo $record["id"];
echo $record["make"];

See also:

QueryResult object: fetchAssoc()

Database API: Exec()

Database API: Query()

Database API: Insert()

Database API: Update()

Database API: Delete()

Database API: PrepareSQL()

QueryResult object: fetchNumeric()

QueryResult object: value()

Using SQL variables

About Database API


Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software