User Tools

Site Tools


kurs:php_class

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:php_class [2008/12/17 10:40]
mh
kurs:php_class [2014/09/10 21:22] (current)
Line 1: Line 1:
 +[[HRDB.php]]
  
 +
 +==== employees.php ====
 +<​code>​
 +<?​php ​
 +
 +require('​DB-Classes/​Employee.php'​);​
 +
 +$employee = new Employee(100);​
 +
 +//​$employee->​connect();​
 +
 +$employee->​read();​
 +
 +print $employee->​last_name ."​\n";​
 +
 +$employee->​dump();​
 +
 +$new_employee = new Employee(0);​
 +
 +$new_employee->​first_name = '​Mark';​
 +$new_employee->​last_name ​ = '​Hofstetter';​
 +$new_employee->​email ​     = '​jo@eh';​
 +$new_employee->​job_id ​    = '​IT_PROG';​
 +
 +$new_employee->​store();​
 +
 +$new_employee->​dump();​
 +
 +?>             
 +</​code>​
 +
 +==== Employee.php ====
 +<​code>​
 +<?php
 +require('​HRDB.php'​);​
 +class Employee extends HRDB {  ​
 +  ​
 +  function Employee($employee_id) {    ​
 +    i$this->​employee_id = $employee_id;​
 +  }
 +  ​
 +  function read() {    ​
 +    $sql = "​select * from employees where employee_id = :​employee_id";​
 +    $rows = $this->​db_select( $sql, 
 +      ​array('​employee_id'​ => $this->​employee_id,​) );
 +
 + foreach ($rows as $key => $value) {
 +      $key = strtolower($key);​
 +   $this->​{$key} = $value;
 + }
 + // print_r($rows);​
 +  }
 +  ​
 +  function store() {
 +    $sql = "​insert into employees (
 + ​EMPLOYEE_ID,​
 + ​FIRST_NAME,​
 + ​LAST_NAME,​
 + ​EMAIL,​
 + ​HIRE_DATE,​
 + ​JOB_ID) ​
 +values
 + ​(employees_seq.nextval,​
 + :​p_first_name,​
 + :​p_last_name,​
 + :​p_email,​
 + ​sysdate,​
 + :​p_job_id
 +) returning employee_id into :​ret_id";​
 +    $this->​employee_id = 
 +      ​$this->​db_insert( $sql, array(
 + '​first_name'​ => $this->​first_name,​
 +         '​last_name' ​ => $this->​last_name,​
 +         '​email' ​     => $this->​email,​
 +         '​job_id' ​    => $this->​job_id,​
 + )
 + );  ​
 +                                                ​
 +  }                                             
 +                                                ​
 +  function find_by_id($id) {                    ​
 +                                                ​
 +  }                                             
 +                                                ​
 +} // end class Employee ​                        
 +?>                                              ​
 +</​code>​