ovrimos_prepare

(PHP 4 >= 4.0.3, PHP 5 <= 5.0.5)

ovrimos_prepare — Prepares an SQL statement

说明

int ovrimos_prepare ( int $connection_id , string $query )

Prepares an SQL statement.

参数

connection_id: The Ovrimos connection identifier, returned by ovrimos_connect().
query: The SQL statement.

返回值

Returns a result identifier on success, or FALSE on error.

范例

Example#1 ovrimos_prepare() Example


<?php
$conn=ovrimos_connect("db_host", "8001", "admin", "password");
if ($conn!=0) {
    echo "Connection ok!";
    
    // Prepare the statement
    $res=ovrimos_prepare($conn, "select table_id, table_name
                                  from sys.tables where table_id=1");
    if ($res != 0) {
        echo "Prepare ok!";
        // Execute the prepared statement
        if (ovrimos_execute($res)) {
            echo "Execute ok!\n";
            ovrimos_result_all($res);
        } else {
            echo "Execute not ok!";
        }
        ovrimos_free_result($res);
    } else {
        echo "Prepare not ok!\n";
    }
    ovrimos_close($conn);
}
?>


	PHP5中文手册 ovrimos_num_rows ovrimos_result_all OvrimosSQL PHP Manual ovrimos_prepare (PHP 4 >= 4.0.3, PHP 5 <= 5.0.5) ovrimos_prepare — Prepares an SQL statement 说明 int ovrimos_prepare ( int `$connection_id` , string `$query` ) Prepares an SQL statement. 参数 `connection_id` The Ovrimos connection identifier, returned by ovrimos_connect(). `query` The SQL statement. 返回值 Returns a result identifier on success, or `FALSE` on error. 范例 Example#1 ovrimos_prepare() Example <?php $conn=ovrimos_connect("db_host", "8001", "admin", "password"); if ($conn!=0) { echo "Connection ok!"; // Prepare the statement $res=ovrimos_prepare($conn, "select table_id, table_name from sys.tables where table_id=1"); if ($res != 0) { echo "Prepare ok!"; // Execute the prepared statement if (ovrimos_execute($res)) { echo "Execute ok!\n"; ovrimos_result_all($res); } else { echo "Execute not ok!"; } ovrimos_free_result($res); } else { echo "Prepare not ok!\n"; } ovrimos_close($conn); } ?> ovrimos_num_rows ovrimos_result_all OvrimosSQL PHP Manual