本文实例讲述了CodeIgniter框架基本增删改查操作。分享给大家供大家参考，具体如下：
对于codeigniter的增删改，在此我用自己的一个例子来说明一下：
创建数据库：
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `fullname` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Model
MTest.php
<?php class MTest extends CI_Model{ public function __construct(){ parent::__construct(); $this->load->database(); } //insert into data public function insert_users($arr){ $this->db->insert("users",$arr); } //delete data public function delete_users($id){ $this->db->where("id",$id); $this->db->delete("users"); } //Alter data public function update_users($username,$arr){ $this->db->where("username",$username); $this->db->update("users",$arr); } //select data public function select_users($id){ $this->db->where("id",$id); $this->db->select("*"); return $this->db->get("users"); //注意如果你返回的是以下内容的话，他就是一个对象的结果集，这样当你返回controller中时，你就得转换；// return $query->result(); } }?>Controller
home.php
<?php/** * xxx.php * ============================================== * Copy right 2012-2015 * ---------------------------------------------- * This is not a free software, without any authorization is not allowed to use and spread. * ============================================== * @Author:YeXianMing * @Email:LangWaiShiGe@hotmail.com * @Version:zend studio10.6.2 php5.4.38 apache2.2 */ if(!defined("BASEPATH"))exit("No direct script access allowed"); class Home extends CI_Controller{ public function __construct(){ parent::__construct(); } //insert data public function insert(){ $this->load->model("MTest","",TRUE); $arr=array("username"=>"yexianming1","password"=>"admin","email"=>"11504160314qq.com","fullname"=>"luotianyexianming"); if(!($this->MTest->insert_users($arr))){ echo "插入数据成功"; }else{ echo "插入数据失败"; } } //update data public function update(){ $this->load->model("MTest","",TRUE); $arr=array("username"=>"Helloworld22","password"=>"root","email"=>"895787704@qq.com","fullname"=>"luotianyecong"); if(!($this->MTest->update_users("Helloworld",$arr))){ echo "修改成功"; }else{ echo "修改失败"; } } //delete data public function delete(){ $this->load->model("MTest","",TRUE); $query=$this->MTest->delete_users(12); if(!$query){ echo "删除成功"; }else{ echo "删除失败"; } } //select data public function select(){ $this->load->library("table"); $this->load->model("MTest","",TRUE); $arr=$this->MTest->select_users(3); $userinformation=$this->table->generate($arr); $data["userinfor"]=$userinformation; $this->load->view("template",$data); } }?>view
temlate.php
<?php echo $userinfor;?>
output:
id username password email fullname3 Helloworld22 root 1111111@qq.com luotianyecong
更多关于CodeIgniter相关内容感兴趣的读者可查看本站专题：《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《php优秀开发框架总结》、《ThinkPHP入门教程》、《ThinkPHP常用方法总结》、《Zend FrameWork框架入门教程》、《php面向对象程序设计入门教程》、《php+mysql数据库操作入门教程》及《php常见数据库操作技巧汇总》
希望本文所述对大家基于CodeIgniter框架的PHP程序设计有所帮助。
