PEAR Manual
PrevNext

Introduction - Query

Introduction - Query -- Performing a queries

Description

To perform a query against a database you have to use the function query(), that takes the query string as an argument. On failure you get a DB_Error object, check it with DB::isError(). On success you get DB_OK or when you set a SELECT-statment a DB_result object.

Example 21-1. Doing a query

<?php
// Once you have a valid DB object...
$sql = "select * from clients";

$result =& $db->query($sql);

// Always check that $result is not an error
if (DB::isError($result)) {
    die ($result->getMessage());
}
....
?>

query() can be used instead of prepare() and execute(), if you set the $params parameter and your query uses placeholders.

Example 21-2. Using query in prepare/execute mode with a scalar parameter

<?php
// Once you have a valid DB object...
$sql  = 'select * from clients where clientid = ?';
$data = 53;

$result =& $db->query($sql, $data);

// Always check that $result is not an error
if (DB::isError($result)) {
    die ($result->getMessage());
}
....
?>

Example 21-3. Using query in prepare/execute mode with an array parameter

<?php
// Once you have a valid DB object...
$sql  = 'select * from clients where clientid = ? and statusid = ?';
$data = array(53, 4);

$result =& $db->query($sql, $data);

// Always check that $result is not an error
if (DB::isError($result)) {
    die ($result->getMessage());
}
....
?>
PrevHomeNext
Introduction - PortabilityUpIntroduction - Prepare & Execute