Skip to main content

[ask] tambahin edit gmana yak tulung... mentok neh

February 20, 2010 by adit_dika

adit_dika's picture

saya bwat program neh dan baru belajar, tpi pas waktu tambahin edit gamana yaks mentok banget om tolong ajarin yak....

contorler/form.php

class Form extends Controller {
 
	function Form()
	{
		parent::Controller();	
		$this->load->helper('url') ;
	}
	function index()
	{
		$this->load->view('form_input');
	}
 
	function input(){
		$this->load->model('form_model') ;
		$data['title']='form administrasi DITMAWA';
		//$jns_lomba = $this->input->post('pkm')!='' ? $this->input->post('pkm') : $this->input->post('kktm') ;
 
		if(($this->input->post('pkm') =='')&& ($this->input->post('lainnya') =='')){
			$jns_lomba = $this->input->post('kktm');
		} 
		else {
			if(($this->input->post('pkm') =='')&& ($this->input->post('kktm') =='')){
				$jns_lomba = $this->input->post('lainnya');
			} 
			else $jns_lomba = $this->input->post('pkm');
		}
 
 
		$data = array(
			'NO' => $this->input->post('no'),
			'pelaksana_kegiatan' => $this->input->post('pelaksana_kegiatan'),
			'tingkat_lembaga' => $this->input->post('tingkat_lembaga'),
			'jenis_laporan' => $this->input->post('jenis_laporan'),
			'nama_kegiatan' => $this->input->post('nama_kegiatan'),
			'bentuk_kegiatan' => $this->input->post('bentuk_kegiatan'),
			'kode_kegiatan' => $this->input->post('kode_kegiatan'),
			'tujuan_kegiatan' => $this->input->post('tujuan_kegiatan'),
			'tanggal' => $this->input->post('tanggal'),
			'jumlah_mahasiswa' => $this->input->post('jumlah_mahasiswa'),
			'jumlah_dosen' => $this->input->post('jumlah_dosen'),
			'jumlah_pembicara' => $this->input->post('jumlah_pembicara'),
			'jumlah_panitia' => $this->input->post('jumlah_panitia'),
			'jumlah_masyarakat' => $this->input->post('jumlah_masyarakat'),
			'anggaran_ipb' => $this->input->post('anggaran_ipb'),
			'anggaran_sponsor' => $this->input->post('anggarn_sponsor'),
			'swadaya_mahasiswa' => $this->input->post('swadaya_mahasiswa'),
			'anggaran_donatur' => $this->input->post('anggaran_donatur'),
			'total_dana' => $this->input->post('total_dana'),
			'saldo' => $this->input->post('saldo'),
			);
 
		$this->form_model->add_form($data);
		$form = $this->input->post('form_id');
		$this->load->view('sukses_submit');
	}
 
 
		function inputedit(){
		$this->load->model('form_model') ;
		$edit['title']='form administrasi DITMAWA';
		//$jns_lomba = $this->input->post('pkm')!='' ? $this->input->post('pkm') : $this->input->post('kktm') ;
 
		if(($this->input->post('pkm') =='')&& ($this->input->post('lainnya') =='')){
			$jns_lomba = $this->input->post('kktm');
		} 
		else {
			if(($this->input->post('pkm') =='')&& ($this->input->post('kktm') =='')){
				$jns_lomba = $this->input->post('lainnya');
			} 
			else $jns_lomba = $this->input->post('pkm');
		}
 
		$data = array(
			'NO' => $this->input->post('no'),
			'pelaksana_kegiatan' => $this->input->post('pelaksana_kegiatan'),
			'tingkat_lembaga' => $this->input->post('tingkat_lembaga'),
			'jenis_laporan' => $this->input->post('jenis_laporan'),
			'nama_kegiatan' => $this->input->post('nama_kegiatan'),
			'bentuk_kegiatan' => $this->input->post('bentuk_kegiatan'),
			'kode_kegiatan' => $this->input->post('kode_kegiatan'),
			'tujuan_kegiatan' => $this->input->post('tujuan_kegiatan'),
			'tanggal' => $this->input->post('tanggal'),
			'jumlah_mahasiswa' => $this->input->post('jumlah_mahasiswa'),
			'jumlah_dosen' => $this->input->post('jumlah_dosen'),
			'jumlah_pembicara' => $this->input->post('jumlah_pembicara'),
			'jumlah_panitia' => $this->input->post('jumlah_panitia'),
			'jumlah_masyarakat' => $this->input->post('jumlah_masyarakat'),
			'anggaran_ipb' => $this->input->post('anggaran_ipb'),
			'anggaran_sponsor' => $this->input->post('anggarn_sponsor'),
			'swadaya_mahasiswa' => $this->input->post('swadaya_mahasiswa'),
			'anggaran_donatur' => $this->input->post('anggaran_donatur'),
			'total_dana' => $this->input->post('total_dana'),
			'saldo' => $this->input->post('saldo'),
			);
 
		$this->form_model->edit_data($data);
		$this->load->view('sukses_submit');
	}
 
	function show()
	{	
		/*$this->load->library('table');
		$this->load->model('form_model');
		echo $this->form_model->ambilData();
		$this->load->view('tampil'); */
		$this->load->model('form_model');
		$data['query'] = $this->form_model->ambilData();
		$this->load->view('form_view',$data);
	}
 
	function edit()
	{	
		/*$this->load->library('table');
		$this->load->model('form_model');
		echo $this->form_model->edit_data();
		$this->load->view('form_inputedit'); */
		$id=$this->uri->segment(3);
        $this->load->database();
        $this->load->model('edit');
        $this->load->library('form_validation');
		$this->load->model('form_model');
		$this->db->get('form');
		$data ['query'] = $this->form_model->ambilDataedit();
		$this->load->view('form_input',$data);
	}
 
	function phpexcel()
	{
	$this->db->use_table('form');
	$this->db->select('*');
	$query = $this->db->get(); 
	to_excel($query); // outputs exceloutput.xls 
	}
}

model form_model.php

Class Form_model extends model 
{
	function __construct() 
	{
	parent::Model();
	//load database
	$this->load->database();
	}
 
	function add_form($data){
	$this->db->insert('form',$data);
	}
 
 
	function edit_data($id){
	$this->load->database();
    $this->db->where('form',$id);
    $query = $this->db->get('form');
	}
 
 
	function ambilData()
	{
 
		//$this->load->library('table');
		$this->load->database();
		$query=$this->db->get('form');
		/*
		$tmpl = array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );
		$this->table->set_template($tmpl);
		$table=$this->table->generate($query);
		return $table;
		*/
		return $query->result();
	}
 
	function ambilDataedit()
	{
 
		//$this->load->library('table');
		$this->load->database();
		$query= $this->db->get('form',$edit_data);
		/*
		$tmpl = array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );
		$this->table->set_template($tmpl);
		$table=$this->table->generate($query);
		return $table;
		*/
		return $query->result();
 	}
}

view/form_input.php

form pengisian administrasi lembaga kemahasiswaan ditmawa ipb

#tengah{
background-color:#f2f0f0;
padding:20px 10px 20px 90px
}

">

DIREKTORAT KEMAHASISWAAN
INSTITUT PERTANIAN BOGOR

-

FORM ADMINISTRASI LEMBAGA KEMAHASISWAAN IPB
">

Data Lembaga Kemahasiswaan

Pelaksana Kegiatan:

MPM KM
DPM KM
BEM KM
DPM TPB
BEM TPB
BKIM
PMK
KEMAKI
KMHD
KMB
INKAI
MERPATI PUTIH
BOXER-TARUNG DERAJAT
SEROJA PUTIH
TAEKWONDO
SEPAKBOLA
BULUTANGKIS
CUA-Catur
PTM-Tenis Meja
Futsal
Panahan
Tenis Lapangan
Bola Voli
Softball Oriza
Basket
Agria Swara
Gentra Kaheman
MAX!!
Pramuka
Century
Lawalata
KSR PMI Unit 1 IPB
UKF
Resimen Mahasiswa
FORCES
IAAS
Koperasi Mahasiswa
Koran Kampus IPB
IPB Debating Community

BEM FAPERTA
DPM FAPERTA
HMIT
HIMAGRON
HIMASITA
HIMASKAP

BEM FKH
DPM FKH
SATLI
HKSA
Ornith
Ruminansia

BEM FPIK
DPM FPIK
HIMAKUA
HIMASPER
HIMASILKAN
HIMAFARIN
HIMITEKA

BEM FAPET
DPM FAPET
Himaproter
Himasiter

BEM FAHUTAN
DPM FAHUTAN
HIMAKOVA
HIMASILTAN
TGC
FMSC

BEM FATETA
DPM FATETA
HIMATETA
HIMALOGIN
HIMITEPA

BEM FMIPA
DPM FMIPA
Gamma Sigma Beta
HIMAGRETO
HIMABIO
IMASIKA
GUMATIKA
HIMALKOM
HIMAFI
CREB'S

BEM FEM
DPM FEM
HIPOTESA
COM@
HIPMA
REESA

BEM FEMA
DPM FEMA
HIMAGIZI
HIMAIKO
HIMASIERA

BEM Diploma
DPM Diploma

Tingkat Lembaga:

KM
Fakultas Pertanian
Fakultas Kedokteran Hewan
Fakultas Perikanan dan Ilmu Kelautan
Fakultas Peternakan
Fakultas Kehutanan
Fakultas Teknologi Pertanian
Fakultas Matematika dan IPA
Fakultas Ekonomi Manajemen
Fakultas Ekologi Manusia
Diploma
Tingkat Persiapan Bersama

Jenis Laporan:

RKAT
Proposal
Laporan Pertanggungjawaban

Nama Kegiatan
:

Bentuk Kegiatan
:

Kode Kegiatan
:

Softskills
1.1
1.2
1.3
1.4
1.5
Multibudaya
Minat Bakat
2.1
2.2
2.3
2.4
2.5

Tujuan Kegiatan
:

Tanggal Pelaksanaan:
contoh : 17 Agustus 2012, maret-desember, selama kepengurusan

PESERTA KEGIATAN

Peserta Mahasiswa:
contoh : 100 (jangan pake titik atau koma)

Keterlibatan Dosen:

Jumlah Narasumber:

Jumlah Panitia:

Keterlibatan Masyarakat:

SUMBER DANA

Dana IPB:
contoh : 10000000 (jangan pake titik atau koma)

Dana Sponsorship:

Swadaya Mahasiswa:

Lain-lain:

Total Penggunaan Dana:

Saldo:

">tampilkan semua data

view/form_view.php

table {
font-family: Georgia, Times New Roman, Times, serif, "Verdana";
font-size: 12px;

}
td, th {
padding-left:5px;
padding-right:5px;
padding-top:5px;
padding-bottom:5px;
}

#output_table{

padding: 1%;
clear: both;
width:98%;
/*overflow: auto; */
}
#output_table1 table td, #output_table1 table th{
border: 1px solid #13a8d9;
}
table.tablesorter tr.odd {
background-color: #13a8d9;
}
thead{
background-color: #13a8d9;
}

DATA ADMINISTRASI LEMBAGA KEMAHASISWAAN IPB

<?
$base = base_url();
echo anchor('form/phpexcel',"excel  Format Excel");
?>  
index.php">kembali untuk mengisi data

NO
PELAKSANA KEGIATAN
TINGKAT LEMBAGA
JENIS LAPORAN
NAMA KEGIATAN
BENTUK KEGIATAN
KODE KEGIATAN
TUJUAN KEGIATAN
TANGGAL PELAKSANAAN KEGIATAN
PESERTA MAHASISWA
KETERLIBATAN DOSEN
JUMLAH PEMBICARA
JUMLAH PANITIA
KETERLIBATAN MASYARAKAT
DANA IPB
DANA SPONSOR
SWADAYA MAHASISWA
DANA Lain-lain
TOTAL PENGGUNAAN DANA
SALDO
Edit

 
			$i = 0;
			foreach( $query as $row) {
				if($i++%2 > 0){
					$baris = "odd";
				}
				else{
					$baris = "";
				}
 
 

">
<?=$row->no;?>
<?=$row->pelaksana_kegiatan;?>
<?=$row->tingkat_lembaga;?>
<?=$row->jenis_laporan;?>
<?=$row->nama_kegiatan;?>
<?=$row->bentuk_kegiatan;?>
<?=$row->kode_kegiatan;?>
<?=$row->tujuan_kegiatan;?>
<?=$row->tanggal;?>
<?=$row->jumlah_mahasiswa;?>
<?=$row->jumlah_dosen;?>
<?=$row->jumlah_pembicara;?>
<?=$row->jumlah_panitia;?>
<?=$row->jumlah_masyarakat;?>
<?=$row->anggaran_ipb;?>
<?=$row->anggaran_sponsor;?>
<?=$row->swadaya_mahasiswa;?>
<?=$row->anggaran_donatur;?>
<?=$row->total_dana;?>
<?=$row->saldo;?>

">Edit

			}
 

terimakasih saran dan bantuannya

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

BLS:

February 24, 2010 by syabac, 1 year 49 weeks ago
Comment: 5961

syabac's picture

kayaknya tau nih project punya siapa..ckckckc (OOT)

Coba jawab ya..
asumsi setiap record di table kan punya ID,.
saat ingin mengedit, kan akses ke http://serverku/index.php/form/edit/10
bila ada data diload dari DB kemudian ditampilkan ke form.
saat disubmit actionnya kemana? seandainya ke URL yang sama, berarti di method edit ada prosedur untuk
memvalidasi dan menyimpan data yg disubmit tersebut.

kira2 seperti ini:

    //Form::edit method
    function edit()
    {   
        $this->load->database();
        $this->load->model('edit');
        $this->load->library('form_validation');
        $this->load->model('form_model');
        $id = $this->uri->segment(3);
 
        if($_SERVER['REQUEST_METHOD'] == 'POST')
        {
            $reg_data    = array(
                'NO' => $this->input->post('no'),
                ...
                ...
                ...
                ...
            );
 
            $this->form_model->update($reg_data);
            $data['message']    = 'Data has been updated';
        }
 
        $this->db->get('form');
        $data ['query'] = $this->form_model->ambilDataedit();
        $this->load->view('form_input',$data);
    }
 
 
 
    // Form_edit::update method
    function update($id, $reg_data=array())
    {
        $this->db->update('tablenya', $reg_data, array('ID' => $id));
    }

semoga membantu..

mohon bantuanny

April 22, 2010 by cuplis, 1 year 41 weeks ago
Comment: 6287

cuplis's picture

salam kenal
saya punya tabel ID,nama,Status
di field status isinya hanya A dan D
active dan tidak Deactive

jika saya masukan ID
lalu status tersebut otomatis berubah menjadi Deactive

mohon pencerahannya

thanks

February 24, 2010 by adit_dika, 1 year 49 weeks ago
Comment: 5962

adit_dika's picture

nanti dicoba gan...., kayaknya juga kenal nieh orangnya juga... makasih yaks...

weleh..... datannya banyak

February 20, 2010 by satandik, 1 year 50 weeks ago
Comment: 5946

satandik's picture

weleh..... datannya banyak bener..... he3
males ngetiknya..... :)
Ini ada referensi manipulasi data add, edit, delete...... mudah dipahami :
http://gie-art.com/codeigniter-3-contoh-aplikasi-manipulasi-database-ins...

semoga membantu.....

makasih

February 24, 2010 by adit_dika, 1 year 49 weeks ago
Comment: 5963

adit_dika's picture

dipelajari dulu ahhhhh nanti aq terapin gan.. (beer)

Premium Drupal Themes by Adaptivethemes