maxdb_stmt_store_result
maxdb_stmt::store_result
(PECL maxdb >= 1.0)
maxdb_stmt_store_result -- maxdb_stmt::store_result — Transfers a result set from a prepared statement
Descrição
Estilo procedural
maxdb_stmt_store_result
( resource
$stmt
) : boolEstilo orientado à objeto
maxdb_stmt::store_result
( void
) : object
maxdb_stmt_store_result() has no functionally effect and should not be used for retrieving data from MaxDB server.
Valor Retornado
Retorna TRUE em caso de sucesso ou FALSE em caso de falha.
Exemplos
Exemplo #1 Estilo orientado à objeto
<?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 name, zip 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);
/* free result */
$stmt->free_result();
/* close statement */
$stmt->close();
}
/* close connection */
$maxdb->close();
?>
Exemplo #2 Estilo procedural
<?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 name, zip 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));
/* free result */
maxdb_stmt_free_result($stmt);
/* close statement */
maxdb_stmt_close($stmt);
}
/* close connection */
maxdb_close($link);
?>
O exemplo acima irá imprimir algo similar à:
Number of rows: 25.
Veja Também
- maxdb_prepare() - Prepare an SQL statement for execution
- maxdb_stmt_result_metadata() - Returns result set metadata from a prepared statement
- maxdb_fetch() - Sinônimo de maxdb_stmt_fetch
add a note
User Contributed Notes
There are no user contributed notes for this page.
