создание и продвижение сайта (вбиваю в ТОП-10, как гвозди)Настройка и сопровождение платной рекламы яндекс.директ

PHP. Руководство по PHP. 2005

maxdb_num_rows

Пред.

След.

maxdb_num_rows

(PECL)maxdb_num_rows --

Gets the number of rows in a result

Description

Procedural style:int maxdb_num_rows (resource result)

Object oriented style (property):class maxdb {

int num_rows

}

Returns the number of rows in the result set.

The use of maxdb_num_rows() depends on whether you use

buffered or unbuffered result sets.

In case you use unbuffered resultsets maxdb_num_rows()

will not correct the correct number of rows until all the rows in the result

have been retrieved.

Возвращаемые значения

Returns number of rows in the result set.

Замечание:

If the number of rows is greater than maximal int value, the number

will be returned as a string.

Смотрите также

maxdb_affected_rows()

maxdb_store_result()

maxdb_use_result()

maxdb_query()

Example

Пример 1. Object oriented style

<?php

$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */

if (maxdb_connect_errno()){

printf("Connect failed: %s\n", maxdb_connect_error());

exit();

}

if ($result = $maxdb->query("SELECT cno, name FROM hotel.customer ORDER BY name")){

/* determine number of rows result set */

$row_cnt = $result->num_rows;

printf("Result set has %d rows.\n", $row_cnt);

/* close result set */

$result->close();

}

/* close connection */

$maxdb->close();

?>

Пример 2. Procedural style

<?php

$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */

if (maxdb_connect_errno()){

printf("Connect failed: %s\n", maxdb_connect_error());

exit();

}

if ($result = maxdb_query($link, "SELECT cno, name FROM hotel.customer ORDER BY name")){

/* determine number of rows result set */

$row_cnt = maxdb_num_rows($result);

printf("Result set has %d rows.\n", $row_cnt);

/* close result set */

maxdb_free_result($result);

}

/* close connection */

maxdb_close($link);

?>

The above examples would produce the following output: 

Result set has 15 rows.

Пред.

Начало

След.

maxdb_num_fields

Уровень выше

maxdb_options

Отвечу на любые вопросы. С уважением, Дмитрий Владимирович.

Ваше письмо×
⇪
Free Web Hosting