用CI框架向数据库中实现简单的增删改查

以下代码基于CodeIgniter_2.1.3版

用PHP向数据库中实现简单的增删改查（纯代码）请戳

http://www.cnblogs.com/corvoh/p/4641476.html

CodeIgniter_2.1.3与PHP5.6的兼容问题请戳

http://www.cnblogs.com/corvoh/p/4649357.html

增：

<span>//</span><span>insert<br /></span><span><span>//语法：$bool=$this->db->insert('表名'，关联数组);<br /></span></span><span>$data</span>=<span>array</span><span>(</span>    'username'=>'mary',    'password'=>'mary',<span>//建立一个用户名叫mary，密码为mary的数组，并传递给变量$data</span><span>);</span><span>$bool</span>=<span>$this</span>->db->insert('user',<span>$data</span><span>);<span>//将$data插入数据库的user表中</span></span><span>var_dump</span>(<span>$bool</span>);<span>//成功则返回TURE</span>

删：

<span>//</span><span>delete<br />//语法：<span>$bool=$this->db->delete('表名',WHERE条件);</span></span><span>$bool</span>=<span>$this</span>->db->delete('user',<span>array</span>('id'=>3<span>));<span>//删除数据库.user表里id=3的用户所有信息</span></span><span>var_dump</span>(<span>$bool</span>);<span>//成功则返回TURE</span>

改：

<span>//<span>update<span>$data=<span>array<span>(    'password'=>12345,<span>);<span>$bool=<span>$this->db->update('user',<span>$data,<span>array('id'=>3<span>));<span>//将数据库.user表里id=3的用户密码给为12345<br /></span><span>var_dump(<span>$bool);<span>//成功则返回TURE</span></span></span></span></span></span></span></span></span></span></span></span></span></span>

查：

<span>//<span>get<span>$res=<span>$list=<span>$this->db->ge<a>本2文来*源gao($daima.com搞@代@#码(网</a><strong>搞gaodaima代码</strong>t('user'<span>);<span>//<span>var_dump($list);<span>foreach(<span>$res->result() <span>as <span>$item<span>){<span>//利用foreach来列出所有用户名</span><span>echo <span>$item-><span>username;<span>echo '<br />'<span>;}</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>

以上就介绍了用CI框架向数据库中实现简单的增删改查，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。

喜欢 (0)赏

[搞代码]

分享 (0)