Prepares an SQL statement

ovrimos_num_rows
ovrimos_result_all
Ovrimos SQL Functions
PHP Manual

# ovrimos_prepare

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

ovrimos_prepare — Prepares an SQL statement

### Description

int ovrimos_prepare ( int `$connection_id` , string `$query` )

Prepares an SQL statement.

### Parameters

`connection_id`

  The Ovrimos connection identifier, returned by ovrimos_connect().

`query`

  The SQL statement.

### Return Values

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

### Examples

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
Ovrimos SQL Functions
PHP Manual