PHP manuál : function.maxdb-stmt-store-result.html


maxdb_stmt_store_result

maxdb_stmt_store_result

(PECL)

maxdb_stmt_store_result

(no version information, might be only in CVS)

maxdb->store_result -- Transfers a result set from a prepared statement

Description

Procedural style:

bool maxdb_stmt_store_result ( resource stmt )

Object oriented style (method):

class maxdb {

object store_result ( void )

}

maxdb_stmt_store_result() has no functionally effect and should not be used for retrieving data from MaxDB server.

Return values

Returns TRUE on success or FALSE on failure.

Example

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 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();
?>

Example 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 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);
?>

The above examples would produce the following output:

Number of rows: 25.

webmailWebmail


Zaujímavé linky



inzerat.sk - bezplatna inzercia, inzeraty, autobazar, reality

Slovak companies and manufacturers directory

Katalog slovenskych firiem a vyrobkov

Suppliers and products directory
 created by RealData (2005)
 www.realdata.sk  
Všetky ceny sú s 20% DPH.    Konverzny kurz: 1 EUR = 30,1260 SKK
Ceny nezahŕňajú ročný udržiavací poplatok za doménu, ktorý platíme jednotlivým správcom domén.

stránka vygenerovaná za 0.295s

webhosting zaregistrujte si domenu