Codeigniter Project Setup

1. htacess untuk menghilangkan index.php pada URL
2. Set default timezone  di file index.php
3. Set Error display dan Database setup di Development dan Production
4. Buat file config untuk menyimpan variabel, di folder config misalkan store_config.php
5. Set Autoload database,config dll

6. Create Frontend Controller and Admin Controller
7. buat base controller di folder Core misalkan My_controller

8. Create Folder VIew untuk Frontend dan Admin
 9. Create Folder Model untuk Frontend dan Admin

Font

 <link href='http://fonts.googleapis.com/css?family=Duru+Sans' rel='stylesheet' type='text/css'>
  <link href='http://fonts.googleapis.com/css?family=Archivo+Narrow:400,700' rel='stylesheet' type='text/css'>


 font-family: 'Archivo Narrow', sans-serif;

Membuat Fungsi di Codeigniter

1.Buat file fungsi di folder Helper
   Nama Fungsi misalkan terbilang_helper.php

2. untuk memangil fungsi di controller : $this->load->helper('terbilang)

Tombol Back untuk Halaman sebelumnya

<script>
        function goBack()
          {
          window.history.back()
          }
</script>

Melihat data pada Session

print_r($this->session->all_userdata());

Codeigniter Pagination Style di Bootstrap

Buat file pagination.php di folder application/config
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

 // change default output to work with twitter bootstrap styling

 $config['full_tag_open'] = '<div ><ul class="pagination">';
 $config['full_tag_close'] = '</ul></div><!--pagination-->';
 $config['first_link'] = '&laquo; First';
 $config['first_tag_open'] = '<li class="prev page">';
 $config['first_tag_close'] = '</li>';

 $config['last_link'] = 'Last &raquo;';
 $config['last_tag_open'] = '<li class="next page">';
 $config['last_tag_close'] = '</li>';

 $config['next_link'] = 'Next &rarr;';
 $config['next_tag_open'] = '<li class="next page">';
 $config['next_tag_close'] = '</li>';

 $config['prev_link'] = '&larr; Previous';
 $config['prev_tag_open'] = '<li class="prev page">';
 $config['prev_tag_close'] = '</li>';

 $config['cur_tag_open'] = '<li class="active"><a href="">';
 $config['cur_tag_close'] = '</a></li>';

 $config['num_tag_open'] = '<li class="page">';
 $config['num_tag_close'] = '</li>';

 $config['anchor_class'] = 'class="follow_link"';

 ?>

Menghitung jumlah record dalam 1 tabel

$config['total_rows'] = $this->db->count_all('member');

Get number of returned rows in Active Record

$this->db->from('yourtable');
[... more active record code ...]
$query = $this->db->get();
$rowcount = $query->num_rows();

how to create MVC for search in Codeigniter?

# The Controller
class Search extends CI_Controller {

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

        $this->load->helper('form');

        $this->load->model('search_model');
    }

    public function index()
    {
        $this->load->view('search_form');
    }

    public function execute_search()
    {
        // Retrieve the posted search term.
        $search_term = $this->input->post('search');

        // Use a model to retrieve the results.
        $data['results'] = $this->search_model->get_results($search_term);

        // Pass the results to the view.
        $this->load->view('search_results',$data);
    }

}

# The Model
class Search_model extends CI_Model {

    public function get_results($search_term='default')
    {
        // Use the Active Record class for safer queries.
        $this->db->select('*');
        $this->db->from('members');
        $this->db->like('username',$search_term);

        // Execute the query.
        $query = $this->db->get();

        // Return the results.
        return $query->result_array();
    }

}

# The view for displaying the search form
<?php
    echo form_open('search/execute_search');

    echo form_input(array('name'=>'search'));

    echo form_submit('search_submit','Submit');


?>

# The View for displaying results
<div>
    <?php
        // List up all results.
        foreach ($results as $val)
        {
            echo $val['username'];
        }
    ?>
</div>

Active Record in Codeigniter

Membuat Login di Codeigniter

1. Create Table User :
CREATE TABLE `users` (
 `id` tinyint(4) NOT NULL AUTO_INCREMENT,
 `username` varchar(10) NOT NULL,
 `password` varchar(100) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

2 konfigurasi di CodeIgniter
-  Database.php
-  default controller login view
.-load library : Database , Session
- load Helper : URL
- Config.PHP - > $config['encryption_key'] = 'REALLY_LONG_NUMBER';




3. MODEL
<?php
Class User extends CI_Model
{
 function login($username, $password)
 {
   $this -> db -> select('id, username, password');
   $this -> db -> from('users');
   $this -> db -> where('username', $username);
   $this -> db -> where('password', MD5($password));
   $this -> db -> limit(1);
   $query = $this -> db -> get();
     if($query -> num_rows() == 1)
       {
             return $query->result();
        }
   else
      {
           return false;
      }
  }
}
?>
4. Conrtoller

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Login extends CI_Controller {
 function __construct()
 {
   parent::__construct();
 }
 function index()
 {
   $this->load->helper(array('form'));
   $this->load->view('login_view');
 }
}
?>

5.VIEW

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
   <title>Simple Login with CodeIgniter</title>
 </head>
 <body>
   <h1>Simple Login with CodeIgniter</h1>
   <?php echo validation_errors(); ?>
   <?php echo form_open('verifylogin'); ?>
     <label for="username">Username:</label>
     <input type="text" size="20" id="username" name="username"/>
     <br/>
     <label for="password">Password:</label>
     <input type="password" size="20" id="passowrd" name="password"/>
     <br/>
     <input type="submit" value="Login"/>
   </form>
 </body>
</html>


6.VerifyLogin Controller (application/controllers/verifylogin.php)

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

class VerifyLogin extends CI_Controller {

 function __construct()
 {
   parent::__construct();
   $this->load->model('user','',TRUE);
 }

 function index()
 {
   //This method will have the credentials validation
   $this->load->library('form_validation');

   $this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');
   $this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');

   if($this->form_validation->run() == FALSE)
   {
     //Field validation failed.&nbsp; User redirected to login page
     $this->load->view('login_view');
   }
   else
   {
     //Go to private area
     redirect('home', 'refresh');
   }

 }

 function check_database($password)
 {
   //Field validation succeeded.&nbsp; Validate against database
   $username = $this->input->post('username');

   //query the database
   $result = $this->user->login($username, $password);

   if($result)
   {
     $sess_array = array();
     foreach($result as $row)
     {
       $sess_array = array(
         'id' => $row->id,
         'username' => $row->username
       );
       $this->session->set_userdata('logged_in', $sess_array);
     }
     return TRUE;
   }
   else
   {
     $this->form_validation->set_message('check_database', 'Invalid username or password');
     return false;
   }
 }
}
?>
7. Home Controller (application/controllers/home.php)

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
session_start(); //we need to call PHP's session object to access it through CI
class Home extends CI_Controller {

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

 function index()
 {
   if($this->session->userdata('logged_in'))
   {
     $session_data = $this->session->userdata('logged_in');
     $data['username'] = $session_data['username'];
     $this->load->view('home_view', $data);
   }
   else
   {
     //If no session, redirect to login page
     redirect('login', 'refresh');
   }
 }

 function logout()
 {
   $this->session->unset_userdata('logged_in');
   session_destroy();
   redirect('home', 'refresh');
 }

}

?>

8.Home Page View (application/views/home_view.php)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
   <title>Simple Login with CodeIgniter - Private Area</title>
 </head>
 <body>
   <h1>Home</h1>
   <h2>Welcome <?php echo $username; ?>!</h2>
   <a href="home/logout">Logout</a>
 </body>
</html>

Codeigniter Active Record

Selecting Data

$query = $this->db->get('mytable');
$query = $this->db->get('mytable', 10, 20); 

$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset)

Select Field
$this->db->select('title, content, date');
$query = $this->db->get('mytable');

Select Max 
$this->db->select_max('age');
$query = $this->db->get('members');
// Produces: SELECT MAX(age) as age FROM members






 $this->db->select_max('age', 'member_age');
$query = $this->db->get('members');
// Produces: SELECT MAX(age) as member_age FROM members

Select Min
$this->db->select_min('age');
$query = $this->db->get('members');
// Produces: SELECT MIN(age) as age FROM members

Select AVG
$this->db->select_avg('age');
$query = $this->db->get('members');
// Produces: SELECT AVG(age) as age FROM members

Select From
$this->db->select('title, content, date');
$this->db->from('mytable');
$query = $this->db->get();
// Produces: SELECT title, content, date FROM mytable   

Select Join
$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');
$query = $this->db->get();

// Produces:
// SELECT * FROM blogs
// JOIN comments ON comments.id = blogs.id

$this->db->where();

1. Simple key/value method:  
   $this->db->where('name', $name); 
2. Custom key/value method:
   $this->db->where('name !=', $name);
   $this->db->where('id <', $id);
   // Produces: WHERE name != 'Joe' AND id < 45 
3.Associative array method:
  $array = array('name' => $name, 'title' => $title, 'status' => $status);
  $this->db->where($array);
// Produces: WHERE name = 'Joe' AND title = 'boss' AND status = 'active' 
  atau
  $array = array('name !=' => $name, 'id <' => $id, 'date >' => $date);
  $this->db->where($array); 
4.Custom string:
  $where = "name='Joe' AND status='boss' OR status='active'";
  $this->db->where($where);

 

Membuat variable di file config

file config :
$config['nama']='sukirman';

di controller :
class Produk extends Ci_Controller{
        var $nama;
        function __construct(){
            parent::__construct();
                       $this->nama=$this->config->item('nama');
        }
        function index(){
            $nama=$this->nama;
            echo "$nama" ;
        }
        }
?>

MY Model dari Jamie

Pengunaan :

Query record 

1. Mengambil semua record dalam table

   $result = $this->article_model->get_all();

   //SELECT * FROM (`articles`)

2. Mengambil 1 record berdasarkan ID (primaty key) 

   $row = $this->article_model->get(2);

   // SELECT * FROM (`articles`) WHERE `id` = 2 

3. Mengambil beberapa record berdasarkan ID tertentu (primary key)

   $result = $this->article_model->get_many(array(1,3,4));

   //SELECT * FROM (`articles`) WHERE `id` IN (1, 3, 4) 

   jika kondisi atau filternya lebih dari satu maka menggunakan Array,

   $this->news_model->get_many_by(array('active' => 1, 'another_column' => 'value'));   

5. mengambil 1 record berdasarkan filed tertentu :

   $row = $this->article_model->get_by('title', 'Fuzzy Wuzzy');

   ////SELECT * FROM (`articles`) WHERE `title` = 'Fuzzy Wuzzy' 

6. Menghitung Jumlah record dalam table

   $count = $this->article_model->count_all();
   //SELECT COUNT(*) AS `numrows` FROM `articles` 

7. Menghitung jumlah baris berdasarkan kreteria tertentu

   $count = $this->article_model->count_by('title', 'Dumb and boring post');
   //SELECT COUNT(*) AS `numrows` FROM (`articles`) WHERE `title` = 'judul'

8. Mengambil record berdasarkan offset dan limit

   $this->post->limit($limit, $offset)->post->get_all(); 

Insert Data 

1. Insert 1 record

   $insert_id = $this->article_model->insert(array('body'=>'Woot!', 'title'=>'My thoughts'), FALSE);

   //INSERT INTO `articles` (`body`, `title`) VALUES ('Woot!', 'My thoughts')

2. Insert beberapa record

   $insert_array = array(
  array('body'=>'Hello', 'title'=>'I must be going'),
  array('body'=>"When she's gone", 'title'=>"Ain't no sunshine" ),
 );
   $insert_ids = $this->article_model->insert_many($insert_array, FALSE); 
  //Array ( [0] => 16 [1] => 17 ) //1
  //INSERT INTO `articles` (`body`, `title`) VALUES ('When she\'s gone', 'Ain\'t no sunshine')
 

Update Data

1.Update 1 record berdasarkan primary key.

  $update_id = $this->article_model->update(4, array('body'=>'Isi Renungan 1', 'title'=>'Renungan'));
  //1
  //UPDATE `articles` SET `body` = 'Isi renungan 1', `title` = 'renungan 1' WHERE `id` = 4
  

2.Update berdasarkan kreteria tertentu.

  $update_id = $this->article_model->update_by(array('title'=>'My thoughts'), array('body'=>'Having deeper thoughts'));
  //1
  //UPDATE `articles` SET `body` = 'Having deeper thoughts' WHERE `title` = 'My thoughts' 

3. Update berdasdarkan beberapa primary KEY

   $update_id = $this->article_model->update_many(array(3,4,5), array('body'=>"Oh! I've been updated...and I feel MARVELOUS!"));
   //1
   //UPDATE `articles` SET `body` = 'Oh! I\'ve been updated...and I feel MARVELOUS!' WHERE `id` IN (3, 4, 5)  

4. Update all data dalam table

  $update_id = $this->article_model->update_all( array('title'=>"Another dumb title"));
  //1
  //UPDATE `articles` SET `title` = 'Another dumb title'

Delete Data

1. Delete 1 record berdasarkan primary key
   $delete_id = $this->article_model->delete( 7);
   //1
   //DELETE FROM `articles` WHERE `id` = 7 

2. Delete berdasarkan kreteria dari field tertentu 

   $delete_id = $this->article_model->delete_by( array('body'=>'Hello'));
   //1
   //DELETE FROM `articles` WHERE `body` = 'Hello' 

3. Delete beberapa  record berdasarkan beberapa primary key 

   $delete_id = $this->article_model->delete_many( array(3,4,5));
   //1
   //DELETE FROM `articles` WHERE `id` IN (3, 4, 5) 

Pagination In Codeigniter

Tutorial membuat pagination di codeigniter dengan menggunakan Jamie Rumbelow’s MY_Model.

kode di Controller :

class Posts extends CI_Controller

{

public function __construct()

{

    parent::__construct();

    $this->load->helper('html');

    $this->load->helper('url');

    $this->load->model('post_model', 'post');

    $this->load->library("pagination");

    $this->load->database();

    $limit = 2;

    $offset=$this->uri->segment(3); 

    $config['total_rows'] = $this->post->count_all();

    $config['base_url'] = site_url('/posts/index/'); 

    $config['per_page'] = $limit;

    $data['posts'] = $this->post->limit($limit, $offset)->post->get_all();

    $this->pagination->initialize($config);

    $data["pagination_links"] = $this->pagination->create_links();

    $this->load->view('posts',$data); 

}

}

kode di view:

<?php

    foreach ($posts as $key => $value)
        {
            echo '<h1>'. $value->judul . '</h1>';
            echo '<p>'. $value->isi_berita . '</p>';
        }

    echo $pagination_links;

?> 

Untuk mempercantik tampilan link pagination dengan menggunakan Bootstrap adalah
membuat file pagination.php sinpan di folder Application/Config.
isi file pagination.php :

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

// --------------------------------------------------------------------------
// $config['base_url'] = 'blog';
$config['per_page'] = 2;
$config['uri_segment'] = 3;
// $config['page_query_string'] = TRUE;
$config['use_page_numbers'] = TRUE;
$config['query_string_segment'] = 'page';

$config['full_tag_open'] = '<div ><ul class="pagination">';
$config['full_tag_close'] = '</ul></div><!--pagination-->';

$config['first_link'] = '&laquo; First';
$config['first_tag_open'] = '<li class="prev page">';
$config['first_tag_close'] = '</li>';

$config['last_link'] = 'Last &raquo;';
$config['last_tag_open'] = '<li class="next page">';
$config['last_tag_close'] = '</li>';

$config['next_link'] = 'Next &rarr;';
$config['next_tag_open'] = '<li class="next page">';
$config['next_tag_close'] = '</li>';

$config['prev_link'] = '&larr; Previous';
$config['prev_tag_open'] = '<li class="prev page">';
$config['prev_tag_close'] = '</li>';

$config['cur_tag_open'] = '<li class="active"><a href="">';
$config['cur_tag_close'] = '</a></li>';

$config['num_tag_open'] = '<li class="page">';
$config['num_tag_close'] = '</li>';

// $config['display_pages'] = FALSE;
//
$config['anchor_class'] = 'follow_link';

// --------------------------------------------------------------------------

Print_r agar lebih rapi

echo "<pre>";
print_r($result['data']);
echo "</pre>";

memeriksa hasil query apakah terdapat recod atau tidak

<?php
   if(count($result))==0{
          echo "<p>Tidak ada data dalam table</p>" ;
  }else{
   foreach($result as $row){
                    print_r($row);
             }
}
?>

BASIC TEMPLATE di Codeigniter

Di  Controller :

 $data['main_content'] = 'login_view';  
 $data['title']        = 'Login To WePOS';  
 $data['css']          = 'login-box.css';  
 $this->load->view('templates/default',$data);

jika css filenyalebih dari satu :

$data['cssFiles'] = array(
    'login-box.css',
    'other.css'
    );  

di file header :

if(is_array($cssFiles)){
    foreach($cssFiles as $cssFile) {
        <link href="<?php echo base_url() . 'style/' . $css; ?>" rel="stylesheet" type="text/css" />
    }
} 

di template,php view :

 $this->load->view('header_view');  
 $this->load->view($main_content);   
 $this->load->view('footer_view');   

CONTOH INPUT TEXT DI HTML dan CODEIGNITER

CODEIGNITER
$data = array(
        'name'=> 'nama',
         'id' => 'nama',
         'size' => '50',
         'maxlength' => '100',
         'placeholder' => 'First name',
        ); 

 echo form_input($data);

HTML5 
 <input type="text"
    name="nama"
    id="nama"   
    size="50"
    maxlength="100"
    placeholder="First name"
    autofocus 
 >
    <!-- value= -->
    <!-- autocomplete="off" -->
    <!-- disabled -->
    <!-- form="form1" -->
    <!-- pattern="[A-Za-z]{3}" -->
    <!-- readonly -->
    <!-- required -->

Form dalam Codeigniter

- form helper harus diupload  :

$this->load->helper('form');

Perintah-perintah dalam form helper:

-form_open (file_tujuan,atribute,hidden_input_fields) 

contoh :
$attributes = array('class' => 'email', 'id' => 'myform');
$hidden = array('username' => 'Joe', 'member_id' => '234');
echo form_open('email/send', $attributes);

akan menghasilkan kode HTML sbb :

form method="post" accept-charset="utf-8" action="http:/example.com/index.php/email/send">
<input type="hidden" name="username" value="Joe" />
<input type="hidden" name="member_id" value="234" />

-form_open_multipart() 

Untuk upload file/gambar

-form_input('nama','value')

$data = array(
              'name'        => 'username',
              'id'          => 'username',
              'value'       => 'johndoe',
              'maxlength'   => '100',
              'size'        => '50',
              'style'       => 'width:50%',
            );

echo form_input($data);

// Would produce:

<input type="text" name="username" id="username" value="johndoe" maxlength="100" size="50" style="width:50%" />

 

form_password()

form_upload()

form_textarea()

form_dropdown('name','value','selected',JS)

$js = 'id="shirts" onChange="some_function();"';
echo form_dropdown('shirts', $options, 'large', $js);

form_multiselect()

form_fieldset_close()

form_checkbox()

form_radio()

form_submit()

form_label()

form_reset()

form_button()

form_close()

form_prep()

set_value()

set_select()

set_checkbox()

set_radio()