文字

maxdb_stmt_param_count

maxdb_stmt::param_count

(PECL maxdb >= 1.0)

maxdb_stmt_param_count -- maxdb_stmt::param_countReturns the number of parameter for the given statement

说明

过程化风格

int maxdb_stmt_param_count ( resource $stmt )

面向对象风格

int $maxdb_stmt->param_count;

maxdb_stmt_param_count() returns the number of parameter markers present in the prepared statement.

返回值

returns an integer representing the number of parameters.

范例

Example #1 面向对象风格

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


if ( maxdb_connect_errno ()) {
   
printf ( "Connect failed: %s\n" maxdb_connect_error ());
   exit();
}

if (
$stmt  $maxdb -> prepare ( "SELECT name FROM hotel.city WHERE name=? OR state=?" )) {

   
$marker  $stmt -> param_count ;
   
printf ( "Statement has %d markers.\n" $marker );

   

   
$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();
}

if (
$stmt  maxdb_prepare ( $link "SELECT name FROM hotel.city WHERE name=? OR state=?" )) {

   
$marker  maxdb_stmt_param_count ( $stmt );
   
printf ( "Statement has %d markers.\n" $marker );

   

   
maxdb_stmt_close ( $stmt );
}


maxdb_close ( $link );
?>

以上例程的输出类似于:

Statement has 2 markers.

参见

  • maxdb_prepare() - Prepare an SQL statement for execution
上一篇: 下一篇: