ovrimos_fetch_row
(PHP 4 >= 4.0.3, PHP 5 <= 5.0.5)
ovrimos_fetch_row — Fetches a row from the result set
Описание
bool ovrimos_fetch_row
( int
$result_id
[, int $how
[, int $row_number
]] )Fetches a row from the result set. Column values should be retrieved with other calls.
Список параметров
-
result_id -
A result identifier, returned by ovrimos_execute() or ovrimos_exec().
-
how -
Determines how the rows are fetched. This can be one of the following strings (case is not significant):
Option Notes Next Forward direction from current position. This is the default value. Prev Backward direction from current position. First Forward direction from the start. Last Backward direction from the end. Absolute Absolute position from the start. Requires rownumber. -
rownumber -
The row number, first one is 0. Only needed when
howis set to Absolute.
Возвращаемые значения
Возвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки.
Примеры
Пример #1 A fetch row example
<?php
$conn = ovrimos_connect("remote.host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res=ovrimos_exec($conn, "select table_id, table_name from sys.tables");
if ($res != 0) {
echo "Statement ok!";
if (ovrimos_fetch_row($res, "First")) {
$table_id = ovrimos_result($res, 1);
$table_name = ovrimos_result($res, 2);
echo "table_id=" . $table_id . ", table_name=" . $table_name . "\n";
if (ovrimos_fetch_row($res, "Next")) {
$table_id = ovrimos_result($res, "table_id");
$table_name = ovrimos_result($res, "table_name");
echo "table_id=" . $table_id . ", table_name=" . $table_name . "\n";
} else {
echo "Next: error\n";
}
} else {
echo "First: error\n";
}
ovrimos_free_result($res);
}
ovrimos_close($conn);
}
?>
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Ovrimos SQL
- ovrimos_close
- ovrimos_commit
- ovrimos_connect
- ovrimos_cursor
- ovrimos_exec
- ovrimos_execute
- ovrimos_fetch_into
- ovrimos_fetch_row
- ovrimos_field_len
- ovrimos_field_name
- ovrimos_field_num
- ovrimos_field_type
- ovrimos_free_result
- ovrimos_longreadlen
- ovrimos_num_fields
- ovrimos_num_rows
- ovrimos_prepare
- ovrimos_result_all
- ovrimos_result
- ovrimos_rollback
Коментарии
404 Not Found