By: CWL
Date: 2004-11-22
Time: 15:03
|
Connexion/connection Oracle
Ci-joint les méthodes nécessaires pour la connexion Oracle ( testé sur 9i ):
Below, methods needed to access Oracle database ( tested on 9i ):
<?php
/*
$connect=OCILogon("user", "password", "database");
$TBS = new clsTinyButStrong ;
$TBS->LoadTemplate('tbs_fr_exemples_data.htm') ;
$TBS->MergeBlock('blk1',$connect,"select annee, mois, jour, heure, nb_profil from table") ;
OCILogoff($connect) ;
$TBS->Show() ;
*/
function tbsdb_oci8_open(&$Source, &$Query) {
$statement = OCIParse($Source, $Query);
OCIExecute($statement, OCI_DEFAULT);
return $statement;
}
function tbsdb_oci8_fetch(&$Rs) {
OCIFetchInto($Rs, $row, OCI_ASSOC+OCI_RETURN_NULLS);
if (isset($row))
return $row;
else
return false;
}
function tbsdb_oci8_close(&$Rs) {
OCIFreeStatement($Rs);
}
?>
|
|