ADD VALUE TO CURRENT COLUMN VALUE IN CODEIGNITOR

There is many times you want to add the values to the current value of column of database table. That is you want to add certain values to the current value of database. Most of the time, we first fetch the current value and then and the value to the fetch value and finally update the database table

Here is the tutorial about how to add certain value to column of the database table directly. In CodeIgnitor we can directly add value to the database column value.
ADD VALUE TO CURRENT COLUMN VALUE IN CODEIGNITOR

1. First create a database

We can create a new database using CREATE DATABASE statement.

CREATE DATABASE company;

2. create a database table 

We can create a new database table using CREATE TABLE statement.

CREATE TABLE IF NOT EXISTS `sales` (
  `sid` int(4) NOT NULL,
  `points` int(4) NOT NULL,
  `section` varchar(200) NOT NULL,
  `address` archar(50) NOT NULL
);

3. Insert data into table

Now insert some data using INSERT INTO operation of MYSQL as follows;

INSERT INTO sales
VALUES (1,30,'sales','lalitpur');

Now we can  add 20 to the current value of points of sales table.

4. Add points to current database value

In CodeIgnitor, this can be done as:

$points=20;
$this->db->set('points', "points+$points",FALSE);
$res=$this->db->update('sales');

The third parameter 'FALSE' is important in above SQL SET statement.It helps to directly extract and change the database value.This SQL statement add 20 to the current value of points of sales table.

similarly, we can subtract, divide and multiply the value with current value of database.

We keep on updating such tutorials. 

For more such tutorials like our Facebook page. 


Comments

Post a Comment

Popular posts from this blog

INTEGRATE BOOTSTRAP WITH PHP CODEIGNITER FRAMEWORK

Image
This tutorial is about the technique of combining the power of two robust frameworks, PHP CodeIgniter MVC framework and Twitter Bootstrap. You need to properly integrate twitter bootstrap  with CodeIgniter framework for it to work properly.  So this tutorial will show you how to integrate Bootstrap with CodeIgniter to enhance the appearance of your CodeIgniter application. Download the latest versions of the frameworks from the links given below. Download CodeIgniter Framework   Download Twitter Bootstrap  Download jQuery Steps for integration of CodeIgniter framework with bootstrap STEP-1: Download and extract the PHP CodeIgniter Framework  zip file from the above link to your Local Server. Rename it with your application name.  Inside create a folder named "assets" to keep all your bootstrap files.  CodeIgnitor folder structure must be  similar to the below image.  STEP-2:  Extract all the files of boots...
Read more

CodeIgnitor installing guide

Image
Step 1: Downloading CodeIgnitor MVC Framework To install CodeIgnitor MVC Framework, first download the CodeIgnitor zip file of  from  http://www.codeigniter.com/  . Step 2: Installing CodeIgnitor Unzip the CodeIgnitor  zip compressed file  downloaded from http://www.codeigniter.com/ and rename the name of this folder to the application name of your project. Now move the folder inside your local server.  Incase of WAMPP, move this folder inside the www folder of your localhost. Incase of XAMP, move this folder inside the htdocs folder of your localhost. The basic file structure of CodeIgnitor application is as follows. Step 3:Configuring CodeIgnitor Before starting the CodeIgnitor application, you need to configure certain configuration. You need to step up right base url of the application. To setup base_url of the application, open  system/application/config/ c...
Read more

Selecting data from database in CodeIgnitor

Image
PHP and CodeIgnitor SQL queries allow us to  retrieve, insert and update data and information in your database. CodeIgnitor uses Active record database pattern. The values are escaped automatically by the system so it helps to produce the   safer queries . SQL queries in CodeIgnitor helps in retrieval of  data from database. The following SQL query functions allow you to build SQL  SELECT  statements. 1.1 $this->db->get(); This SQL Query is used to retrieve all the records from database. $query = $this->db->get('tableName'); // It produces SELECT * FROM table_name statement The second and third parameters in SQL query enable you to set a limit and offset clause: $query = $this->db->get('tableName', 20, 30); // Produces: SELECT * FROM tableName LIMIT 30, 20 (in MySQL.  Above SQL Query is assigned to a variable named $query, which can be used to show the results: $query = $this->db-...
Read more