<?php
/**
*
*/
class User_model extends CI_Model
{

	function __construct()
	{
		parent::__construct();
	}

	function get_all(){
		$data = array();
		$this->db->select('*');
		$Q = $this->db->get('user');
		// $sql = "SELECT * FROM user ORDER BY id_user DESC;";
		// $Q = $this->db->query($sql);

		if ($Q->num_rows()>0) {
			foreach ($Q->result_array() as $key => $row) {
				$data[]=$row;
			}
		}
		$Q->free_result();
		return $data;
	}

	function get_by_id($id){
		$data = array();
		$this->db->select('*');
		$this->db->where('id_user',$id);
		$Q = $this->db->get('user');

		if ($Q->num_rows()>0) {
				$data=$Q->row_array();
		}
		$Q->free_result();
		return $data;
	}

	function update($id,$input){
		$this->db->where('id_user',$id);
		$action = $this->db->update('user',$input);
		return $action;
	}

	function add($input){
		$action = $this->db->insert('user',$input);
		return $action;
	}

	function delete($id){
		$this->db->where('id_user',$id);
		$action = $this->db->delete('user');
		return $action;
	}
}
?>