文字

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

说明

过程化风格

bool maxdb_stmt_store_result ( resource $stmt )

面向对象风格

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.

返回值

成功时返回 TRUE , 或者在失败时返回 FALSE

范例

Example #1 面向对象风格

<?php

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


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 )) {

   

   
$stmt -> execute ();

   

   
$stmt -> store_result ();

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

   

   
$stmt -> free_result ();

   

   
$stmt -> close ();
}


$maxdb -> close ();
?>

Example #2 过程化风格

<?php

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


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 )) {

   

   
maxdb_stmt_execute ( $stmt );

   

   
maxdb_stmt_store_result ( $stmt );

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

   

   
maxdb_stmt_free_result ( $stmt );

   

   
maxdb_stmt_close ( $stmt );
}


maxdb_close ( $link );
?>

以上例程的输出类似于:

Number of rows: 25.

参见

  • maxdb_prepare() - Prepare an SQL statement for execution
  • maxdb_stmt_result_metadata() - Returns result set metadata from a prepared statement
  • maxdb_fetch() - 别名 maxdb_stmt_fetch
上一篇: 下一篇: