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.

Syntax

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

Arguments

$table

the table from which the data is selected.

$values

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

$where

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