downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
search for in the  

<ovrimos_num_rowsovrimos_result_all>
Last updated: Thu, 26 Jun 2008

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);
}
?>



add a noteadd a note User Contributed Notes
Prepares an SQL statement
There are no user contributed notes for this page.




<ovrimos_num_rowsovrimos_result_all>
Last updated: Thu, 26 Jun 2008
show source | credits | sitemap | contact | advertising | mirror sites
Copyright © 2001-2005 The PHP Group
All rights reserved.
This unofficial mirror is operated at: http://phpbuilder.com/
Last updated: Tue Nov 1 20:20:59 2005 EST
Columns / Articles | Tips / Quickies | News | News Linking and RSS Feeds | Shared Code Library
Mail Archives | Support / Discussion Forums | Get Started! Links | Contribute! | Docs