Codeigniter 4 Update Query Code Example

Example 1: update in codeigniter query

$data = array(         'title' => $title,         'name' => $name,         'date' => $date );  $this->db->where('id', $id); $this->db->update('mytable', $data); // Produces: // //      UPDATE mytable //      SET title = '{$title}', name = '{$name}', date = '{$date}' //      WHERE id = $id

Example 2: codeigniter update query return value

public function update_row(){ 		 		$update_rows = array( 			'name' => 'rincky', 			'address' => 'India', 			'contact' => '98545785', 			'department' => 'IT',  		); 		$this->db->where('id', 1 ); 		$result = $this->db->update('user', $update_rows);	 		return $result; 	}

Example 3: codeigniter 3 update

$data = array(         'title' => $title,         'name' => $name,         'date' => $date );  $this->db->where('id', $id); $this->db->update('mytable', $data);