Skip to main content

Very Simple Sample CRUD codeigniter 2

TUTORIAL SAMPLE CRUD WITH CODEIGNITER 2.0

start by create sample mysql database bellowed :

CREATE TABLE IF NOT EXISTS `tbl_person` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `gender` char(1) DEFAULT NULL, `dob` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; INSERT INTO `tbl_person` (`id`, `name`, `gender`, `dob`) VALUES (1, 'henrihnr', 'm', '1985-09-09'), (2, 'name_001', 'm', '1990-01-01'), (3, 'name_002', 'f', '2000-01-01'), (4, 'name_003', 'm', '2000-02-02'), (5, 'name_005', 'f', '2000-04-04'), (6, 'khushbu', 'f', '1983-08-10'), (10, 'rahul mehta', 'm', '1983-05-16'), (11, 'jatin', 'm', '1983-05-16');


application/views/personadd.php

<html> <head> <title>person add</title> </head> <body> <h1>Person add</h1><a href="/">list</a> <form name="add" method="POST" action="insert"> <table border="1"> <tr> <th>name</th> <td><input type="text" name="name"/></td> <tr> <th>gender </th> <td><input type="text" name="gender"/></td> <tr> <th>dob </th> <td><input type="text" name="dob"/></td> </tr> <tr> <td><input type="submit"></td> <td><input type="reset"></td> </tr> </form> </table> </body </html>


application/views/personedit.php

<html> <head> <title>person edit</title> </head> <body> <h1>Person edit</h1><a href="/">list</a> <form name="add" method="POST" action="/index.php/person/update"> <input type="hidden" name="id" value="<?php echo $person[0]->id ?>"> <table border="1"> <tr> <th>name</th> <td><input type="text" name="name" value="<?php echo $person[0]->name;?>"/></td> <tr> <th>gender </th> <td><input type="text" name="gender" value="<?php echo $person[0]->gender;?>"/></td> <tr> <th>dob </th> <td><input type="text" name="dob" value="<?php echo $person[0]->dob;?>"/></td> </tr> <tr> <td><input type="submit"></td> <td><input type="reset"></td> </tr> </form> </table> </body </html>


application/views/personlist.php

<html> <head> <title>person list</title> </head> <body> <h1>Person list</h1><a href="/index.php/person/add">Add</a> <table border="1"> <tr> <th>name</th> <th>gender </th> <th>dob </th> <th>edit </th> <th>delete </th> </tr> <?php //print_r($persons); for($i=0; $i<count($persons);$i++) { ?> <tr> <td><?php echo $persons[$i]->name;?></td> <td><?php echo $persons[$i]->gender;?></td> <td><?php echo $persons[$i]->dob;?></td> <td><a href="/index.php/person/edit/<?php echo $persons[$i]->id;?>">edit</a></td> <td><a href="/index.php/person/delete/<?php echo $persons[$i]->id;?>" onclick="return confirm('are you sure to delete')">delete</a></td> </tr> <?php }?> </table> </body> </html>


application/controllers/person.php

<?php class Person extends CI_Controller { public function index() { $this->load->database(); $this->load->model('PersonModel'); $persons=$this->PersonModel->get_last_ten_entries(); $this->load->view('personlist',array('persons'=>$persons)); } public function add() { //$this->load->database(); //$this->load->model('PersonModel'); $this->load->view('personadd'); } public function edit($id) { $this->load->database(); $this->load->model('PersonModel'); $person=$this->PersonModel->get($id); $this->load->view('personedit',array('person'=>$person)); } public function insert() { $this->load->database(); $this->load->model('PersonModel'); $this->PersonModel->insert_entry(); $persons=$this->PersonModel->get_last_ten_entries(); $this->load->view('personlist',array('persons'=>$persons)); } public function update() { $this->load->database(); $this->load->model('PersonModel'); $this->PersonModel->update_entry(); $persons=$this->PersonModel->get_last_ten_entries(); $this->load->view('personlist',array('persons'=>$persons)); } public function delete($id) { $this->load->database(); $this->load->model('PersonModel'); $this->PersonModel->delete_entry($id); $persons=$this->PersonModel->get_last_ten_entries(); $this->load->view('personlist',array('persons'=>$persons)); } } ?>


application/model/personModel.php

<?php class PersonModel extends CI_Model { var $gender = ''; var $name = ''; var $dob = ''; function __construct() { // Call the Model constructor parent::__construct(); } function get_last_ten_entries() { $query = $this->db->get('tbl_person', 100); return $query->result(); } function get($id){ echo $id; $sql = "SELECT * FROM tbl_person WHERE id = ?"; $query =$this->db->query($sql, array($id)); echo $this->db->last_query(); return $query->result(); } function insert_entry() { $this->name = $_POST['name']; // please read the below note $this->gender = $_POST['gender']; $this->dob = $_POST['dob']; $this->db->insert('tbl_person', $this); } function update_entry() { $this->name = $_POST['name']; // please read the below note $this->gender = $_POST['gender']; $this->dob = $_POST['dob']; $this->db->update('tbl_person', $this, array('id' => $_POST['id'])); } function delete_entry($id) { $this->db->delete('tbl_person', array('id' => $id)); } } ?>


quoted by

SISINDOTEK - IT Training & Solution Provider

Office 1 : Jl. Pelajar Pejuang 45 No.23 , Lt.2 Bandung - Jawa Barat

Office 2 : Jl. Sukasenang VI-6B Bandung - Jawa Barat 40124
Tel. 022-71242266, SMS. 0812.8733.1966
info , YM. sisindotek
www.sisindotek.com , facebook.com/sisindotek , twitter.com/sisindotek
Labels:

Comments

Post a Comment

Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick

Popular posts from this blog

Download JDK

Download Java Development Kit (JDK) Masuk ke situs http://java.sun.com/javase/downloads/index.jsp Pilih paket JDK terbaru (pada saat penulisan JDK sudah memasuki versi 6 update 5 seperti terlihat pada gambar di bawah ini). Klik tombol Download. Pilih paket sesuai sistem operasi yang kita gunakan. Untuk contoh, saya pilih Microsoft Windows. Klik "Accept" dan pilih link "Windows Offline Installation, Multi Language" Sering sekali kita masih diminta registrasi account di Sun untuk melanjutkan download. Apabila kita sudah memiliki account Sun kita tinggal login saja, tetapi apabila belum maka lakukan registrasi terlebih dulu. Download paket JDK. Instalasi JDK Jalankan setup program jdk-6u5-windows-i586-p.exe atau sesuai yang Anda download. Muncul dialog awal instalasi JDK Tekan Accept untuk menerima persetujuan lisensi dari Sun. Pilih semua fitur yang kita inginkan pada langkah Custom Setup Tekan next untuk melanjutkan. Perhatikan bahwa folder instalasi adalah di C:\Pro
Post a Comment
Detail Alamat »

Project Management With Primavera P6

Perencanaan proyek dengan Primavera P6 Professional Primavera P6 Professional adalah modul Client-Server Primavera P6 EPPM. Proyek berskala besar dan kompleks membutuhkan solusi manajemen proyek. Oracle Primavera P6 Professional dirancang dengan fokus pada proyek berskala besar, multidisiplin dan multi-aspek. Ini memberi manajer proyek dan perencana apa yang paling mereka butuhkan - kontrol. - Proyek besar, data ekstensif Primavera P6 Professional (penerus Primavera Project Planner yang terkenal, P3) adalah standar yang diakui untuk perangkat lunak manajemen proyek integral kinerja tinggi dan menggunakan teknologi ICT terbaru. Perangkat lunak Microsoft Windows ini dapat digunakan untuk beberapa proyek dengan 100.000 kegiatan dan sumber daya yang tidak terbatas. Banyak jenis data memerlukan alat yang canggih tetapi sangat fleksibel sehingga kegiatan, proyek, dan sumber daya dapat diatur, dipilih, dan disortir dengan cara yang berbeda, sehingga memberikan wawasan yang paling jelas ke dal
Post a Comment
Detail Alamat »

MS Project : Setting Up Overtime Pay Rates and Assigning Resource Overtime Hours

I will explain how can you assign overtime hours and overtime Pay Rate to Resource in MS PROJECT 2010 First I will add TASK 1 with 5 days duration: Now I will add Mary as a resource with $100/hour as standard pay rate, and $150 / hour as overtime pay rate: Now I will assign Mary to the TASK 1: You can see $400 in the Cost field (5 days X 8 hours/day X $100 / hour = $4.000) Now, I will choose the Gant chart view open the Task form ad a detailed view: I will click ANYWHERE in the Task Form and then I will click on the Format Tab, in the Details Group –> WORK: Now I will put 16 hours in the Overtime work field. It means that Mary will work 16 hours overtime: It seems like nothing happened in the Gant chart? I will now click anywhere in the Gantt chart portion of the screen and I will get: You can see that TASK 1 will have only 3 days duration. Why? Well, if you add overtime work on the task the same amount of work will be done but in shorter period. I will now close the Task form:
Post a Comment
Detail Alamat »