Buku Rekomendasi untuk Codeigneter, Contoh:
class Baca extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->model('selectmodel');
}
public function index(){
$data['title']='ini contoh untuk menampilkan data';
// $data['pelanggan']=$this->selectmodel->selectAll();
$data['pelanggan']=$this->selectmodel->select_in();
$this->load->view('vselect',$data);
}
}
Model
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class SelectModel extends CI_Model {
function selectAll(){
$this->db->order_by("nama_pelanggan","desc");
return $this->db->get('pelanggan')->result();
}
public function select_in(){
$code=array('123','234');
$this->db->select('*');
$this->db->from('pelanggan');
$this->db->where_not_in('nomor_pelanggan',$code);
return $this->db->get()->result();
}
public function between(){
$tgl_awal='2016-01-01';
$tgl_akhir='2018-06-02';
$this->db->select('*');
$this->db->from('pelanggan');
$this->db->where('tgl_lahir >=' ,$tgl_awal);
$this->db->where('tgl_lahir <=' ,$tgl_akhir);
return $this->db->get()->result();
}
public function between2(){
$start_date='2016-01-01';
$end_date='2018-06-02';
$this->db->select('*');
$this->db->from('pelanggan');
$this->db->where('tgl_lahir not between" '.
date('Y-m-d', strtotime($start_date)). '" and "' .
date('Y-m-d', strtotime($end_date)).'"');
return $this->db->get()->result();
}
public function select_min(){
$this->db->select_min('price');
$this->db->from('sparepart');
return $this->db->get()->result();
}
public function count(){
$this->db->count_all('sparepart');
return $this->db->get()->result();
}
public function sum(){
$key=array('honda');
$this->db->select_sum('stok');
$this->db->where('merk',$key);
$this->db->from('sparepart');
return $this->db->get()->result();
}
public function avg(){
$key=array('honda');
$this->db->select_avg('stok');
$this->db->where('merk',$key);
$this->db->from('sparepart');
return $this->db->get()->result();
}
public function group_by(){
$this->db->select('*');
$this->db->group_by("stok");
$this->db->from('sparepart');
return $this->db->get()->result();
}
public function having(){
$this->db->select('*');
$this->db->having("merk",'honda');
$this->db->from('sparepart');
return $this->db->get()->result();
}
}
+++++++++
<?php
echo "<div><blink><marquee>$title</marquee></blink></div>";
echo "<br><br>";
echo "<table border='1'>
<tr><th>No</th>
<th>nomor_pelanggan</th>
<th>nama_pelanggan</th>
<th>jenis_keanggotaan</th>
<th>telp</th>
</tr>";
$no=1;
foreach($pelanggan as $p)
{
echo "<tr>
<td>$no</td>
<td>$p->nomor_pelanggan</td>
<td>$p->nama_pelanggan</td>
<td>$p->jenis_keanggotaan</td>
<td>$p->telp</td>
</tr>";
$no++;}
echo "</table>";
+++++++++++++++++++++++++++++++++++++++++++++++
Controller
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Form extends CI_Controller {
public function index(){
$this->load->helper(array('form', 'url'));
$this->load->library('form_validation');
$this->form_validation->set_rules('username', 'Username', 'required');
$this->form_validation->set_rules('password', 'Password', 'required');
$this->form_validation->set_rules('passconf', 'Confirmation', 'required');
$this->form_validation->set_rules('email', 'Email', 'required');
if ($this->form_validation->run() == FALSE){$this->load->view('myform');}
else{$this->load->view('formsuccess');}
}
public function tanggal(){
$this->load->helper('date');
echo standard_date();
}
}
?>
View myform
<?php echo validation_errors(); ?>
<?php echo form_open('form'); ?>
<p>Username<input type="text" name="username" value="" size="50" /></p>
<p>Password<input type="text" name="password" value="" size="50" /></p>
<p>Password Confirm<input type="text" name="passconf" value="" size="50" /></p>
<p>Email Address<input type="text" name="email" value="" size="50" /></p>
<div><input type="submit" value="Submit" />
View formsuccess
<h3>Your form was successfully submitted!</h3>
<p><?php echo anchor('form', 'Try it again!'); ?></p>
Comments
Post a Comment