tanggal

// Model
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class M_tgl extends CI_model {


	public function tampil()
	{
		$query = $this->db->query("SELECT * FROM 'tb_tanggal' GROUP BY day('tgl')=date('d') WHERE month('tgl')=date('m') AND year('tgl')=date('Y')");
		return $query;

	}



}


//controller
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Tgl extends CI_Controller {
	public function __construct(){
		parent:: __construct();
		$this->load->model('m_tgl');
	}

	public function index()
	{
		$isi['content']='f_tanggal';
		$isi['data']=$this->m_tgl->tampil()->result();
		$this->load->view('template',$isi);
	}
}



//view


<div class="row">


   <div class="col-md-12">
          <!-- general form elements -->
      <div class="box box-info">
           <div class="box-header with-border">
              <h3 class="box-title">Table Tanggal</h3>
            </div>
            <!-- /.box-header -->
            <!-- form start -->

              <div class="box-body">
               <table  class="table table-bordered table-striped">
               	<thead>
                <tr>
                <th>Nama</th>
                <?php
                $tgl=date('t',strtotime('2017-12-01'));
                 for ($i=1; $i <=$tgl ; $i++) {
                  echo "<th>$i</th>";
                } ?>

             </tr>
               		<tbody>

                 <?php
                 foreach ($data as $r) {
                  $tanggal_transaksi=$r->tgl;

                  $ket=$r->ket;
                  ?>



               			<tr>
               				<td><?php echo $r->nama ;?></td>
                      		<td><?php echo $ket ?></td>

               			</tr>
                  <?php  }
                  ?>
               		</tbody>

               	</thead>

               </table>
              </div>
              <!-- /.box-body -->


          </div>
          <!-- /.box -->

            <!-- /.box-body -->


        </div>

</div>