SunshinePHP Developer Conference 2015

maxdb_stmt_store_result

maxdb_stmt::store_result

(PECL maxdb >= 1.0)

maxdb_stmt_store_result -- maxdb_stmt::store_resultTransfers a result set from a prepared statement

Descrição

Estilo procedural

bool maxdb_stmt_store_result ( resource $stmt )

Estilo orientado à objeto

object maxdb_stmt::store_result ( void )

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

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top