Coretan CI

 // WHERE name = 'Joe' AND title = 'boss' AND status = 'active'

$this->db->where('name', $name);

$this->db->where('title', $title);

$this->db->where('status', $status);

$this->db->where('name !=', $name);

$this->db->where('id <', $id); // Produces: WHERE name != 'Joe' AND id < 45

$array = array('name' => $name, 'title' => $title, 'status' => $status);

$this->db->where($array);

// Produces: WHERE name = 'Joe' AND title = 'boss' AND status = 'active'

$array = array('name !=' => $name, 'id <' => $id, 'date >' => $date);

$this->db->where($array);

$where = "name='Joe' AND status='boss' OR status='active'";

$this->db->where($where);

$this->db->select('id_absensi');

$this->db->from('tb_absensi');

$where = "sessi='I' OR sessi='II' OR sessi='III' OR sessi='IV' OR sessi='V' OR sessi='VI' OR sessi='VII' OR sessi='VIII'";

$this->db->where($where);

echo $this->db->count_all_results();

++++++++++++++++

$where = array('username ' => $username , 'status ' => $status);

$this->db->where($where);

$this->db->where('username',$username);

$this->db->where('status',$status);

$this->db->select('*');

$this->db->from('Employees');

$this->db->like('Designation', 'Manager');

echo $this->db->count_all_results();

$this->db->select('id_absensi');

$this->db->from('tb_absensi');

$this->db->where('sessi','I');

$this->db->where('sessi','II');

$this->db->where('sessi','III');

$this->db->where('sessi','IV');

$this->db->where('sessi','V');

$this->db->where('sessi','VI');

$this->db->where('sessi','VII');

$this->db->where('sessi','VIII');

echo $this->db->count_all_results();

 public function add_register(){

        $exe = $this->tamu_model;

        $exe->saveregister();

$ar=$this->db->query("SELECT `id_tamu` FROM `tb_tamu` order by `id_tamu` desc")->row();

$id_tamu=$ar->id_tamu;

//================================

$exe = $this->kunjungan_model;

$exe->savekunjunganreg($id_tamu);

$this->load->view('register.php');

       // $this->load->view('indexuser.php');

    }

if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on')

$link = "https";

    else $link = "http";

    $link .= "://";

    $link .= $_SERVER['HTTP_HOST'];

    $link .= $_SERVER['REQUEST_URI'];

   

$ar=explode("index.php",$link);

$path= $ar[0]."index.php";

===============

controller

$nidn=$this->session->userdata('cid');

        $data["listpengampu"] = $this->pengampu_model->getBuilder("nidn",$nidn);

        $this->load->view("admin/matkul/listdosen", $data);

model

  public function getBuilder($field,$item)  {

        return $this->db->get_where($this->_table, ["$field" => $item])->result();

    }

pada view :

foreach ($listpengampu as $matkul): 

$id_matkul=$matkul->id_matkul;

$id_pengampu=$matkul->id_pengampu;

$hari=$matkul->hari;

$jam=$matkul->jam;

$nidn=$matkul->nidn;

$keteranganpengampu=$matkul->keterangan;

$exe = $this->matkul_model; 

$ar = $exe->getById($id_matkul);

$nama_matkul=$ar->nama_matkul;

$deskripsi=$ar->deskripsi;

$sks=$ar->sks;

$semester=$ar->semester;

$status=$ar->status;

$keterangan=$ar->keterangan; 

$keterangan=substr($keterangan, 0, 120);

=============================

controller

$data["listakademik"] = $this->akademik_model->getAktif();

model

public function getAktif()  {

      return $this->db->get_where($this->_table, ["status" => "Aktif"])->row();

    }

view

$id_akademik=$listakademik->id_akademik;

$nama_akademik=$listakademik->nama_akademik;

$deskripsi=$listakademik->deskripsi;

=============================

Session adalah data yang disimpan dalam suatu server yang dapat digunakan secara global di server tersebut, dimana data tersebut spesifik merujuk ke user/client tertentu.

Contoh penggunaan session adalah ketika user telah login di halaman tertentu, maka ketika membuka halaman lain, Web Server akan mengingat bahwa user tersebut telah login.

Contoh ketika kita telah login pada Google, maka setiap kali kita membuka layanan Google seperti GMail, Google Drive, dll di tab berbeda, kita akan selalu dalam keadaan login, kecuali kita buka dengan browser yang berbeda.

Contoh lain ketika web ecommerce merekam keranjang belanja user, maka ketika pindah ke halaman pembayaran, daftar belanja masih terekam

HttpSession session=request.getSession(false);  

        if(session!=null){  

        String name=(String)session.getAttribute("name");  

          

        out.print("Hello, "+name+" Welcome to Profile");  

        }  

        else{  

            out.print("Please login first");  

            request.getRequestDispatcher("login.html").include(request, response);  

        }  

HttpSession session=request.getSession();  

            session.invalidate();  

              

            out.print("You are successfully logged out!");