topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

professional-php-01-class.Widget.php / php



  <?php
  
  class Widget {
    
    private id;
    private name;
    private description;  private hDB;
    private needsUpdating = false;
    
    public function __construct(widgetID) {
      //The widgetID parameter is the primary key of a 
      //record in the database containing the information
      //for this object
  
      //Create a connection handle and store it in a private member variable
      this->hDB = pg_connect('dbname=parts user=postgres');
      if(! is_resource(this->hDB)) {
        throw new Exception('Unable to connect to the database.');
      }
      
      sql = "SELECT \"name\", \"description\" FROM widget WHERE widgetid = widgetID";
      rs = pg_query(this->hDB, sql);
      if(! is_resource(rs)) {
        throw new Exception("An error occurred selecting from the database.");
      }
      
      if(! pg_num_rows(rs)) {
        throw new Exception('The specified widget does not exist!');
      }
          
      data = pg_fetch_array(rs);
      this->id = widgetID;
      this->name = data['name'];
      this->description = data['description'];
      
    }
    
    public function getName() {
      return this->name;
    }
    
    public function getDescription() {
      return this->description;
    }
    
    public function setName(name) {
      this->name = name;
      this->needsUpdating = true;
    }
    
    public function setDescription(description) {
      this->description = description;
      this->needsUpdating = true;
    }
    
    public function __destruct() {
      if(! this->needsUpdating) {
        return;
      }
      
      sql = 'UPDATE "widget" SET ';
      sql .= "\"name\" = '" . pg_escape_string(this->name) . "', ";
      sql .= "\"description\" = '" . pg_escape_string(this->description) . "' ";
      sql .= "WHERE widgetID = " . this->id;
      
      rs = pg_query(this->hDB, sql);
      if(! is_resource(rs)) {
        throw new Exception('An error occurred updating the database');
      }
      
      //You're done with the database.  Close the connection handle.
      pg_close(this->hDB);
    }
  }
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.