Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Add, delete, modify and check operations in CI (CodeIgniter) framework_PHP tutorial

Add, delete, modify and check operations in CI (CodeIgniter) framework_PHP tutorial

WBOY
Release： 2016-07-13 10:28:40
Original
962 people have browsed it

CodeIgniter’s data function class is in systemdatabaseDB_active_rec.php

Copy code The code is as follows:

class ModelName extends CI_Model
{
function __construct()
{
parent::__construct();
}
}

Connect to the database: $this->load->database();

Copy code The code is as follows:

classModel_name extends CI_Model
{
function __construct()
{
parent::__construct();
$this->load->database();
}
}< ;/span>

Write it in the constructor of the model, so that the database is connected while loading the model, which is very convenient.


Insert data

Copy code The code is as follows:

$this- >db->insert($tableName,$data);
$tableName = is the name of the table you want to operate.
$data=The data you want to insert, insert it in the form of an array (key name=field name, key value=field value, no need to write auto-incrementing primary key).

Update data

Copy code The code is as follows:

$this- >db->where('field name', 'field value');
$this->db->update('table name', array of modified values);

Query data

Copy code The code is as follows:

$this- >db->where('field name','field value');
$this->db->select('field');
$query= $this->db ->get('table name');
return$query->result();

Delete data

Copy code The code is as follows:

$this- >db->where('field name','field value');
$this->db->delete('table name');

The next step is to call our model in the controller

Copy code The code is as follows:

$this- >load->model('model name')//The model name refers to the file you created in project directory/models/$this->Model name->Method name

In order not to call it once in each controller method. This is what I did

Copy code The code is as follows:


class ControllerName extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->model('model name');
}
}

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/781407.htmlTechArticleCodeIgniter’s data function class is in systemdatabaseDB_active_rec.php. Copy the code as follows: span style="font-size:16px; "class ModelName extends CI_Model { function __construct()...
Related labels：
ci framework
source：php.cn
Previous article：Detailed explanation of 2 sets of PHP APC configuration files and parameters_PHP tutorial Next article：PHP image proportional scaling to generate thumbnail function sharing_PHP tutorial
Statement of this Website
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
Latest Articles by Author
Latest Issues
Launch a transparent browser to improve the experience of web applications and PWA [support static HTML, CSS and JavaScript] [allow users to view desktop wallpapers in our web applications/PWA] I'm a junior front-end developer and designer currently developing a web application (chat...
From 2024-04-05 13:50:12
0
1
1367
Content overflow in window prevents scrolling and hides new content I'm currently building a roulette system program (this is more to stop me from placing bet...
From 2024-04-03 21:24:55
0
1
285
CSS row class makes some elements go out of frame, while they should be static and fixed to the bottom of the display My page currently looks like this. After adding the row class so that the two elements are...
From 2024-04-03 18:48:12
0
1
281
My WPF application won't start on another PC, but the application without MySql does, what could be the problem? This is my first time using a database. I've created an application using XAMPP via mySqll...
From 2024-04-03 11:16:00
0
1
396
How to make an image appear in the center of the header? First of all, my code is based on 3 files, an HTML, a CSS and a JS. It should be noted tha...
From 2024-04-01 23:49:58
0
1
372
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template