tasks_model.php

<?php
class Tasks_Model extends CI_Model
{
    public function __construct()
    {
        parent:: __construct();
    }

    public function get_tasks($month)
    {
        $sql = "SELECT DAY(due) As day, due, title FROM tasks_list WHERE MONTH(due) = " . $month;
        $q = $this->db->query($sql);
        $num = $q->num_rows();
  	
        if($num > 0)
        {
            foreach($q->result() as $row)
            {
                $data[] = $row;
            }

            foreach($data as $d)
            {
                $out[$d->day] = (int)$d->day;
                $out[$d->day] = "http://tasks.dev/welcome/show/" . date('Y/m/d', strtotime($d->due));
            }
            return $out;
        }
        else
        {
            return 0;
        }		
    }

    public function day_tasks($day)
    {
        $sql = "SELECT * FROM tasks_list WHERE due = '" . $day . "'";
        $q = $this->db->query($sql);
        if($q->num_rows() > 0)
        {
            foreach($q->result() as $row)
            {
                $data[] = $row;
            }
            return $data;
        }
        else
        {
            return 0;
        }
    }
}