PHP Doku:: Is a sort of API which represents SQL statements - function.cubrid-prepare.html

Verlauf / Chronik / History: (1) anzeigen

Sie sind hier:
Doku-StartseitePHP-HandbuchFunktionsreferenzDatenbankerweiterungenAnbieterspezifische DatenbankerweiterungenCubridCubrid Funktionencubrid_prepare

Ein Service von Reinhard Neidl - Webprogrammierung.

Cubrid Funktionen

<<cubrid_ping

cubrid_put>>

cubrid_prepare

(PECL CUBRID >= 8.3.0)

cubrid_prepareIs a sort of API which represents SQL statements

Beschreibung

resource cubrid_prepare ( resource $conn_identifier , 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().

Accordingly, 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 clause 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.

Parameter-Liste

conn_identifier

Connection identifier.

prepare_stmt

Prepare query.

option

OID return option CUBRID_INCLUDE_OID.

Rückgabewerte

Request identifier, if process is successful;

FALSE, if process is unsuccessful.

Beispiele

Beispiel #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
}} 
?>

Siehe auch


Keine BenutzerBeiträge.
- Beiträge aktualisieren...



PHP Powered Diese Seite bei php.net
The PHP manual text and comments are covered by the Creative Commons Attribution 3.0 License © the PHP Documentation Group - Impressum - mail("TO:Reinhard Neidl",...)