Categories > TinyButStrong general >

Connexion/connection Oracle

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
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);
}

?>
By: Skrol29
Date: 2004-11-22
Time: 15:18

Re: Connexion/connection Oracle

Thank you very much CWL.
It will be published for download at the Support page.