ovrimos_prepare

ovrimos_prepare -- Prepares an SQL statement

Description

int ovrimos_prepare ( int connection_id, string query)

Ejemplo 1 .

 
?php

 
$conn=ovrimos_connect

 
(

 
"db_host"

 
,

 
"8001"

 
,

 
"admin"

 
,

 
"password")

 
;

 
if

 
($conn!=0

 
)

 
{

 
echo

 
"Connection

 
ok

 
!"

 
;

 
$res=ovrimos_prepare

 
($conn

 
,

 
"select

 
table_id

 
,

 
table_name

 
from

 
sys.tables

 
where

 
table_id=1")

 
;

 
if

 
($res

 
!=

 
0

 
)

 
{

 
echo

 
"Prepare

 
ok

 
!"

 
;

 
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)

 
;

 
}

 
?



This will connect to Ovrimos SQL Server, prepare a statement and the execute it.