Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Maaf numpang nanya caranya upload foto di CI gimana yaa? saya bingung di MVC nya
Controller (Siswa.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Siswa extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->model('MSiswa');
}
public function index()
{
if($this->session->userdata('Login'))
{
$data['content']='VBlank';
$this->load->view('VBackend',$data);
}
else
{
redirect(site_url('Login'));
}
}
public function DataSiswa()
{
if($this->uri->segment(4)=='view')
{
$nisn=$this->uri->segment(3);
$tampil=$this->MSiswa->GetDataWhere('nisn',$nisn)->row();
$data['detail']['nisn']= $tampil->nisn;
$data['detail']['nis']= $tampil->nis;
$data['detail']['nama']= $tampil->nama;
$data['detail']['id_kelas']= $tampil->id_kelas;
$data['detail']['alamat']= $tampil->alamat;
$data['detail']['no_telp']= $tampil->no_telp;
$data['detail']['id_spp']= $tampil->id_spp;
$data['detail']['id_login']= $tampil->id_login;
$data['content']='Siswa/VFormUpdateSiswa';
}
else
{
$data['DataSiswa']=$this->MSiswa->GetData('siswa');
$data['content']='Siswa/VSiswa';
}
$this->load->view('VBackend',$data);
}
public function VFormAddSiswa()
{
$data['content']='Siswa/VFormAddSiswa';
$data['list_spp'] = $this->MSiswa->list_spp();
$data['list_kelas'] = $this->MSiswa->list_kelas();
$data['list_login'] = $this->MSiswa->list_login();
$this->load->view('VBackend',$data);
}
public function AddDataSiswa()
{
$add['nisn']=$this->input->post('nisn');
$add['nis']= $this->input->post('nis');
$add['nama']= $this->input->post('nama');
$add['id_kelas']= $this->input->post('id_kelas');
$add['alamat']= $this->input->post('alamat');
$add['no_telp']= $this->input->post('no_telp');
$add['id_spp']= $this->input->post('id_spp');
$add['id_login']= $this->input->post('id_login');
$this->MSiswa->AddData('siswa',$add);
redirect(site_url('Siswa/DataSiswa'));
}
public function UpdateDataSiswa()
{
$nisn=$this->input->post('nisn');
$update['nis']= $this->input->post('nis');
$update['nama']= $this->input->post('nama');
$update['id_kelas']= $this->input->post('id_kelas');
$update['alamat']= $this->input->post('alamat');
$update['no_telp']= $this->input->post('no_telp');
$update['id_spp']= $this->input->post('id_spp');
$update['id_login']= $this->input->post('id_login');
$this->MSiswa->UpdateData('siswa','nisn',$nisn,$update);
redirect(site_url('Siswa/DataSiswa'));
}
public function DeleteDataSiswa()
{
$nisn=$this->uri->segment('3');
$this->MSiswa->DeleteData('siswa','nisn',$nisn);
redirect(site_url('Siswa/DataSiswa'));
}
}
Model (MSiswa.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class MSiswa extends CI_Model
{
function AddData($tabel, $data=array())
{
$this->db->insert($tabel,$data);
}
function UpdateData($tabel,$fieldid,$fieldvalue,$data=array())
{
$this->db->where($fieldid,$fieldvalue)->update($tabel,$data);
}
function DeleteData($tabel,$fieldid,$fieldvalue)
{
$this->db->where($fieldid,$fieldvalue)->delete($tabel);
}
function GetData($tabel)
{
$query= $this->db->get($tabel);
return $query->result();
}
function GetDataWhere($id,$nilai)
{
$this->db->from('kelas as a, spp as b, tbl_login as c, siswa as d');
$this->db->where('a.id_kelas = `d`.`nisn`');
$this->db->where('b.id_spp = `d`.`nisn`');
$this->db->where('c.id_login = `d`.`nisn`');
$this->db->where($id,$nilai);
$query= $this->db->get();
return $query;
}
function list_kelas()
{
return $this->db->get('kelas')->result();
}
function list_spp()
{
return $this->db->get('spp')->result();
}
function list_login()
{
return $this->db->get('tbl_login')->result();
}
}
View (Siswa/VSiswa.php)
<section class="content-header">
<h1>
Infomasi SPP <small>Data Siswa</small>
</h1>
</section>
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
<h3 class="box-title"></h3>
</div>
<!-- /.box-header -->
<div class="box-body table-responsive no-padding">
<a href="<?php echo site_url('Siswa/VFormAddSiswa'); ?>" class="btn btn-primary btn-sm fa fa-plus"> Tambah Data</a><br><br>
<table class="table table-striped">
<tr>
<th>NISN</th>
<th>NIS</th>
<th>Nama Lengkap</th>
<th>ID Kelas</th>
<th>Alamat</th>
<th>No. Telepon</th>
<th>ID SPP</th>
<th>ID Login</th>
<th>Photo</th>
<th>Aksi</th>
</tr>
<?php
if(!empty($DataSiswa))
{
foreach($DataSiswa as $ReadDS)
{
?>
<tr>
<td><?php echo $ReadDS->nisn; ?></td>
<td><?php echo $ReadDS->nis; ?></td>
<td><?php echo $ReadDS->nama; ?></td>
<td><?php echo $ReadDS->id_kelas; ?></td>
<td><?php echo $ReadDS->alamat; ?></td>
<td><?php echo $ReadDS->no_telp; ?></td>
<td><?php echo $ReadDS->id_spp; ?></td>
<td><?php echo $ReadDS->id_login; ?></td>
<td width="5%">
<a href="<?php echo site_url('Siswa/DataSiswa/'.$ReadDS->nisn.'/view') ?>">Update</a>
<td>
<a href="<?php echo site_url('Siswa/DeleteDataSiswa/'.$ReadDS->nisn) ?>">Delete</a>
</td>
</tr>
<?php
}
}
?>
</table>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
</div>
Database
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban