PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Codreanu Florin  >  Oracle PHP Class Model  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/markdown
Description: example
Class: Oracle PHP Class Model
Create model classes stored in Oracle using OCI
Author: By
Last change: change tags to markdown
Date: 1 year ago
Size: 3,726 bytes
 

Contents

Class file image Download
/*
create this table before tu run the script
CREATE TABLE EMPLOYEE
(EMPNO NUMBER NOT NULL,
FIRSTNAME VARCHAR(30) NOT NULL,
LASTNAME VARCHAR(30) NOT NULL,
BIRTHDATE DATE NOT NULL,
HIREDATE DATE NOT NULL,
JOB VARCHAR(30) NOT NULL,
SALARY NUMBER(7,2)
)
*/
require_once('OCIdb.php');
class EmployeeModel extends OCIdb{
        public function setSource(){
                $this->_table_name='EMPLOYEE';
        }


       public function initialize()
        {
                // Skips fields/columns on all operations: SLECT/INSERT/UPDATE operations
                $this->setDataFormat('dd.mm.yyyy');
        }
}


$user='xxxx';
$password='yyyyyy';
$ident='ip_or_computer_name:1523/THE_SID';
$dbOCIPHP=new OCIdb();
if(!$dbOCIPHP->sql_connect($user,$password,$ident)){
        die('No database connection! Reason: '.$dbOCIPHP->_error_message);
        }



$EmployeeController=$dbOCIPHP->loadModel('EmployeeModel');


//insert a record
$EmployeeController->empno=123;
$EmployeeController->firstname ='John';
$EmployeeController->lastname ='Doe';
$EmployeeController->birthdate ='07.06.1978';
$EmployeeController->hiredate ='01.11.2019';
$EmployeeController->job  ='programmer';
$EmployeeController->salary  =2200;
if(!$EmployeeController->create('commit')){
    echo "Error! Reason:".$EmployeeController->_error_message;
}

//insert a new record
$EmployeeController->reset();
$EmployeeController->empno=124;
$EmployeeController->firstname ='Mary';
$EmployeeController->lastname ='Smith';
$EmployeeController->birthdate ='26.10.1992';
$EmployeeController->hiredate ='01.11.2019';
$EmployeeController->job  ='programmer';
$EmployeeController->salary  =2200;
if(!$EmployeeController->create('commit')){
    echo "Error! Reason:".$EmployeeController->_error_message;
}


//insert a new record
$EmployeeController->reset();
$EmployeeController->empno=121;
$EmployeeController->firstname ='Helen';
$EmployeeController->lastname ='Richards';
$EmployeeController->birthdate ='31.01.1972';
$EmployeeController->hiredate ='27.01.2018';
$EmployeeController->job  ='chief';
$EmployeeController->salary  =3500;
if(!$EmployeeController->create('commit')){
    echo "Error! Reason:".$EmployeeController->_error_message;
}

//find one record and update them
if($EmployeeController->findFirst([
            'conditions' => 'empno=:empno',
            'bind'       => [
                    ":empno" => 124
                    ]
            ])){//exista deja
                $EmployeeController->job  ='senior programmer';
                $EmployeeController->salary  =2500;

                if(!$EmployeeController->update('commit')){
                        echo "Error! Reason:".$EmployeeController->_error_message;
                    }
            }

//find all records upon conditions
$EmployeeController->find([
            'conditions' => 'job like :job',
            'bind'       => [
                    ":job" => '%programmer%'
                    ]
            ]);

while($EmployeeController->rowExists){
    $EmployeeController->salary  +=200;
    if(!$EmployeeController->update('commit')){
            echo "Error! Reason:".$EmployeeController->_error_message;
        }
    $EmployeeController->next();
}


//use transactions
$EmployeeController->beginTransaction('SAVEPOINT1');
$thereAreErrors=false;
while($EmployeeController->rowExists){
    $EmployeeController->salary  +=200;
    if(!$EmployeeController->update('nocommit')){$thereAreErrors=true;}
    $EmployeeController->next();
}
if(!$thereAreErrors){
$EmployeeController->rollback('SAVEPOINT1');
}else{
$EmployeeController->commit();
}
For more information send a message to info at phpclasses dot org.