PHP DevCenter
oreilly.comSafari Books Online.Conferences.


Implementing MVC in PHP: The Model
Pages: 1, 2, 3, 4


FR_User is a basic data object in the users table. I created a single table called fr_users in a MySQL database called framework:

CREATE TABLE `fr_users` (
  `userID`    int(11) unsigned NOT NULL auto_increment,
  `email`    char(45) NOT NULL         default '',
  `password` char(15) NOT NULL         default '',
  `fname`    char(30) NOT NULL         default '',
  `lname`    char(30) NOT NULL         default '',
  `posted`   datetime NOT NULL         default '0000-00-00 00:00:00',
  `status`   enum('active','disabled') default 'active',
  PRIMARY KEY  (`userID`),
  UNIQUE KEY `email` (`email`),
  KEY `posted` (`posted`),
  KEY `status` (`status`)

-- Special user for anonymous/not-logged-in users
INSERT INTO `fr_users` VALUES (0,'','','Anonymous','Coward', \
    '2005-06-05 11:33:56','disabled');

  * FR_User
  * @author Joe Stump <>
  * @copyright Joe Stump <>
  * @license
  * @package Framework
  * @filesource

  * FR_User
  * Base user object.
  * @author Joe Stump <>
  * @package Framework
  class FR_User extends FR_Object_DB
      public $userID;
      public $email;
      public $password;
      public $fname;
      public $lname;
      public $posted;

      public function __construct($userID=null)

          if ($userID === null) {
              $session = FR_Session::singleton(); 
              if (!is_numeric($session->userID)) {
                  $userID = 0; 
              } else {
                  $userID = $session->userID;

          $sql = "SELECT *
                  FROM fr_users
                  WHERE userID=".$userID." AND 

          $result = $this->db->getRow($sql);
          if (!PEAR::isError($result) && is_array($result)) {

      public function __destruct()


Notice that the constructor looks around for user IDs in various forms. If it receives a user ID, the class fetches the given user ID. If it does not receive a user ID, it checks the session; if a user ID is not present, it assumes the user is not logged in and it loads the special anonymous user record.

The special anonymous user allows me to have a special user for people not logged in. It allows me to easily and quickly check whether a user is logged in:


  if ($this->user->userID > 0) {
      // User is logged in


I would have much rather made FR_User a singleton; however, PHP5 does not allow a child class to have a private constructor when the parent class, FR_Object_DB, has a public constructor.

Pages: 1, 2, 3, 4

Next Pagearrow

Valuable Online Certification Training

Online Certification for Your Career
Earn a Certificate for Professional Development from the University of Illinois Office of Continuing Education upon completion of each online certificate program.

PHP/SQL Programming Certificate — The PHP/SQL Programming Certificate series is comprised of four courses covering beginning to advanced PHP programming, beginning to advanced database programming using the SQL language, database theory, and integrated Web 2.0 programming using PHP and SQL on the Unix/Linux mySQL platform.

Enroll today!

Sponsored by: