search
HomeBackend DevelopmentPHP TutorialDatabase addition, deletion, modification and query operations implemented by CI framework (CodeIgniter)
Database addition, deletion, modification and query operations implemented by CI framework (CodeIgniter)
jacklove
jacklove
Jun 22, 2018 pm 04:14 PM
ci frameworkcodeigniterAdd, delete, modify and checkdatabase

This article mainly introduces the database addition, deletion, modification and query operations implemented by the CI framework (CodeIgniter). It summarizes and analyzes the CI framework's model, controller and view related definitions and usage skills for the mysql database addition, deletion, modification and query operations in the form of examples. Friends in need can refer to the following

The example in this article describes the database addition, deletion, modification and query operations implemented by the CI framework (CodeIgniter). Share it with everyone for your reference, the details are as follows:

cquery.php file under controllers

<?php
class CQuery extends Controller {
  //构造函数
  function CQuery() {
    parent::Controller();
//   $this->load->database();
  }
  function index() {
    //调用model 其中train为外层文件夹  MQuery为model名称 queryList为重命名
    $this->load->model(&#39;train/MQuery&#39;,&#39;queryList&#39;);
    //获得返回的结果集  这里确定调用model中的哪个方法
    $result = $this->queryList->queryList();
    //将结果集赋给res
    $this->smarty->assign(&#39;res&#39;,$result);
    //跳转到显示页面
    $this->smarty->view(&#39;train/vquery.tpl&#39;);
  }
  //进入新增页面
  function addPage() {
    $this->smarty->view(&#39;train/addPage.tpl&#39;);
  }
  //新增
  function add() {
    //获得前台数据
    //用户名
    $memberName = $this->input->post(&#39;memberName&#39;);
    //密码
    $password = $this->input->post(&#39;password&#39;);
    //真实姓名
    $userRealName = $this->input->post(&#39;userRealName&#39;);
    //性别
    $sex = $this->input->post(&#39;sex&#39;);
    //出生日期
    $bornDay = $this->input->post(&#39;bornDay&#39;);
    //e_mail
    $eMail = $this->input->post(&#39;eMail&#39;);
    //密码问题
    $question = $this->input->post(&#39;question&#39;);
    //密码答案
    $answer = $this->input->post(&#39;answer&#39;);
    //调用model
    $this->load->model(&#39;train/MQuery&#39;,&#39;addRecord&#39;);
    //向model中的addRecord传值
    $result = $this->addRecord->addRecord($memberName,$password,$userRealName,$sex,$bornDay,$eMail,$question,$answer);
    //判断返回的结果,如果返回true,则调用本页的index方法,不要写 $result == false 因为返回的值未必是false 也有可能是""
    if ($result) {
      $this->index();
    } else {
      echo "add failed.";
    }
  }
  //删除
  function deletePage() {
    //获得ID
    $deleteID = $this->uri->segment(4);
    //调用model
    $this->load->model(&#39;train/MQuery&#39;,&#39;delRecord&#39;);
    //将值传入到model的delRecord方法中
    $result = $this->delRecord->delRecord($deleteID);
    //判断返回值
    if ($result) {
      $this->index();
    } else {
      echo "delect failed.";
    }
  }
  //修改先查询
  function changePage() {
    $changeID = $this->uri->segment(4);
    $this->load->model(&#39;train/MQuery&#39;,&#39;changeRecord&#39;);
    $result = $this->changeRecord->changeRecord($changeID);
    //将结果集赋给res
    $this->smarty->assign(&#39;res&#39;,$result);
    //跳转到显示页面
    $this->smarty->view(&#39;train/changePage.tpl&#39;);
  }
  //修改
  function change() {
    //获得前台数据
    //ID
    $ID = $this->input->post(&#39;id&#39;);
    //用户名
    $memberName = $this->input->post(&#39;memberName&#39;);
    //密码
    $password = $this->input->post(&#39;password&#39;);
    //真实姓名
    $userRealName = $this->input->post(&#39;userRealName&#39;);
    //性别
    $sex = $this->input->post(&#39;sex&#39;);
    //出生日期
    $bornDay = $this->input->post(&#39;bornDay&#39;);
    //e_mail
    $eMail = $this->input->post(&#39;eMail&#39;);
    //密码问题
    $question = $this->input->post(&#39;question&#39;);
    //密码答案
    $answer = $this->input->post(&#39;answer&#39;);
    //调用model
    $this->load->model(&#39;train/MQuery&#39;,&#39;change&#39;);
    //向model中的change传值
    $result = $this->change->change($ID,$memberName,$password,$userRealName,$sex,$bornDay,$eMail,$question,$answer);
    //判断返回的结果,如果返回true,则调用本页的index方法,不要写 $result == false 因为返回的值未必是false 也有可能是""
    if ($result) {
      $this->index();
    } else {
      echo "change failed.";
    }
  }
}

mquery.php file in models

<?php
class MQuery extends Model {
  //构造函数
  function MQuery() {
    parent::Model();
    //连接数据库
    $this->load->database();
  }
  //查询列表
  function queryList() {
    //防止select出的数据存在乱码问题
    //mysql_query("SET NAMES GBK");
    //SQL语句
    $sql = "SELECT ID,member_name,sex,e_mail FROM user_info_t";
    //执行SQL
    $rs = $this->db->query($sql);
    //将查询结果放入到结果集中
    $result = $rs->result();
    //关闭数据库
    $this->db->close();
    //将结果集返回
    return $result;
  }
  //新增
  function addRecord($memberName,$password,$userRealName,$sex,$bornDay,$eMail,$question,$answer) {
    //防止select出的数据存在乱码问题
    //mysql_query("SET NAMES GBK");
    //SQL语句
    $sql = "INSERT INTO user_info_t (member_name,password,user_real_name,sex,born_day,e_mail,question,answer) " .
        "VALUES (&#39;$memberName&#39;,&#39;$password&#39;,&#39;$userRealName&#39;,&#39;$sex&#39;,&#39;$bornDay&#39;,&#39;$eMail&#39;,&#39;$question&#39;,&#39;$answer&#39;)";
    //执行SQL
    $result = $this->db->query($sql);
    //关闭数据库
    $this->db->close();
    //返回值
    return $result;
  }
  //删除
  function delRecord($deleteID) {
    //防止select出的数据存在乱码问题
    //mysql_query("SET NAMES GBK");
    $sql = "DELETE FROM user_info_t WHERE ID = $deleteID";
    $result = $this->db->query($sql);
    $this->db->close();
    return $result;
  }
  //修改前查询
  function changeRecord($changeID) {
    //防止select出的数据存在乱码问题
    //mysql_query("SET NAMES GBK");
    $sql = "SELECT ID,member_name,password,user_real_name,sex,born_day,e_mail,question,answer FROM user_info_t WHERE ID = $changeID";
    //执行SQL
    $rs = $this->db->query($sql);
    $result = $rs->row();//$result = $rs[0]
    //关闭数据库
    $this->db->close();
    //将结果集返回
    return $result;
  }
  //修改
  function change($ID,$memberName,$password,$userRealName,$sex,$bornDay,$eMail,$question,$answer) {
    //防止select出的数据存在乱码问题
    //mysql_query("SET NAMES GBK");
    //SQL语句
    $sql = "update user_info_t set member_name = &#39;$memberName&#39;,password = &#39;$password&#39;, user_real_name = &#39;$userRealName&#39;," .
        "sex = &#39;$sex&#39;,born_day = &#39;$bornDay&#39;,e_mail = &#39;$eMail&#39;,question = &#39;$question&#39;,answer = &#39;$answer&#39;" .
        "where ID = $ID";
    //执行SQL
    $result = $this->db->query($sql);
    //关闭数据库
    $this->db->close();
    //返回值
    return $result;
  }
}

addPage.tpl file under views

<html>
  <head>
  </head>
  <body><form action="{{site_url url=&#39;train/cquery/add&#39;}}" method="post">
    <table border=&#39;1&#39;>
      <tr>
        <td>用户名</td>
        <td><input type="text" class="text" name="memberName" id="memberName"/></td>
      </tr>
      <tr>
        <td>密码</td>
        <td><input type="text" class="text" name="password" id="password"/></td>
      </tr>
      <tr>
        <td>真实姓名</td>
        <td><input type="text" class="text" name="userRealName" id="userRealName"/></td>
      </tr>
      <tr>
        <td>性别</td>
        <td><input type="text" class="text" name="sex" id="sex"/></td>
      </tr>
      <tr>
        <td>出生日期</td>
        <td><input type="text" class="text" name="bornDay" id="bornDay"/></td>
      </tr>
      <tr>
        <td>e_mail</td>
        <td><input type="text" class="text" name="eMail" id="eMail"/></td>
      </tr>
      <tr>
        <td>密码问题</td>
        <td><input type="text" class="text" name="question" id="question"/></td>
      </tr>
      <tr>
        <td>密码答案</td>
        <td><input type="text" class="text" name="answer" id="answer"/></td>
      </tr>
    </table>
    <table>
      <tr>
        <td><input type="submit" class="button" name="OK" value="提交" />
        </td>
      </tr>
    </table></form>
  </body>
</html>

changePage.tpl file

<html>
  <head>
  </head>
  <body><form action="{{site_url url=&#39;train/cquery/change&#39;}}" method="post">
    <table border=&#39;1&#39;><input type="hidden" name="id" value="{{$res->ID}}" />
      <tr>
        <td>用户名</td>
        <td><input type="text" class="text" name="memberName" id="memberName" value="{{$res->member_name}}" /></td>
      </tr>
      <tr>
        <td>密码</td>
        <td><input type="text" class="text" name="password" id="password" value="{{$res->password}}" /></td>
      </tr>
      <tr>
        <td>真实姓名</td>
        <td><input type="text" class="text" name="userRealName" id="userRealName" value="{{$res->user_real_name}}"/></td>
      </tr>
      <tr>
        <td>性别</td>
        <td><input type="text" class="text" name="sex" id="sex" value="{{$res->sex}}"/></td>
      </tr>
      <tr>
        <td>出生日期</td>
        <td><input type="text" class="text" name="bornDay" id="bornDay" value="{{$res->born_day}}"/></td>
      </tr>
      <tr>
        <td>e_mail</td>
        <td><input type="text" class="text" name="eMail" id="eMail" value="{{$res->e_mail}}"/></td>
      </tr>
      <tr>
        <td>密码问题</td>
        <td><input type="text" class="text" name="question" id="question" value="{{$res->question}}"/></td>
      </tr>
      <tr>
        <td>密码答案</td>
        <td><input type="text" class="text" name="answer" id="answer" value="{{$res->answer}}"/></td>
      </tr>
    </table>
    <table>
      <tr>
        <td><input type="submit" class="button" name="OK" value="提交" />
        </td>
      </tr>
    </table></form>
  </body>
</html>

vquery.tpl file

<html>
  <head>
    <title></title>
  </head>
  <body>
    <table border=&#39;1&#39;>
      <tr>
        <td>用户名</td>
        <td>性别</td>
        <td>e_mail</td>
        <td>操作</td>
      </tr>
      {{foreach from=$res item=row}}
      <tr>
        <input type="hidden" value={{$row->ID}}>
        <td>{{$row->member_name}}</td>
        <td>{{$row->sex}}</td>
        <td>{{$row->e_mail}}</td>
        <td><a href="{{site_url url=&#39;train/cquery/deletePage&#39;}}/{{$row->ID}}" rel="external nofollow" >删除</a><a href="{{site_url url=&#39;train/cquery/changePage&#39;}}/{{$row->ID}}" rel="external nofollow" >修改</a></td>
      </tr>
      {{/foreach}}
    </table>
    <a href="{{site_url url=&#39;train/cquery/addPage&#39;}}" rel="external nofollow" rel="external nofollow" mce_href="{{site_url url=&#39;train/cquery/addPage&#39;}}" rel="external nofollow" rel="external nofollow" >add</a>
  </body>
</html>

You may be interested Article:

Example of PHP implementation of one-dimensional array and two-dimensional array deduplication function

Import and export implemented by CI framework (CodeIgniter) Data operation example

MySQL database backup function example implemented by ThinkPHP framework

The above is the detailed content of Database addition, deletion, modification and query operations implemented by CI framework (CodeIgniter). For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Related Article
php如何使用CI框架？php如何使用CI框架？Jun 01, 2023 am 08:48 AM

随着网络技术的发展，PHP已经成为了Web开发的重要工具之一。而其中一款流行的PHP框架——CodeIgniter（以下简称CI）也得到了越来越多的关注和使用。今天，我们就来看看如何使用CI框架。一、安装CI框架首先，我们需要下载CI框架并安装。在CI的官网（https://codeigniter.com/）上下载最新版本的CI框架压缩包。下载完成后，解压缩

CodeIgniter中间件：加速应用程序的响应速度和页面渲染CodeIgniter中间件：加速应用程序的响应速度和页面渲染Jul 28, 2023 pm 06:51 PM

CodeIgniter中间件：加速应用程序的响应速度和页面渲染概述：随着网络应用程序的复杂性和交互性不断增长，开发人员需要使用更加高效和可扩展的解决方案来提高应用程序的性能和响应速度。CodeIgniter（CI）是一种基于PHP的轻量级框架，提供了许多有用的功能，其中之一就是中间件。中间件是在请求到达控制器之前或之后执行的一系列任务。这篇文章将介绍如何使用

PHP开发：使用 CodeIgniter 实现 MVC 模式和 RESTful APIPHP开发：使用 CodeIgniter 实现 MVC 模式和 RESTful APIJun 16, 2023 am 08:09 AM

随着Web应用程序的不断发展，更加快速和高效地开发应用程序变得非常重要。并且，随着RESTfulAPI在Web应用程序中的广泛应用，对于开发人员来说，必须理解如何创建和实现RESTfulAPI。在本文中，我们将讨论如何使用CodeIgniter框架实现MVC模式和RESTfulAPI。MVC模式简介MVC(Model-Vie

PHP中如何使用CI框架PHP中如何使用CI框架Jun 27, 2023 pm 04:51 PM

PHP是一种流行的编程语言，广泛应用于Web开发。CI（CodeIgniter）框架是PHP中最受欢迎的框架之一，它提供了一整套现成的工具和函数库，以及一些流行的设计模式，让开发人员能够更加高效地开发Web应用程序。本文将介绍使用CI框架开发PHP应用程序的基本步骤和方法。了解CI框架的基本概念和结构在使用CI框架之前，我们需要先了解一些基本的概念和结构。下

php如何使用CodeIgniter5框架？php如何使用CodeIgniter5框架？Jun 01, 2023 am 11:21 AM

CodeIgniter是一个轻量级的PHP框架，采用MVC架构，支持快速开发和简化常见任务。CodeIgniter5是该框架的最新版本，提供了许多新的特性和改进。本文将介绍如何使用CodeIgniter5框架来构建一个简单的Web应用程序。步骤1：安装CodeIgniter5下载和安装CodeIgniter5非常简单，只需要遵循以下步骤：下载最新版本

如何使用PHP框架CodeIgniter快速搭建一个后台管理系统如何使用PHP框架CodeIgniter快速搭建一个后台管理系统Jun 27, 2023 am 09:46 AM

现今互联网时代，一款深受用户喜爱的网站必须具备简洁明了的前端界面和功能强大的后台管理系统，而PHP框架CodeIgniter则是一款能够让开发者快速搭建后台管理系统的优秀框架。CodeIgniter拥有轻量级、高效率、易扩展等特点，本文将针对初学者，详细说明如何通过该框架快速搭建一个后台管理系统。一、安装配置安装PHPCodeIgniter是一个基于PHP的

PHP实现框架：CodeIgniter入门教程PHP实现框架：CodeIgniter入门教程Jun 18, 2023 pm 10:43 PM

近年来，Web开发技术的进步和全球互联网应用的不断扩大，使得PHP技术应用面越来越广泛。作为一种快速开发的技术，其生态系统也在不断发展壮大。其中，CodeIgniter作为PHP开发领域中著名的框架之一，备受众多开发者的欢迎。本篇文章将介绍CodeIgniter框架的相关知识，以此为初学者提供一个入门的指引。一、什么是CodeIgniter框架？CodeIg

使用PHP框架CodeIgniter开发一个实时聊天应用，提供便捷的通讯服务使用PHP框架CodeIgniter开发一个实时聊天应用，提供便捷的通讯服务Jun 27, 2023 pm 02:49 PM

随着移动互联网的发展，即时通信变得越来越重要，越来越普及。对于很多企业而言，实时聊天更像是一种通信服务，提供便捷的沟通方式，可以快速有效地解决业务方面的问题。基于此，本文将介绍如何使用PHP框架CodeIgniter开发一个实时聊天应用。了解CodeIgniter框架CodeIgniter是一个轻量级的PHP框架，提供了一系列的简便的工具和库，帮助开发者快速

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Show More

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
3 weeks agoByDDD
R.E.P.O. Save File Location: Where Is It & How to Protect It?
3 weeks agoByDDD
Show More

Hot Tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Show More

Hot Topics

Where is the login entrance for gmail email?
7338
9
Java Tutorial
1627
14
CakePHP Tutorial
1352
46
Laravel Tutorial
1265
25
PHP Tutorial
1210
29
Show More