Posted By

Abe on 11/13/09

Tagged

Versions (?)

Last Edited at 11/13/09 06:43pm

Statistics

Viewed 232 times

Favorited by 0 user(s)

Related snippets

How to Write a Better Model in CodeIgniter

/ Published in: PHP

Highlighted TextExpand

<?php if (!defined('BASEPATH')) exit('No direct script access');

class Users_model extends Model {
	var $table = 'users';
	
	function __construct() {
		parent::Model();
	}
	
	function Users_model() {
		parent::Model();
	}
	
	function add_user($options = array()) {
		if(!$this->_required(array('email', 'password'), $options))
			return false;
			
		$options = $this->_default(array('status' => 'active'), $options);
		
		$qualificationArray = array('email', 'username', 'status');
		foreach($qualificationArray as $qualifier) {
			if (isset($options[$qualifier]))
				$this->db->set($qualifier, $options[$qualifier]);
		}
		
		if (isset($options['password']))
			$this->db->set('password', md5($options['password']));
			
		$this->db->insert($this->table);
		
		return $this->db->insert_id();
	}
	
	function update_user($options = array()) {
		if(!$this->_required(array('email'), $options))
			return false;
			
		$qualificationArray = array('email', 'username', 'status');
		foreach($qualificationArray as $qualifier) {
			if (isset($options[$qualifier]))
				$this->db->set($qualifier, $options[$qualifier]);
		}
		
		$this->db->where('email', $options['email']);
		
		if(isset($options['password']))
			$this->db->set('password', md5($options['password']));
			
		$this->db->update($this->table);
		
		return $this->db->affected_rows();
	}
	
	function get_users($options = array()) {
		$options = $this->_default(array('sort_direction' => 'asc'), $options);
		
		$qualificationArray = array('email', 'status');
		foreach($qualificationArray as $qualifier) {
			if (isset($options[$qualifier]))
				$this->db->where($qualifier, $options[$qualifier]);
		}
		
		if (isset($options['limit']) && isset($options['offset']))
			$this->db->limit($options['limit'], $options['offset']);
			
		else if (isset($options['limit']))
			$this->db->limit($options['limit']);
			
		if (isset($options['sort_by']))
			$this->db->order_by($options['sort_by'], $options['sort_direction']);
			
		$query = $this->db->get($this->table);
		if ($query->num_rows() == 0)
			return false;
			
		if (isset($options['email'])) {
			return $query->row(0);
			
		} else {
			return $query->result();
		}
	}
	
	function delete_user($options = array()) {
		if(!$this->_required(array('email'), $options))
			return false;
			
		$this->db->where('email', $options['email']);
		$this->db->delete($this->table);
	}
	
	function _required($required, $data) {
		foreach($required as $field)
			if (!isset($data[$field]))
				return false;
		return true;
	}
	
	function _default($defaults, $options) {
		return array_merge($defaults, $options);
	}
}

URL: http://shawnmccool.com/2009/08/28/how-to-write-a-better-model-in-code-igniter/

Report this snippet Tweet