cubrid_fetch_object
(PECL CUBRID >= 8.3.0)
cubrid_fetch_object — Fetche the next row and returns it as an object
Description
$result
[, string $class_name
[, array $params
[, int $type
]]] )This function returns an object with the column names of the result set as properties. The values of these properties are extracted from the current row of the result.
Parameters
-
result
-
result
comes from a call to cubrid_execute() -
class_name
-
The name of the class to instantiate. If not specified, a stdClass (stdClass is PHP's generic empty class that's used when casting other types to objects) object is returned.
-
params
-
An optional array of parameters to pass to the constructor for
class_name
objects. -
type
-
Type can only be CUBRID_LOB, this parameter will be used only when you need to operate the lob object.
Return Values
An object, when process is successful.
FALSE
, when there are no more rows; NULL, when process is unsuccessful.
Examples
Example #1 cubrid_fetch_object() example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$res = cubrid_execute($conn, "SELECT * FROM code");
var_dump(cubrid_fetch_object($res));
// if you want to operate LOB object, you can use cubrid_fetch_object($res, CUBRID_LOB)
class demodb_code {
public $s_name = null;
public $f_name = null;
public function toString() {
var_dump($this);
}
}
var_dump(cubrid_fetch_object($res, "demodb_code"));
// if you want to operate LOB object, you can use cubrid_fetch_object($res, "demodb_code", CUBRID_LOB)
class demodb_code_construct extends demodb_code {
public function __construct($s, $f) {
$this->s_name = $s;
$this->f_name = $f;
}
}
var_dump(cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name')));
// if you want to operate LOB object, you can use cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name'), CUBRID_LOB)
var_dump(cubrid_fetch_object($res));
cubrid_close_request($res);
cubrid_disconnect($conn);
?>
The above example will output:
object(stdClass)#1 (2) { ["s_name"]=> string(1) "X" ["f_name"]=> string(5) "Mixed" } object(demodb_code)#1 (2) { ["s_name"]=> string(1) "W" ["f_name"]=> string(5) "Woman" } object(demodb_code_construct)#1 (2) { ["s_name"]=> string(6) "s_name" ["f_name"]=> string(6) "f_name" } object(stdClass)#1 (2) { ["s_name"]=> string(1) "B" ["f_name"]=> string(6) "Bronze" }
See Also
- cubrid_execute() - Execute a prepared SQL statement
- cubrid_fetch() - Fetch the next row from a result set
- cubrid_fetch_array() - Fetch a result row as an associative array, a numeric array, or both
- cubrid_fetch_assoc() - Return the associative array that corresponds to the fetched row
- cubrid_fetch_row() - Return a numerical array with the values of the current row
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- CUBRID
- cubrid_affected_rows
- cubrid_client_encoding
- cubrid_close
- cubrid_data_seek
- cubrid_db_name
- cubrid_errno
- cubrid_error
- cubrid_fetch_array
- cubrid_fetch_assoc
- cubrid_fetch_field
- cubrid_fetch_lengths
- cubrid_fetch_object
- cubrid_fetch_row
- cubrid_field_flags
- cubrid_field_len
- cubrid_field_name
- cubrid_field_seek
- cubrid_field_table
- cubrid_field_type
- cubrid_list_dbs
- cubrid_num_fields
- cubrid_ping
- cubrid_query
- cubrid_real_escape_string
- cubrid_result
- cubrid_unbuffered_query
Коментарии
404 Not Found