Update query in codeigniter Example

1. Update Query In Codeigniter
2. Select Query In Codeigniter
3. Insert Query In Codeigniter
4. Delete Query In Codeigniter

Update using $this->db->update()

This is how you can update an existing rows into ’member_master’ table using $this->db->update().by using $this->db->update() method we can use UPDATE for single record and extecut CodeIgniter UPDATE Query.

$data = array(
	'member_code' => 'MEM10',
	'member_dept' => 'Devloping'
	);

$this->db->update('member_master',$data,'member_ID=1');

Or as an array:

$this->db->update('member_master',$data,array('member_ID' => 1));

CodeIgniter UPDATE Query with $this->db->update_string()

by using $this->db->update_string() method we can use UPDATE for string type recoder/data and extecut UPDATE Query.

Note: Values are automatically escaped, producing safer queries.

$get_teamname = $_POST['teamname'];

$member_data = array(
    'teamname' => $get_teamname
);
$member_where = "status = 'member'";

//update member data 
$string = $this->db->update_string('tbl_all_member', $member_data, $member_where);

// sql UPDATE query like 
// UPDATE tbl_all_member SET teamname = '$get_teamname' WHERE id = $member_id 

CodeIgniter UPDATE Query with $this->db->update()

by using $this->db->update() method we can use UPDATE for single record and extecut CodeIgniter UPDATE Query.

//get member id
$member_id = $_POST['id'];
//get member name
$get_name = $_POST['name'];
//get member teamname
$get_teamname = $_POST['teamname'];
//get member age
$get_age = $_POST['age'];

$member_data = array(
    'name'      =>  $get_name ,
    'teamname' =>  $get_teamname,
    'age'       =>  $get_age 
);

$this->db->where('id', $member_id);
//update member data 
$this->db->update('tbl_all_member', $member_data);
// sql UPDATE query like 
// UPDATE tbl_all_member SET name = '$get_name', teamname = '$get_teamname', age = '$get_age' WHERE id = $member_id 

Update with $this->db->where()

This is how you can update an existing rows into ’member_master’ table using $this->db->update() along with $this->db->where().

$data = array(
	'member_code' => 'MEM10',
	'member_dept' => 'Devloping'
	);
$this->db->where('member_ID', $id);
$this->db->update('member_master',$data);

Update with $this->db->set()

This is how you can update an existing rows into ’member_master’ table using $this->db->update() along with $this->db->set().

$data = array(
	'member_code' => 'MEM10',
	'member_dept' => 'Devloping'
	);
$this->db->set($data)
$this->db->where('member_ID', $id);
$this->db->update('member_master');

Update using $this->db->update_batch()

This is how you can update an existing rows into ’member_master’ table using $this->db->update_batch().

$data = array(
   array(
      'member_ID' => 1 ,
      'member_code' => 'MEM10' ,
      'member_dept' => 'Devloping'
   ),
   array(
      'member_ID' => 2 ,
      'member_code' => 'MEM20' ,
      'member_dept' => 'Devloping'
   )
);

$this->db->update_batch('member_master', $data, 'member_ID');

// Produces:
// UPDATE `member_master` SET `member_code` = CASE
// WHEN `member_ID` = 1 THEN 'MEM10'
// WHEN `member_ID` = 2 THEN 'MEM20'
// ELSE `member_code` END,
// `member_dept` = CASE
// WHEN `member_ID` = 1 THEN 'Devloping'
// WHEN `member_ID` = 2 THEN 'Devloping'
// ELSE `member_dept` END
// WHERE `member_ID` IN (1,2)

by using $this->db->update_batch() method we can use UPDATE for mualtiple data and same time, with one execution and execute UPDATE Query. by using this method we can execute number of records with single execute query.

// pass member data in array 
$member_data = array(
   array(
    'name'  = >  'add_anme_1' ,
    'teamname'= >  'add_your_team_name1',
    'age'   = >  '24'
   ),
   array(
    'name'  = >  'add_anme_2' ,
    'teamname'= >  'add_your_team_name2',
    'age'   = >  '25'
   )
);
//update member data 
$this->db->update_batch('tbl_all_member', $member_data);

// sql UPDATE mulatiple data in query like  
// UPDATE tbl_all_member SET name = '$get_name', teamname = '$get_teamname', age = '$get_age' WHERE id = $member_id

Web Programming Tutorials Example with Demo

Read :

• Jobs
• Make Money
• Programming

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about select query in codeigniter with example.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.