cubrid_prepare

(PECL CUBRID >= 8.3.0)
Prepare a SQL statement for execution
resource cubrid_prepare ( resource $conn_identifier, string $prepare_stmt [, int $option = 0 ] )

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 using the cubrid_bind() function only.

Parameters:
conn_identifier

Connection identifier.

prepare_stmt

Prepare query.

option

OID return option CUBRID_INCLUDE_OID.

Returns:

Request identifier, if process is successful;

FALSE, if process is unsuccessful.

Examples:
cubrid_prepare() example
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
 
$sql = <<<EOD
SELECT g.event_code, e.name 
FROM game g 
JOIN event e ON g.event_code=e.code 
WHERE host_year = ? AND event_code NOT IN (SELECT event_code FROM game WHERE host_year=?) GROUP BY event_code;
EOD;
 
$req = cubrid_prepare($conn$sql);
 
cubrid_bind($req, 1, 2004);
cubrid_bind($req, 2, 2000);
cubrid_execute($req);
 
$row_num = cubrid_num_rows($req);
printf("There are %d event that exits in 2004 olympic but not in 2000. For example:\n\n"$row_num);
 
printf("%-15s %s\n""Event_code""Event_name");
printf("----------------------------\n");
 
$row = cubrid_fetch_assoc($req);
printf("%-15d %s\n"$row["event_code"], $row["name"]);
$row = cubrid_fetch_assoc($req);
printf("%-15d %s\n"$row["event_code"], $row["name"]);
 
cubrid_disconnect($conn);
?>

The above example will output:

There are 27 event that exits in 2004 olympic but not in 2000. For example:

Event_code      Event_name
----------------------------
20063           +91kg
20070           64kg
See also:

cubrid_execute() -

cubrid_bind() -

doc_php
2025-01-10 15:47:30
Comments
Leave a Comment

Please login to continue.