The examples in this article describe the basic operations of the CodeIgniter framework database. Share it with everyone for your reference, the details are as follows:
Start now, first move the CI framework to your own server directory and configure config/config.php
$config['base_url'] = 'http://localhost:90/CI/';
Then configure the database in config/ I configured databases.php for practice as follows
$db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'root'; $db['default']['password'] = 'root'; $db['default']['database'] = 'demo'; $db['default']['dbdriver'] = 'mysql';
Otherwise, novices now have no need to create a database and a user table. This is in my source code package and you can import it directly, but the prerequisite You want to create a demo database
The reg class code is as follows
<?php
/***************************************
* 用户注册模块和数据库的基本操作实践
* 17:44 2013.2.18
* @Author sdeep wang
***************************************/
class Reg extends CI_Controller{
function __construct(){//此函数每次必须写是继承父类的方法
parent::__construct();
$this->load->database();//这个是连接数据库的方法，放到这里的好处只要调用该方法就会连接数据库
}
function index(){
$this->load->view('reg_view');//这个是使用哪个视图来显示相当于Smarty中的display
}
function reg_insert(){
$data['name'] = $this->input->post('name');//这个是指取得POST数组的值然后赋值一个心的数组
$data['sex'] = $this->input->post('sex');
$data['age'] = $this->input->post('age');
$data['pwd'] = md5($this->input->post('pwd'));//这里用了一个md5加密只是为了演示
$data['email'] = $this->input->post('email');
$this->db->insert('user',$data);//这个是数据库操作插入操作
redirect('/reg/reg_select/', 'refresh');//这个是跳转函数是url辅助函数里面的一个方法
}
function reg_select(){//这个查询数据库的方法
$this->db->select('id,name,sex,age,email');//这里是查询要显示的字段，可不能像我第一次这样写啊$this->db->select('id','name','sex','age','email');
$data['query'] = $this->db->get('user');//这个是取得数据（如果你上面写的和我第一次一样的话只能取的一个字段）
$this->load->view('select_view',$data);//这里是调用哪个视图并分配数据给指定视图显示
}
function reg_delete(){//删除数据的操作
$id = $this->input->get('id');//这里是取得get传过来的值
$this->db->where('id',$id);//这里是做where条件这个相当重要，如果没有这个你有可能把这个表数据都清空了
$this->db->delete('user');//删除指定id数据
redirect('/reg/reg_select/', 'refresh');//同上跳转
}
function reg_update(){//跟新数据的操作
$data['id'] = $this->input->get('id');//同上取的get传值过来的ID
$this->load->view('update_view',$data);//同上调用视图分配数据
}
function reg_com_update(){//这个是真正的跟新数据操作方法
$id = $this->input->post('id');//同上取得post中的id值
$data = array(//把post数组的值封装到新的数组中为了下面跟新操作用
'name'=>$this->input->post('name'),
'pwd'=>md5($this->input->post('pwd')),
'email'=>$this->input->post('email' )
);
if(!empty($id) && (count($data) > 1)){//判断id值是否传过来并且判断封装的数组是否有元素存在
$this->db->where('id',$id);//同上准备where条件
$this->db->update('user',$data);//跟新操作
}
redirect('/reg/reg_select/', 'refresh');//同上跳转
}
}
?>The view code is as follows
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>用户注册</title>
</head>
<body>
<form action="<?php echo site_url('reg/reg_insert/'); ?>" method="post">
<table>
<tr>
<td>
姓名:<input type="text" name="name" />
</td>
</tr>
<tr>
<td>
姓别:<input type="radio" name="sex" value="1" />男
<input type="radio" name="sex" />女
</td>
</tr>
<tr>
<td>
年龄:<input type="text" name="age" />
</td>
</tr>
<tr>
<td>
密码:<input type="password" name="pwd" />
</td>
</tr>
<tr>
<td>
邮件:<input type="text" name="email" />
</td>
</tr>
<tr>
<td>
<input type="submit" value="注册" />
<input type="reset" value="重置" />
</td>
</tr>
</table>
</form>
</body>
</html>The second view code is as follows
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>显示数据库中的所有注册用户</title>
<style>
*{
margin:0 auto;
}
table {
border:1px solid gray;
border-collapse: collapse;
width:500px;
text-align:center;
}
th,td {
border:1px solid gray;
}
</style>
</head>
<body>
<table>
<caption><h3 id="注册用户的显示">注册用户的显示</h3></caption>
<tr>
<th>ID</th>
<th>Name</th>
<th>Sex</th>
<th>Age</th>
<th>Email</th>
<th>Operate</th>
</tr>
<?php foreach($query->result() as $item):?>
<tr>
<td><?php echo $item->id; ?></td>
<td><?php echo $item->name; ?></td>
<td><?php echo $item->sex; ?></td>
<td><?php echo $item->age; ?></td>
<td><?php echo $item->email; ?></td>
<td>
<a href="<?php echo site_url('reg/reg_delete');?>?id=<?php echo $item->id;?>" rel="external nofollow" >删除</a> |
<a href="<?php echo site_url('reg/reg_update');?>?id=<?php echo $item->id;?>" rel="external nofollow" >修改</a>
</td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>
第三个视图如下
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>修改用户注册信息</title>
</head>
<body>
<form action="<?php echo site_url('reg/reg_com_update');?>" method="post">
<table>
<tr>
<td>姓名:<input type="text" name="name" /></td>
</tr>
<tr>
<td>密码:<input type="password" name="pwd" /></td>
</tr>
<tr>
<td>邮件:<input type="text" name="email" /></td>
</tr>
<tr>
<td>
<input type="submit" value="修改" />
<input type="hidden" name="id" value="<?php echo $id; ?>" />
</td>
</tr>
</table>
</form>
</body>
</html>The rendering is as follows
The above is the detailed content of CodeIgniter framework database basic operations. For more information, please follow other related articles on the PHP Chinese website!
How to make PHP applications fasterMay 12, 2025 am 12:12 AMTomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc
PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AMToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin
PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AMDependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.
PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AMDatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi
Simple Guide: Sending Email with PHP ScriptMay 12, 2025 am 12:02 AMPHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability
PHP Performance: Identifying and Fixing BottlenecksMay 11, 2025 am 12:13 AMPHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.
Dependency Injection for PHP: a quick summaryMay 11, 2025 am 12:09 AMDependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.
Increase PHP Performance: Caching Strategies & TechniquesMay 11, 2025 am 12:08 AMCachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Zend Studio 13.0.1
Powerful PHP integrated development environment
WebStorm Mac version
Useful JavaScript development tools
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
SublimeText3 Mac version
God-level code editing software (SublimeText3)
