Posted By

osccar on 03/20/12

Tagged

class
data

Versions (?)

Last Edited at 03/20/12 07:04am

Statistics

Viewed 918 times

Favorited by 1 user(s)

Related snippets

DataObject class

/ Published in: PHP

Abstract class from which other classes can be derived to handle database access and data retrieval.
Constants for database connection (DB_DSN, DB_USERNAME, etc.) must be set in another php file (eg. config.php)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

abstract class DataObject
{
  protected $data = array();
 
  public function __construct( $data )
  {
    foreach ( $data as $key => $value ) {
        if ( array_key_exists( $key, $this->data ) )
          $this->data[$key] = $value;
    }
  }
 
  public function getValue( $field )
  {
    if ( array_key_exists( $field, $this->data ) )
      return $this->data[$field];
    else
      exit( "Field not found" );
  }
 
  public function getValueEncoded( $field )
  {
    return htmlspecialchars( $this->getValue( $field ) );
  }
 
  protected function connect()
  {
    try {
      $conn = new PDO( DB_DSN, DB_USERNAME, DB_PWD );
      $conn->setAttribute( PDO::ATTR_PERSISTENT, TRUE );
      $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
    }
    catch ( PDOException $e) {
      exit( 'Connection failed: '. $e->getMessage() );
    }
 
    return $conn;
  }
 
  protected function disconnect( $conn )
  {
    $conn = NULL;
  }
}