PHP Classes

File: examples/dbo_classes/company_office.dbo.class.php

Recommend this page to a friend!
  Classes of Oleg Zorin   DataBase Object (DBO)   examples/dbo_classes/company_office.dbo.class.php   Download  
File: examples/dbo_classes/company_office.dbo.class.php
Role: Example script
Content type: text/plain
Description: CompanyOffice DBO class (demo)
Class: DataBase Object (DBO)
Manipulate database table records
Author: By
Last change:
Date: 7 years ago
Size: 1,290 bytes
 

Contents

Class file image Download
<?php
   
/*
    * DBO for company office table
    */
   
   
class CompanyOffice extends OZ\DBO {
       
/* put all fields from DB table here (except id field) */
       
public $companyID;
        public
$name;
        public
$address;

       
/* put other fields here */
       
public $offices = array(); /* list of company offices from `company_office` database table */
       
        /* table definition*/
       
public static $definition = array(
           
'table' => 'company_office', /* table name */
           
'id' => 'officeID', /* id field name */
           
'fields' => array(
               
'companyID' => array('type' => 'numeric', 'required' => true), /* name field definition: numeric and required field */
               
'name' => array('type' => 'text', 'required' => true, 'unique' => true), /* name field definition: text, required and unique field */
               
'address' => array('type' => 'text') /* address field definition: text field */
           
)
        );
       
        function
__construct($id = 0) {
           
parent::__construct($id);
        }
       
       
/* if you are using cache for company data */
       
function save() {
           
/* clear cache for company with $this->companyID */
           
parent::save();
        }
       
       
/* if you are using cache for company data */
       
function delete() {
           
/* clear cache for company with $this->companyID */
           
parent::delete();
        }
       
    }