Compzone.Org :: Podręcznik PHP :: db2_execute

Podręcznik PHP
Poprzedni		Następny

db2_execute

(PECL)

db2_execute -- Executes a prepared SQL statement

Opis

bool db2_execute ( resource stmt [, array parameters] )

db2_execute() executes an SQL statement that was prepared by db2_prepare().

If the SQL statement returns a result set, for example, a SELECT statement or a CALL to a stored procedure that returns one or more result sets, you can retrieve a row as an array from the stmt resource using db2_fetch_assoc(), db2_fetch_both(), or db2_fetch_array(). Alternatively, you can use db2_fetch_row() to move the result set pointer to the next row and fetch a column at a time from that row with db2_result().

Refer to db2_prepare() for a brief discussion of the advantages of using db2_prepare() and db2_execute() rather than db2_exec().

Parametry

stmt: A prepared statement returned from db2_prepare().
parameters: An array of input parameters matching any parameter markers contained in the prepared statement.

Zwracane wartości

Zwraca TRUE w przypadku sukcesu, FALSE w przypadku porażki.

Przykłady

Przykład 1. Preparing and executing an SQL statement with parameter markers

The following example prepares an INSERT statement that accepts four parameter markers, then iterates over an array of arrays containing the input values to be passed to db2_execute().

<?php

                $pet = array(0, 'cat', 'Pook', 3.2);

                
$insert = 'INSERT INTO animals (id, breed, name, weight)


                    VALUES (?, ?, ?, ?)';

                
$stmt = db2_prepare($conn, $insert);

                if ($stmt) {

                    $result = db2_execute($stmt, $pet);

                    if ($result) {

                        print "Successfully added new pet.";


                    }

                }
?>

Powyższy przykład wyświetli:

Successfully added new pet.

Przykład 2. Calling a stored procedure with an OUT parameter

The following example prepares a CALL statement that accepts one parameter marker representing an OUT parameter, binds the PHP variable $my_pets to the parameter using db2_bind_param(), then issues db2_execute() to execute the CALL statement. After the CALL to the stored procedure has been made, the value of $num_pets changes to reflect the value returned by the stored procedure for that OUT parameter.

<?php

                $num_pets = 0;
$res = db2_prepare($conn, "CALL count_my_pets(?)");

                $rc = db2_bind_param($res, 1, "num_pets", DB2_PARAM_OUT);
$rc = db2_execute($res);

                print "I have $num_pets pets!";

                ?>

Powyższy przykład wyświetli:

I have 7 pets!

Patrz także

db2_exec()

db2_fetch_array()

db2_fetch_assoc()

db2_fetch_both()

db2_fetch_row()

db2_prepare()

db2_result()

Poprzedni	Spis treści	Następny
db2_exec	Początek rozdziału	db2_fetch_array