11111

maxdb_stmt_num_rows

Пред.

След.

maxdb_stmt_num_rows

(PECL)maxdb_stmt_num_rows

(no version information, might be only in CVS)stmt->num_rows -- Return the number of rows in statements result set

Description

Procedural style :int maxdb_stmt_num_rows (resource stmt)

Object oriented style (property):class stmt {

int num_rows

}

- Returns the number of rows in the result set.

Return values

- An integer representing the number of rows in result set.

See also

- maxdb_stmt_affected_rows(),

maxdb_prepare(),

maxdb_stmt_store_result()

Example

Пример 1. Object oriented style

<?php

/* Open a connection */

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

/* check connection */

if (maxdb_connect_errno()) {

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

exit();

}

$query = "SELECT zip, name FROM hotel.city ORDER BY name";

if ($stmt = $maxdb->prepare($query)) {

/* execute query */

$stmt->execute();

/* store result */

$stmt->store_result();

printf("Number of rows: %d.\n", $stmt->num_rows);

/* close statement */

$stmt->close();

}

/* close connection */

$maxdb->close();

?>

Пример 2. Procedural style

<?php

/* Open a connection */

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

/* check connection */

if (maxdb_connect_errno()) {

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

exit();

}

$query = "SELECT zip, name FROM hotel.city ORDER BY name";

if ($stmt = maxdb_prepare($link, $query)) {

/* execute query */

maxdb_stmt_execute($stmt);

/* store result */

maxdb_stmt_store_result($stmt);

printf("Number of rows: %d.\n", maxdb_stmt_num_rows($stmt));

/* close statement */

maxdb_stmt_close($stmt);

}

/* close connection */

maxdb_close($link);

?>

- The above examples would produce the following output: 

Number of rows: 25.

Пред.

Начало

След.

maxdb_stmt_init

Уровень выше

maxdb_stmt_param_count 22222

Free Web Hosting