PHP Classes

File: resources/class.Users.php

Recommend this page to a friend!
  Classes of Bryan   PHP Class Generator Bryan Version   resources/class.Users.php   Download  
File: resources/class.Users.php
Role: Sample output
Content type: text/plain
Description: User Management
Class: PHP Class Generator Bryan Version
Generate classes to manipulate MySQL table rows
Author: By
Last change: add path to this file
Date: 13 years ago
Size: 5,342 bytes
 

Contents

Class file image Download
<?php /* * * ------------------------------------------------------- * CLASSNAME: Users * GENERATION DATE: 20.08.2010 * CLASS FILE: E:\bryan\xampp\htdocs\bryClasses\sql_class_generator_081910/generated_classes/class.Users.php * FOR MYSQL TABLE: users * FOR MYSQL DB: msison * ------------------------------------------------------- * * CODE GENERATED BY: BRYAN JAYSON TAN * DATE EDIT: MARCH 26 2010 * ADDED METHOD: init(), selectOne(), selectAll(), toString() * EDITED METHOD: update(), delete() * DATE EDIT: JULY 31 2010 * ADDED METHOD: doCount() * DATE EDIT: AUGUST 19, 2010 * EDITED METHOD: selectOne, selectAll,and doCount make them static * ------------------------------------------------------- * */ include_once(dirname(__FILE__)."/class.database.php"); // ********************** // CLASS DECLARATION // ********************** class Users { // class : begin // ********************** // ATTRIBUTE DECLARATION // ********************** private $id; // KEY ATTR. WITH AUTOINCREMENT private $firstname; // (normal Attribute) private $lastname; // (normal Attribute) private $username; // (normal Attribute) private $password; // (normal Attribute) private $database; // Instance of class database // ********************** // CONSTRUCTOR METHOD // ********************** function Users() { $this->database = new Database(); } // ********************** // GETTER METHODS // ********************** public function getId() { return $this->id; } public function getFirstname() { return $this->firstname; } public function getLastname() { return $this->lastname; } public function getUsername() { return $this->username; } public function getPassword() { return $this->password; } // ********************** // SETTER METHODS // ********************** public function setId($val) { $this->id = $val; } public function setFirstname($val) { $this->firstname = $val; } public function setLastname($val) { $this->lastname = $val; } public function setUsername($val) { $this->username = $val; } public function setPassword($val) { $this->password = $val; } // ********************** // INIT METHOD // ********************** public function init($row) { $this->id = $row->id; $this->firstname = $row->firstname; $this->lastname = $row->lastname; $this->username = $row->username; $this->password = $row->password; } // ********************** // TO STRING METHOD // ********************** public function toString() { $s = ''; $s .= 'id: '.$this->id . ', '; $s .= 'firstname: '.$this->firstname . ', '; $s .= 'lastname: '.$this->lastname . ', '; $s .= 'username: '.$this->username . ', '; $s .= 'password: '.$this->password; return $s; } // ********************** // SELECT METHOD / LOAD ALL // ********************** public static function selectAll($criteria = null) { $objarray = array(); // list of objects $sql = "SELECT users.* FROM users"; if ($criteria) { $sql.= " " . $criteria; } $users = new Users(); $result = $users->database->query($sql); $result = $users->database->result; while($row = mysql_fetch_object($result)) { $users = new Users(); $users->init($row); array_push($objarray,$users); } return $objarray; } // ********************** // SELECT METHOD / LOAD ONE // ********************** public static function selectOne($id,$criteria = null) { $sql = "SELECT users.* FROM users WHERE id = $id"; if ($criteria) { $sql.= " " . $criteria; } $users = new Users(); $result = $users->database->query($sql); $result = $users->database->result; $rows = $users->database->rows; if ($rows > 0){ $users->init(mysql_fetch_object($result)); return $users; }else{ return null; } } // ********************** // DELETE // ********************** public function delete() { $sql = "DELETE FROM users WHERE id = $this->id;"; $result = $this->database->query($sql); } // ********************** // INSERT // ********************** public function insert() { $this->id = ""; // clear key for autoincrement $sql = "INSERT INTO users ( firstname,lastname,username,password ) VALUES ( '$this->firstname','$this->lastname','$this->username','$this->password' )"; $result = $this->database->query($sql); $this->id = mysql_insert_id($this->database->link); } // ********************** // UPDATE // ********************** public function update() { $sql = " UPDATE users SET firstname = '$this->firstname',lastname = '$this->lastname',username = '$this->username',password = '$this->password' WHERE id = $this->id "; $result = $this->database->query($sql); } // ********************** // DO COUNT // ********************** public static function doCount($criteria = null) { $sql = "SELECT COUNT(*) as count FROM users"; if ($criteria) { $sql.= " " . $criteria; } $users = new Users(); $result = $users->database->query($sql); $result = $users->database->result; $row = mysql_fetch_object($result); return $row->count; } } // class : end ?>