[ask] bikin simple aplikasi (edit data)

July 2, 2009 by gedoyman

Halo All.... Saya Pendatang baru di codeigniter, Saya lagi belajar bikin aplikasi untuk insert, update, delete. Tapi kepentok pas mau edit data.. tolong bantuannya....

Databasenya :
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 03, 2009 at 07:20 AM
-- Server version: 4.1.11
-- PHP Version: 5.0.4
--
-- Database: `tes`
--

-- --------------------------------------------------------

--
-- Table structure for table `biodatas`
--

CREATE TABLE `biodatas` (
`id` int(5) NOT NULL auto_increment,
`nama` varchar(50) collate latin1_general_ci NOT NULL default '',
`alamat` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `biodatas`
--

INSERT INTO `biodatas` VALUES (1, 'nmbmnbm', 'hkjhkjhjk');

model : mtes.php
<?
class MTes extends Model{
function MTes(){
parent::Model();
}

function TampilData($namaTable){
$query = $this->db->get($namaTable);
return $query;
}

function TampilDataWhere($namaTable, $namaWhere){
$this->db->where('id', $namaWhere);
$query = $this->db->get($namaTable);
return $query;
}

function Edit($namaTable, $namaWhere, $fields){

$this->db->where('id', $namaWhere);
$this->db->update('mytable', $fields);
}
}
?>

controller : tes.php
<?
class Tes extends Controller{
function Tes(){
parent::Controller();
$this->load->helper('url');
$this->load->helper('form');
}

function index(){

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

$data['hasil'] = $this->MTes->TampilData('biodatas');
$this->load->view('v_tampil', $data);
}

function edit(){
$this->load->model('MTes');
$data['hasil'] = $this->MTes->TampilDataWhere('biodatas', $this->uri->segment(3));
$this->load->view('v_edit', $data);
}

function proc_edit(){
$this->load->model('MTes');
$array = array(
'nama' => $_POST[txt_nama],
'alamat' => $_POST[txt_alamat]
);
$this->MTes->Edit('biodatas', $this->uri->segment(3), $array);
redirect('tes/index/');
}
}
?>

views: v_tampil.php

New Document

<? foreach($hasil->result() as $row): ?>

<?=$row->id?>
<?=$row->nama?>
<?=$row->alamat?>
<?=anchor('tes/edit/'.$row->id, 'Edit')?>
<?=anchor('tes/delete/'.$row->id, 'Delete')?>

<? endforeach; ?>

views : v_edit.php

New Document

uri->segment(3)?>">
<? foreach($hasil->result() as $row): ?>

Makasih seelumnya

Nama
nama?>"/>

Alamat
<?=$row->alamat?>

<? endforeach; ?>