<?php
// On suppose que $db est un objet DB valide...
$db->setFetchMode(DB_FETCHMODE_ORDERED);
$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();
print_r($row);
echo 'La colonne a vaut ' . $row[0];
?>
Affichera :
Array
(
[0] => 28
[1] => hi
)
La colonne a vaut 28
<?php
// On suppose que $db est un objet DB valide...
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();
print_r($row);
echo 'La colonne a vaut ' . $row['a'];
?>
Affichera :
Array
(
[a] => 28
[b] => hi
)
La colonne a vaut 28
<?php
// On suppose que $db est un objet DB valide...
$db->setFetchMode(DB_FETCHMODE_OBJECT);
$res =& $db->query('SELECT a, b FROM phptest WHERE a = 28');
$row =& $res->fetchRow();
print_r($row);
echo 'La colonne a vaut ' . $row->a;
?>
Affichera :
stdClass Object
(
[a] => 28
[b] => hi
)
La colonne a vaut 28
<?php
// On suppose que $db est un objet DB valide...
$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 'La colonne a vaut ' . $row->a;
?>
Affichera :
db_row Object
(
[a] => 28
[b] => hi
)
La colonne a vaut 28
<?php
// On suppose que $db est un objet DB valide...
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 'La colonne a vaut ' . $row->a;
?>
Affichera :
SomeResult Object
(
[a] => 28
[b] => hi
)
La colonne a vaut 28
<?php
// On suppose que $db est un objet DB valide...
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 'La colonne a vaut ' . $row->a;
?>
Affichera :
SomeResult Object
(
[a] => 28
[b] => hi
)
La colonne a vaut 28
