Code

v_artikel.php
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Artikel
            <small>Manajemen Artikel</small>
        </h1>
    </section>

    <section class="content">

        <div class="row">
            <div class="col-lg-12">

                <a href="<?php echo base_url().'dashboard/artikel_tambah'; ?>" class="btn btn-sm btn-primary">Buat artikel baru</a>

                <br/>
                <br/>

                <div class="box box-primary">
                    <div class="box-header">
                        <h3 class="box-title">Artikel</h3>
                    </div>
                    <div class="box-body">

                        <div class="table-responsive">
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th width="1%">NO</th>
                                        <th>Tanggal</th>
                                        <th>Artikel</th>
                                        <th>Author</th>
                                        <th>Kategori</th>
                                        <th width="10%">Gambar</th>
                                        <th>Status</th>
                                        <th width="15%">OPSI</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $no = 1;
                                    foreach($artikel as $a){
                                        ?>
                                        <tr>
                                            <td><?php echo $no++; ?></td>
                                            <td><?php echo date('d/m/Y H:i', strtotime($a->artikel_tanggal)); ?></td>
                                            <td>
                                                <?php echo $a->artikel_judul; ?>
                                                <br/>
                                                <small class="text-muted">
                                                    <?php echo base_url()."".$a->artikel_slug; ?>
                                                </small>
                                            </td>
                                            <td><?php echo $a->pengguna_nama; ?></td>
                                            <td><?php echo $a->kategori_nama; ?></td>
                                            <td><img width="100%" class="img-responsive" src="<?php echo base_url().'/gambar/artikel/'.$a->artikel_sampul; ?>"></td>
                                            <td>
                                                <?php
                                                if($a->artikel_status=="publish"){
                                                    echo "<span class='label label-success'>Publish</span>";
                                                }else{
                                                    echo "<span class='label label-danger'>Draft</span>";
                                                }
                                                ?>

                                            </td>
                                            <td>
                                                <a target="_blank" href="<?php echo base_url().$a->artikel_slug; ?>" class="btn btn-success btn-sm"> <i class="fa fa-eye"></i> </a>
                                                <?php
                                            // cek apakah penggun yang login adalah penulis
                                                if($this->session->userdata('level') == "penulis"){
                                                // jika penulis, maka cek apakah penulis artikel ini adalah si pengguna atau bukan
                                                    if($this->session->userdata('id') == $a->artikel_author){
                                                        ?>
                                                        <a href="<?php echo base_url().'dashboard/artikel_edit/'.$a->artikel_id; ?>" class="btn btn-warning btn-sm"> <i class="fa fa-pencil"></i> </a>
                                                        <a href="<?php echo base_url().'dashboard/artikel_hapus/'.$a->artikel_id; ?>" class="btn btn-danger btn-sm"> <i class="fa fa-trash"></i> </a>
                                                        <?php
                                                    }
                                                }else{
                                                // jika yang login adalah admin
                                                    ?>
                                                    <a href="<?php echo base_url().'dashboard/artikel_edit/'.$a->artikel_id; ?>" class="btn btn-warning btn-sm"> <i class="fa fa-pencil"></i> </a>
                                                    <a href="<?php echo base_url().'dashboard/artikel_hapus/'.$a->artikel_id; ?>" class="btn btn-danger btn-sm"> <i class="fa fa-trash"></i> </a>
                                                    <?php
                                                }
                                                ?>
                                            </td>
                                        </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>

            </div>
        </div>

    </section>

</div>

v_Artikel_edit.php
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Artikel
            <small>Edit Artikel Baru</small>
        </h1>
    </section>

    <section class="content">

        <a href="<?php echo base_url().'dashboard/artikel'; ?>" class="btn btn-sm btn-primary">Kembali</a>

        <br/>
        <br/>

        <?php foreach($artikel as $a){ ?>

        <form method="post" action="<?php echo base_url('dashboard/artikel_update') ?>" enctype="multipart/form-data">
            <div class="row">
                <div class="col-lg-9">

                    <div class="box box-primary">
                        <div class="box-body">


                            <div class="box-body">
                                <div class="form-group">
                                    <label>Judul</label>
                                    <input type="hidden" name="id" value="<?php echo $a->artikel_id; ?>">
                                    <input type="text" name="judul" class="form-control" placeholder="Masukkan judul artikel.." value="<?php echo $a->artikel_judul; ?>">
                                    <br/>
                                    <?php echo form_error('judul'); ?>
                                </div>
                            </div>

                            <div class="box-body">
                                <div class="form-group">
                                    <label>Konten</label>
                                    <?php echo form_error('konten'); ?>
                                    <br/>
                                    <textarea class="form-control" id="editor" name="konten"> <?php echo $a->artikel_konten; ?> </textarea>
                                </div>
                            </div>


                        </div>
                    </div>

                </div>

                <div class="col-lg-3">
                    <div class="box box-primary">
                        <div class="box-body">
                            <div class="form-group">
                                <label>Kategori</label>
                                <select class="form-control" name="kategori">
                                    <option value="">- Pilih Kategori</option>
                                    <?php foreach($kategori as $k){ ?>
                                        <option <?php if($a->artikel_kategori == $k->kategori_id){echo "selected='selected'";} ?> value="<?php echo $k->kategori_id ?>"><?php echo $k->kategori_nama; ?></option>
                                    <?php } ?>
                                </select>
                                <br/>
                                <?php echo form_error('kategori'); ?>
                            </div>

                            <br/><br/>

                            <div class="form-group">
                                <label>Gambar Sampul</label>

                                <input type="file" name="sampul">

                                <br/>
                                <?php
                                if(isset($gambar_error)){
                                    echo $gambar_error;
                                }
                                ?>
                                <?php echo form_error('sampul'); ?>
                            </div>

                            <br/><br/>

                            <input type="submit" name="status" value="Draft" class="btn btn-warning btn-block">
                            <input type="submit" name="status" value="Publish" class="btn btn-success btn-block">

                        </div>
                    </div>

                </div>
            </div>
        </form>
        <?php } ?>

    </section>

</div>

v_Artikel_tambah.php
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Artikel
            <small>Tulis Artikel Baru</small>
        </h1>
    </section>

    <section class="content">

        <a href="<?php echo base_url().'dashboard/artikel'; ?>" class="btn btn-sm btn-primary">Kembali</a>

        <br/>
        <br/>

        <form method="post" action="<?php echo base_url('dashboard/artikel_aksi') ?>" enctype="multipart/form-data">
            <div class="row">
                <div class="col-lg-9">

                    <div class="box box-primary">
                        <div class="box-body">


                            <div class="box-body">
                                <div class="form-group">
                                    <label>Judul</label>
                                    <input type="text" name="judul" class="form-control" placeholder="Masukkan judul artikel.." value="<?php echo set_value('judul'); ?>">
                                    <br/>
                                    <?php echo form_error('judul'); ?>
                                </div>
                            </div>

                            <div class="box-body">
                                <div class="form-group">
                                    <label>Konten</label>
                                    <?php echo form_error('konten'); ?>
                                    <br/>
                                    <textarea class="form-control" id="editor" name="konten"> <?php echo set_value('konten'); ?> </textarea>
                                </div>
                            </div>


                        </div>
                    </div>

                </div>

                <div class="col-lg-3">
                    <div class="box box-primary">
                        <div class="box-body">
                            <div class="form-group">
                                <label>Kategori</label>
                                <select class="form-control" name="kategori">
                                    <option value="">- Pilih Kategori</option>
                                    <?php foreach($kategori as $k){ ?>
                                        <option <?php if(set_value('kategori') == $k->kategori_id){echo "selected='selected'";} ?> value="<?php echo $k->kategori_id ?>"><?php echo $k->kategori_nama; ?></option>
                                    <?php } ?>
                                </select>
                                <br/>
                                <?php echo form_error('kategori'); ?>
                            </div>

                            <br/><br/>

                            <div class="form-group">
                                <label>Gambar Sampul</label>

                                <input type="file" name="sampul">

                                <br/>
                                <?php
                                if(isset($gambar_error)){
                                    echo $gambar_error;
                                }
                                ?>
                                <?php echo form_error('sampul'); ?>
                            </div>

                            <br/><br/>

                            <input type="submit" name="status" value="Draft" class="btn btn-warning btn-block">
                            <input type="submit" name="status" value="Publish" class="btn btn-success btn-block">

                        </div>
                    </div>

                </div>
            </div>
        </form>

    </section>

</div>


m_data.php
<?php

// WWW.MALASNGODING.COM === Author : Diki Alfarabi Hadi
// Model yang terstruktur. agar bisa digunakan berulang kali untuk membuat CRUD.
// Sehingga proses pembuatan CRUD menjadi lebih cepat dan efisien.

class M_data extends CI_Model{

    function cek_login($table,$where){
        return $this->db->get_where($table,$where);
    }

    // FUNGSI CRUD
    // fungsi untuk mengambil data dari database
    function get_data($table){
        return $this->db->get($table);
    }

    // fungsi untuk menginput data ke database
    function insert_data($data,$table){
        $this->db->insert($table,$data);
    }

    // fungsi untuk mengedit data
    function edit_data($where,$table){
        return $this->db->get_where($table,$where);
    }

    // fungsi untuk mengupdate atau mengubah data di database
    function update_data($where,$data,$table){
        $this->db->where($where);
        $this->db->update($table,$data);
    }

    // fungsi untuk menghapus data dari database
    function delete_data($where,$table){
        $this->db->delete($table,$where);
    }
    // AKHIR FUNGSI CRUD


}

?>

application -> controllers -> dashboard.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Dashboard extends CI_Controller {

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

        date_default_timezone_set('Asia/Jakarta');

        $this->load->model('m_data');

        // cek session yang login,
        // jika session status tidak sama dengan session telah_login, berarti pengguna belum login
        // maka halaman akan di alihkan kembali ke halaman login.
        if($this->session->userdata('status')!="telah_login"){
            redirect(base_url().'login?alert=belum_login');
        }
    }

    public function index()
    {
        // hitung jumlah artikel
        $data['jumlah_artikel'] = $this->m_data->get_data('artikel')->num_rows();
        // hitung jumlah kategori
        $data['jumlah_kategori'] = $this->m_data->get_data('kategori')->num_rows();
        // hitung jumlah pengguna
        $data['jumlah_pengguna'] = $this->m_data->get_data('pengguna')->num_rows();
        // hitung jumlah halaman
        $data['jumlah_halaman'] = $this->m_data->get_data('halaman')->num_rows();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_index',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function keluar()
    {
        $this->session->sess_destroy();
        redirect('login?alert=logout');
    }

    public function ganti_password()
    {
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_ganti_password');
        $this->load->view('dashboard/v_footer');
    }

    public function ganti_password_aksi()
    {

        // form validasi
        $this->form_validation->set_rules('password_lama','Password Lama','required');
        $this->form_validation->set_rules('password_baru','Password Baru','required|min_length[8]');
        $this->form_validation->set_rules('konfirmasi_password','Konfirmasi Password Baru','required|matches[password_baru]');

        // cek validasi
        if($this->form_validation->run() != false){

            // menangkap data dari form
            $password_lama = $this->input->post('password_lama');
            $password_baru = $this->input->post('password_baru');
            $konfirmasi_password = $this->input->post('konfirmasi_password');

            // cek kesesuaian password lama dengan id pengguna yang sedang login dan password lama
            $where = array(
                'pengguna_id' => $this->session->userdata('id'),
                'pengguna_password' => md5($password_lama)
            );
            $cek = $this->m_data->cek_login('pengguna', $where)->num_rows();

            // cek kesesuaikan password lama
            if($cek > 0){

                // update data password pengguna
                $w = array(
                    'pengguna_id' => $this->session->userdata('id')
                );
                $data = array(
                    'pengguna_password' => md5($password_baru)
                );
                $this->m_data->update_data($where, $data, 'pengguna');

                // alihkan halaman kembali ke halaman ganti password
                redirect('dashboard/ganti_password?alert=sukses');
            }else{
                // alihkan halaman kembali ke halaman ganti password
                redirect('dashboard/ganti_password?alert=gagal');
            }

        }else{
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_ganti_password');
            $this->load->view('dashboard/v_footer');
        }

    }

    // CRUD KATEGORI
    public function kategori()
    {
        $data['kategori'] = $this->m_data->get_data('kategori')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_kategori',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function kategori_tambah()
    {
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_kategori_tambah');
        $this->load->view('dashboard/v_footer');
    }

    public function kategori_aksi()
    {
        $this->form_validation->set_rules('kategori','Kategori','required');

        if($this->form_validation->run() != false){

            $kategori = $this->input->post('kategori');

            $data = array(
                'kategori_nama' => $kategori,
                'kategori_slug' => strtolower(url_title($kategori))
            );

            $this->m_data->insert_data($data,'kategori');

            redirect(base_url().'dashboard/kategori');

        }else{
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_kategori_tambah');
            $this->load->view('dashboard/v_footer');
        }
    }

    public function kategori_edit($id)
    {
        $where = array(
            'kategori_id' => $id
        );
        $data['kategori'] = $this->m_data->edit_data($where,'kategori')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_kategori_edit',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function kategori_update()
    {
        $this->form_validation->set_rules('kategori','Kategori','required');

        if($this->form_validation->run() != false){

            $id = $this->input->post('id');
            $kategori = $this->input->post('kategori');

            $where = array(
                'kategori_id' => $id
            );

            $data = array(
                'kategori_nama' => $kategori,
                'kategori_slug' => strtolower(url_title($kategori))
            );

            $this->m_data->update_data($where, $data,'kategori');

            redirect(base_url().'dashboard/kategori');

        }else{

            $id = $this->input->post('id');
            $where = array(
                'kategori_id' => $id
            );
            $data['kategori'] = $this->m_data->edit_data($where,'kategori')->result();
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_kategori_edit',$data);
            $this->load->view('dashboard/v_footer');
        }
    }


    public function kategori_hapus($id)
    {
        $where = array(
            'kategori_id' => $id
        );

        $this->m_data->delete_data($where,'kategori');

        redirect(base_url().'dashboard/kategori');
    }
    // END CRUD KATEGORI

    // CRUD ARTIKEL
    public function artikel()
    {
        $data['artikel'] = $this->db->query("SELECT * FROM artikel,kategori,pengguna WHERE artikel_kategori=kategori_id and artikel_author=pengguna_id order by artikel_id desc")->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_artikel',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function artikel_tambah()
    {
        $data['kategori'] = $this->m_data->get_data('kategori')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_artikel_tambah',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function artikel_aksi()
    {
        // Wajib isi judul,konten dan kategori
        $this->form_validation->set_rules('judul','Judul','required|is_unique[artikel.artikel_judul]');
        $this->form_validation->set_rules('konten','Konten','required');
        $this->form_validation->set_rules('kategori','Kategori','required');

        // Membuat gambar wajib di isi
        if (empty($_FILES['sampul']['name'])){
            $this->form_validation->set_rules('sampul', 'Gambar Sampul', 'required');
        }

        if($this->form_validation->run() != false){

            $config['upload_path']   = './gambar/artikel/';
            $config['allowed_types'] = 'gif|jpg|png';

            $this->load->library('upload', $config);

            if ($this->upload->do_upload('sampul')) {

                // mengambil data tentang gambar
                $gambar = $this->upload->data();

                $tanggal = date('Y-m-d H:i:s');
                $judul = $this->input->post('judul');
                $slug = strtolower(url_title($judul));
                $konten = $this->input->post('konten');
                $sampul = $gambar['file_name'];
                $author = $this->session->userdata('id');
                $kategori = $this->input->post('kategori');
                $status = $this->input->post('status');

                $data = array(
                    'artikel_tanggal' => $tanggal,
                    'artikel_judul' => $judul,
                    'artikel_slug' => $slug,
                    'artikel_konten' => $konten,
                    'artikel_sampul' => $sampul,
                    'artikel_author' => $author,
                    'artikel_kategori' => $kategori,
                    'artikel_status' => $status,
                );

                $this->m_data->insert_data($data,'artikel');

                redirect(base_url().'dashboard/artikel');

            } else {

                $this->form_validation->set_message('sampul', $data['gambar_error'] = $this->upload->display_errors());

                $data['kategori'] = $this->m_data->get_data('kategori')->result();
                $this->load->view('dashboard/v_header');
                $this->load->view('dashboard/v_artikel_tambah',$data);
                $this->load->view('dashboard/v_footer');
            }

        }else{
            $data['kategori'] = $this->m_data->get_data('kategori')->result();
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_artikel_tambah',$data);
            $this->load->view('dashboard/v_footer');
        }
    }


    public function artikel_edit($id)
    {
        $where = array(
            'artikel_id' => $id
        );
        $data['artikel'] = $this->m_data->edit_data($where,'artikel')->result();
        $data['kategori'] = $this->m_data->get_data('kategori')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_artikel_edit',$data);
        $this->load->view('dashboard/v_footer');
    }


    public function artikel_update()
    {
        // Wajib isi judul,konten dan kategori
        $this->form_validation->set_rules('judul','Judul','required');
        $this->form_validation->set_rules('konten','Konten','required');
        $this->form_validation->set_rules('kategori','Kategori','required');

        if($this->form_validation->run() != false){

            $id = $this->input->post('id');

            $judul = $this->input->post('judul');
            $slug = strtolower(url_title($judul));
            $konten = $this->input->post('konten');
            $kategori = $this->input->post('kategori');
            $status = $this->input->post('status');

            $where = array(
                'artikel_id' => $id
            );

            $data = array(
                'artikel_judul' => $judul,
                'artikel_slug' => $slug,
                'artikel_konten' => $konten,
                'artikel_kategori' => $kategori,
                'artikel_status' => $status,
            );

            $this->m_data->update_data($where,$data,'artikel');


            if (!empty($_FILES['sampul']['name'])){
                $config['upload_path']   = './gambar/artikel/';
                $config['allowed_types'] = 'gif|jpg|png';

                $this->load->library('upload', $config);

                if ($this->upload->do_upload('sampul')) {

                    // mengambil data tentang gambar
                    $gambar = $this->upload->data();

                    $data = array(
                        'artikel_sampul' => $gambar['file_name'],
                    );

                    $this->m_data->update_data($where,$data,'artikel');

                    redirect(base_url().'dashboard/artikel');

                } else {
                    $this->form_validation->set_message('sampul', $data['gambar_error'] = $this->upload->display_errors());

                    $where = array(
                        'artikel_id' => $id
                    );
                    $data['artikel'] = $this->m_data->edit_data($where,'artikel')->result();
                    $data['kategori'] = $this->m_data->get_data('kategori')->result();
                    $this->load->view('dashboard/v_header');
                    $this->load->view('dashboard/v_artikel_edit',$data);
                    $this->load->view('dashboard/v_footer');
                }
            }else{
                redirect(base_url().'dashboard/artikel');
            }

        }else{
            $id = $this->input->post('id');
            $where = array(
                'artikel_id' => $id
            );
            $data['artikel'] = $this->m_data->edit_data($where,'artikel')->result();
            $data['kategori'] = $this->m_data->get_data('kategori')->result();
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_artikel_edit',$data);
            $this->load->view('dashboard/v_footer');
        }
    }

    public function artikel_hapus($id)
    {
        $where = array(
            'artikel_id' => $id
        );

        $this->m_data->delete_data($where,'artikel');

        redirect(base_url().'dashboard/artikel');
    }
    // end crud artikel


    // CRUD PAGES
    public function pages()
    {
        $data['halaman'] = $this->m_data->get_data('halaman')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pages',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function pages_tambah()
    {
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pages_tambah');
        $this->load->view('dashboard/v_footer');
    }

    public function pages_aksi()
    {
        // Wajib isi judul,konten
        $this->form_validation->set_rules('judul','Judul','required|is_unique[halaman.halaman_judul]');
        $this->form_validation->set_rules('konten','Konten','required');

        if($this->form_validation->run() != false){

            $judul = $this->input->post('judul');
            $slug = strtolower(url_title($judul));
            $konten = $this->input->post('konten');

            $data = array(
                'halaman_judul' => $judul,
                'halaman_slug' => $slug,
                'halaman_konten' => $konten
            );

            $this->m_data->insert_data($data,'halaman');

            // alihkan kembali ke method pages
            redirect(base_url().'dashboard/pages');

        }else{
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_pages_tambah');
            $this->load->view('dashboard/v_footer');
        }
    }

    public function pages_edit($id)
    {
        $where = array(
            'halaman_id' => $id
        );
        $data['halaman'] = $this->m_data->edit_data($where,'halaman')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pages_edit',$data);
        $this->load->view('dashboard/v_footer');
    }


    public function pages_update()
    {
        // Wajib isi judul,konten
        $this->form_validation->set_rules('judul','Judul','required');
        $this->form_validation->set_rules('konten','Konten','required');

        if($this->form_validation->run() != false){

            $id = $this->input->post('id');

            $judul = $this->input->post('judul');
            $slug = strtolower(url_title($judul));
            $konten = $this->input->post('konten');

            $where = array(
                'halaman_id' => $id
            );

            $data = array(
                'halaman_judul' => $judul,
                'halaman_slug' => $slug,
                'halaman_konten' => $konten
            );

            $this->m_data->update_data($where,$data,'halaman');

            redirect(base_url().'dashboard/pages');
        }else{
            $id = $this->input->post('id');
            $where = array(
                'halaman_id' => $id
            );
            $data['halaman'] = $this->m_data->edit_data($where,'halaman')->result();
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_pages_edit',$data);
            $this->load->view('dashboard/v_footer');
        }
    }

    public function pages_hapus($id)
    {
        $where = array(
            'halaman_id' => $id
        );

        $this->m_data->delete_data($where,'halaman');

        redirect(base_url().'dashboard/pages');
    }
    // end crud pages


    public function profil()
    {
        // id pengguna yang sedang login
        $id_pengguna = $this->session->userdata('id');

        $where = array(
            'pengguna_id' => $id_pengguna
        );

        $data['profil'] = $this->m_data->edit_data($where,'pengguna')->result();

        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_profil',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function profil_update()
    {
        // Wajib isi nama dan email
        $this->form_validation->set_rules('nama','Nama','required');
        $this->form_validation->set_rules('email','Email','required');

        if($this->form_validation->run() != false){

            $id = $this->session->userdata('id');

            $nama = $this->input->post('nama');
            $email = $this->input->post('email');

            $where = array(
                'pengguna_id' => $id
            );

            $data = array(
                'pengguna_nama' => $nama,
                'pengguna_email' => $email
            );

            $this->m_data->update_data($where,$data,'pengguna');

            redirect(base_url().'dashboard/profil/?alert=sukses');
        }else{
            // id pengguna yang sedang login
            $id_pengguna = $this->session->userdata('id');

            $where = array(
                'pengguna_id' => $id_pengguna
            );

            $data['profil'] = $this->m_data->edit_data($where,'pengguna')->result();

            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_profil',$data);
            $this->load->view('dashboard/v_footer');
        }
    }


    public function pengaturan()
    {
        $data['pengaturan'] = $this->m_data->get_data('pengaturan')->result();

        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pengaturan',$data);
        $this->load->view('dashboard/v_footer');
    }


    public function pengaturan_update()
    {
        // Wajib isi nama dan deskripsi website
        $this->form_validation->set_rules('nama','Nama Website','required');
        $this->form_validation->set_rules('deskripsi','Deskripsi Website','required');

        if($this->form_validation->run() != false){

            $nama = $this->input->post('nama');
            $deskripsi = $this->input->post('deskripsi');
            $link_facebook = $this->input->post('link_facebook');
            $link_twitter = $this->input->post('link_twitter');
            $link_instagram = $this->input->post('link_instagram');
            $link_github = $this->input->post('link_github');

            $where = array(

            );

            $data = array(
                'nama' => $nama,
                'deskripsi' => $deskripsi,
                'link_facebook' => $link_facebook,
                'link_twitter' => $link_twitter,
                'link_instagram' => $link_instagram,
                'link_github' => $link_github
            );

            // update pengaturan
            $this->m_data->update_data($where,$data,'pengaturan');

            // Periksa apakah ada gambar logo yang diupload
            if (!empty($_FILES['logo']['name'])){

                $config['upload_path']   = './gambar/website/';
                $config['allowed_types'] = 'jpg|png';

                $this->load->library('upload', $config);

                if ($this->upload->do_upload('logo')) {
                    // mengambil data tentang gambar logo yang diupload
                    $gambar = $this->upload->data();

                    $logo = $gambar['file_name'];

                    $this->db->query("UPDATE pengaturan SET logo='$logo'");
                }
            }

            redirect(base_url().'dashboard/pengaturan/?alert=sukses');

        }else{
            $data['pengaturan'] = $this->m_data->get_data('pengaturan')->result();

            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_pengaturan',$data);
            $this->load->view('dashboard/v_footer');
        }
    }

    // CRUD PENGGUNA
    public function pengguna()
    {
        $data['pengguna'] = $this->m_data->get_data('pengguna')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pengguna',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function pengguna_tambah()
    {
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pengguna_tambah');
        $this->load->view('dashboard/v_footer');
    }

    public function pengguna_aksi()
    {
        // Wajib isi
        $this->form_validation->set_rules('nama','Nama Pengguna','required');
        $this->form_validation->set_rules('email','Email Pengguna','required');
        $this->form_validation->set_rules('username','Username Pengguna','required');
        $this->form_validation->set_rules('password','Password Pengguna','required|min_length[8]');
        $this->form_validation->set_rules('level','Level Pengguna','required');
        $this->form_validation->set_rules('status','Status Pengguna','required');

        if($this->form_validation->run() != false){

            $nama = $this->input->post('nama');
            $email = $this->input->post('email');
            $username = $this->input->post('username');
            $password = md5($this->input->post('password'));
            $level = $this->input->post('level');
            $status = $this->input->post('status');

            $data = array(
                'pengguna_nama' => $nama,
                'pengguna_email' => $email,
                'pengguna_username' => $username,
                'pengguna_password' => $password,
                'pengguna_level' => $level,
                'pengguna_status' => $status
            );


            $this->m_data->insert_data($data,'pengguna');

            redirect(base_url().'dashboard/pengguna');

        }else{
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_pengguna_tambah');
            $this->load->view('dashboard/v_footer');
        }
    }

    public function pengguna_edit($id)
    {
        $where = array(
            'pengguna_id' => $id
        );
        $data['pengguna'] = $this->m_data->edit_data($where,'pengguna')->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pengguna_edit',$data);
        $this->load->view('dashboard/v_footer');
    }


    public function pengguna_update()
    {
        // Wajib isi
        $this->form_validation->set_rules('nama','Nama Pengguna','required');
        $this->form_validation->set_rules('email','Email Pengguna','required');
        $this->form_validation->set_rules('username','Username Pengguna','required');
        $this->form_validation->set_rules('level','Level Pengguna','required');
        $this->form_validation->set_rules('status','Status Pengguna','required');

        if($this->form_validation->run() != false){

            $id = $this->input->post('id');

            $nama = $this->input->post('nama');
            $email = $this->input->post('email');
            $username = $this->input->post('username');
            $password = md5($this->input->post('password'));
            $level = $this->input->post('level');
            $status = $this->input->post('status');

            if($this->input->post('password') == ""){
                $data = array(
                    'pengguna_nama' => $nama,
                    'pengguna_email' => $email,
                    'pengguna_username' => $username,
                    'pengguna_level' => $level,
                    'pengguna_status' => $status
                );
            }else{
                $data = array(
                    'pengguna_nama' => $nama,
                    'pengguna_email' => $email,
                    'pengguna_username' => $username,
                    'pengguna_password' => $password,
                    'pengguna_level' => $level,
                    'pengguna_status' => $status
                );
            }

            $where = array(
                'pengguna_id' => $id
            );

            $this->m_data->update_data($where,$data,'pengguna');

            redirect(base_url().'dashboard/pengguna');
        }else{
            $id = $this->input->post('id');
            $where = array(
                'pengguna_id' => $id
            );
            $data['pengguna'] = $this->m_data->edit_data($where,'pengguna')->result();
            $this->load->view('dashboard/v_header');
            $this->load->view('dashboard/v_pengguna_edit',$data);
            $this->load->view('dashboard/v_footer');
        }
    }

    public function pengguna_hapus($id)
    {
        $where = array(
            'pengguna_id' => $id
        );
        $data['pengguna_hapus'] = $this->m_data->edit_data($where,'pengguna')->row();
        $data['pengguna_lain'] = $this->db->query("SELECT * FROM pengguna WHERE pengguna_id != $id")->result();
        $this->load->view('dashboard/v_header');
        $this->load->view('dashboard/v_pengguna_hapus',$data);
        $this->load->view('dashboard/v_footer');
    }

    public function pengguna_hapus_aksi()
    {
        $pengguna_hapus = $this->input->post('pengguna_hapus');
        $pengguna_tujuan = $this->input->post('pengguna_tujuan');

        // hapus pengguna
        $where = array(
            'pengguna_id' => $pengguna_hapus
        );

        $this->m_data->delete_data($where,'pengguna');

        // pindahkan semua artikel pengguna yang dihapus ke pengguna yang dipilih
        $w = array(
            'artikel_author' => $pengguna_hapus
        );

        $d = array(
            'artikel_author' => $pengguna_tujuan
        );

        $this->m_data->update_data($w,$d,'artikel');

        redirect(base_url().'dashboard/pengguna');
    }
    // end crud pengguna

}