Ane mo share aplikasi web based dengan codeigniter, dimana aplikasi ini menggunakan MySql sebagai database nya. Langsung saja berikut rincian nya :
Database :


Controllers Mahasiswa.php
<?php
class Mahasiswa extends Controller 
{
 function Mahasiswa()
  {
    parent::Controller();
    $this->load->database();
    $this->load->model(&#039;modeldatazen&#039/;)/;
$this->load->helper(&#039;html&#039/;)/;
  }

 function index ()
  {
  $this->load->helper(array(&#039;form','url&#039/;)/);
      $this->load->library(&#039;form_validation&#039/;)/;  
      $this->form_validation->set_rules(&#039;nim','NIM','required&#039/;)/;
      $this->form_validation->set_rules(&#039;nama','Nama','required&#039/;)/;
      if ($this->form_validation->run() == FALSE)
  {
  $this->form_validation->set_message(&#039;required', 'Your custom message here&#039/;)/;
      }
      else
      {
      $this->modeldatazen->insert();
      }
      $this->load->view(&#039;tambah_view&#039/;)/;
  } 
  function tampildata()
      {
      $data[&#039;query']= $this->modeldatazen->get();
      $this->load->view(&#039;tampils',$data);
      }
}
?>

Model Modeldatazen.php
<?php
class Modeldatazen extends Model 
{
 function Modeldatazen()
 {
  parent::Model();
 }

 function Insert()
 {
  $this->nim = $this->input->post(&#039;nim&#039/;)/;
  $this->nama = $this->input->post(&#039;nama&#039/;)/;
  $this->db->insert(&#039;mahasiswa',$this);
  redirect (&#039;mahasiswa&#039/;)/;
 }
 function get()
 {
  // Produces: SELECT nim, nama FROM mahasiswa
  $this->load->database();
  $this->db->select(&#039;nim, nama&#039/;)/;
  $this->db->order_by("nim", "asc"); 
  $query = $this->db->get(&#039;mahasiswa&#039/;)/;
  return $query->result();
 }
 function caridata()
 {
 $c=$this->input->POST(&#039;cari&#039/;)/;
 $this->db->like(&#039;nama',$c);
 $query=$this->db->get(&#039;mahasiswa&#039/;)/;
 return $query;
 $this->load->view(&#039;tampil',$data);
 }
}
?>

Views Tambah_view.php
<?php
$this->load->library(&#039;validation&#039/;)/;
$nim= array (
             &#039;name'      =>'nim',
             &#039;id'        =>'nim',
             &#039;value'     =>'',
             &#039;maxlength' =>'5',
             &#039;size'      =>'50',
             &#039;style'     =>'width:50%',
             
           );
$nama= array (
             &#039;name'      =>'nama',
             &#039;id'        =>'nama',
             &#039;value'     =>'',
             &#039;maxlength' =>'100',
             &#039;size'      =>'50',
             &#039;style'     =>'width:50%',
             
           );

$this->load->helper(&#039;form&#039/;)/;
echo validation_errors();
echo form_open(&#039;mahasiswa&#039/;)/;

echo "<h3>Tambah Mahasiswa</h3>";
echo "<table border='0' class='tabledetail'>";
echo "<tr>"."<td>".form_label(&#039;NIM&#039/;)/."</td>"."<td>".form_input('nim&#039/;)/."</td>"."</tr>";
echo "<tr>"."<td>".form_label(&#039;Nama&#039/;)/."</td>"."<td>".form_input('nama&#039/;)/."</td>"."</tr>";
echo "<tr>"."<td>".form_submit(&#039;mysubmit','simpan&#039/;)/."</td>"."<td>"; 
echo "</table>";
echo "<hr> </hr>";
echo form_close();
?>
<a href="<?php echo base_url();?>/index.php/mahasiswa/tampildata">Lihat Data</a>

Views Tampils.php
<center>
<h3>Tabel Data Mahasiswa<h3>
</table>
<table border=1>
<tr>
<td>NIM</td>
<td>Nama</td>
</tr>
<?php foreach ($query as $row) : ?>
<tr>
<td><?php echo $row->nim?></td>
<td><?php echo $row->nama?></td>
</tr>
<?php endforeach ?>
</table>
<br>
<?php 
echo "Page rendered in ";
echo $this->benchmark->elapsed_time();
echo " second"; 
echo "<br>" ;?>
<?php
echo "Memori: ";
echo $this->benchmark->memory_usage();?>
<br>
<?
echo anchor('mahasiswa','Tambah lagi????&#039/;)/;?>
<?

?>
Hasil akhir seperti berikut ini:

Ketika di klik "Lihat Data" maka muncul

Sedikit ane mo tanya, cara pake pagination class nya gimana ya??? biar tampilan data tidak terlalu banyak dalam satu page?????