dokuwiki

This is an old revision of the document!

---

Das Objekt

<?php

class Employee {
  var $id, $last_name, $salary;
  var $db;
  
  private function db_connect() {
    $this->db = oci_connect('hr', 'hr', 'orcl');	
  }
  
  function set_last_name($last_name) {
    $this->last_name = $last_name;
  }
  
  function read() {
    $this->db_connect();
	$q = oci_parse($this->db, 
      "select last_name ln, salary 
	     from employees
         where last_name = :b_last_name");	
    oci_bind_by_name
	   ($q, ":b_last_name", $this->last_name);
    $r = oci_execute($q, OCI_DEFAULT);
    $row = oci_fetch_array($q, OCI_ASSOC);
    $this->salary = $row['SALARY'];
  } 
  
  function store() {}
  
}

<code>