Podręcznik PEAR

Download Documentation

View this page in	Last updated: Mon, 02 Jul 2007
English \| Dutch \| French \| German \| Hungarian \| Japanese \| Polish \| Russian \| Spanish \| Plain HTML

DB_common::setFetchMode()

DB_common::setFetchMode() -- Sets the default fetch mode

Synopsis

void setFetchMode (integer $fetchmode [, string $object_class = stdClass])

Opis

Sets the default fetch mode used by fetch*() and get*() methods.

Parametr

integer $fetchmode

DB_FETCHMODE_ORDERED, DB_FETCHMODE_ASSOC or DB_FETCHMODE_OBJECT.

See the Examples section, below, for more information.

string $object_class

This parameter is for use when $fetchmode is set to DB_FETCHMODE_OBJECT.

You can set this parameter to DB_row, which then causes the resulting data to populate a new instance of a DB_row object.

Zwracana wartość

void - nothing is returned on success or a DB_Error object on failure

Wyjątki

Tabela 35-1. Możliwe wartości PEAR_Error

Error code	Error message	Reason	Solution
`NULL`	invalid fetchmode mode	The given fetch mode does not exists or is not implement in your DB version.	Check writing of the argument and your used version of DB.

Uwagi

Ta funkcja nie może być wywołana statycznie.

Przykład

Przykład 35-1. DB_FETCHMODE_ORDERED (default)

Causes ordered arrays to be returned. The order is taken from the select statement.


<?php
// Once you have a valid DB object named $db...
$db->setFetchMode(DB_FETCHMODE_ORDERED);

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row[0];
?>

Output:

Array
(
    [0] => 28
    [1] => hi
)
Column a is 28

Przykład 35-2. DB_FETCHMODE_ASSOC

Makes associative arrays, with the column names as the array keys.


<?php
// Once you have a valid DB object named $db...
$db->setFetchMode(DB_FETCHMODE_ASSOC);

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row['a'];
?>

Output:

Array
(
    [a] => 28
    [b] => hi
)
Column a is 28

Przykład 35-3. DB_FETCHMODE_OBJECT

Returns objects with column names as properties.


<?php
// Once you have a valid DB object named $db...
$db->setFetchMode(DB_FETCHMODE_OBJECT);

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row->a;
?>

Output:

stdClass Object
(
    [a] => 28
    [b] => hi
)
Column a is 28

Przykład 35-4. DB_FETCHMODE_OBJECT and DB_row

If setFetchMode()'s optional $object_class parameter is set to DB_row, DB_row objects are returned.


<?php
// Once you have a valid DB object named $db...
$db->setFetchMode(DB_FETCHMODE_OBJECT, 'DB_row');

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row->a;
?>

Output:

db_row Object
(
    [a] => 28
    [b] => hi
)
Column a is 28

Przykład 35-5. DB_FETCHMODE_OBJECT with your own object in PHP 4


<?php
// Once you have a valid DB object named $db...

class SomeResult {
    function SomeResult($data) {
        foreach ($data as $key => $value) {
            $this->$key = $data[$key];
        }
    }
}

$db->setFetchMode(DB_FETCHMODE_OBJECT, 'SomeResult');

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row->a;
?>

Output:

SomeResult Object
(
    [a] => 28
    [b] => hi
)
Column a is 28

Przykład 35-6. DB_FETCHMODE_OBJECT with your own object in PHP 5


<?php
// Once you have a valid DB object named $db...

class SomeResult {
    public $row_data;
    function __construct($data) {
        $this->row_data = $data;
    }
    function __get($variable) {
        return $this->row_data[$variable];
    }
}

$db->setFetchMode(DB_FETCHMODE_OBJECT, 'SomeResult');

$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();

print_r($row);
echo 'Column a is ' . $row->a;
?>

Output:

SomeResult Object
(
    [a] => 28
    [b] => hi
)
Column a is 28

DB_common::rollback() (Previous)

(Next) DB_common::setOption()

Download Documentation	Last updated: Mon, 02 Jul 2007
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
There are no user contributed notes for this page.