Cubrid Functions
PHP Manual

cubrid_prepare

(PHP 4, PHP 5)

cubrid_prepareIs a sort of API which represents SQL statements

Description

int cubrid_prepare ( int $conn_handle , string $prepare_stmt [, int $option ] )

The cubrid_prepare() function is a sort of API which represents SQL statements compiled previously to a given connection handle. This pre-compiled SQL statement will be included in the cubrid_prepare(). Accccordingly, you can use this statement effectively to execute several times repeatedly or to process long data. Only a single statement can be used and a parameter may put a question mark (?) to appropriate area in the SQL statement. Add a parameter when you bind a value in the VALUES cluse of INSERT statement or in the WHERE clause. Note that it is allowed to bind a value to a MARK(?) by the cubrid_bind() only.

Parameters

conn_handle

Connection handle.

prepare_stmt

Prepare query.

option

OID return option CUBRID_INCLUDE_OID.

Return Values

Request handle, if process is successful;

FALSE, if process is unsuccessful.

Examples

Example #1 cubrid_prepare() example

<?php
if ($con) {
$sql "insert into tbl values ( ?,?,?)"
 
$req cubrid_prepare$con$sqlCUBRID_INCLUDE_OID ); 
 
$i 0;
 while ( 
$i ) { 
 
$res cubrid_bind$req1"1""NUMBER"); 
 
$res cubrid_bind$req2"2"); 
 
$res cubrid_bind$req3"04:22:34 PM 08/07/2007"); 
 
$res cubrid_execute$req );  
 
$i $i 1
}} 
?>

See Also


Cubrid Functions
PHP Manual