Codeigniter where_not_in

Where_in codeigniter

$this->db->select('ae_users.employee_id, ae_users.emp_name, ae_users.emp_name2, ae_users.emp_name3');
		$this->db->from('ae_users');                
		$this->db->where_in('ae_users.employee_id',$employee_ids);
     
		$query =$this->db->get();
             
		if ($query->num_rows()) {
			return $query->result_array();
		} else {
			return 0;
		}

Codeigniter where_not_in

$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
// Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')

Source: codeigniter.com

Cideigniter orLike()

$this->db->like('title', 'match'); $this->db->or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR  `body` LIKE '%match%' ESCAPE '!'

Source: codeigniter.com

Codeigniter select for update

$table = "my_table";
$id = 1;
$update = ["status"=>"working"];
//Edit just above /\ if you don't need extra "where" clause
$query = $this->db->select()
            ->from($table)
            ->where('id', $id)
            ->get_compiled_select();
$data = $this->db->query("$query FOR UPDATE")->row_array();
$this->db->where('id', $data['id'])->update($table,$update);

-2

Similar codes

0 vote180 views1 answer
Laravel collection except
PHP Laravel
0 vote215 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
0 vote164 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
32 votes164 views5 answers
Php array has key
PHP
16 votes174 views4 answers
Laravel auth helper function
PHP
6 votes147 views5 answers
Jetstream laravel
PHP
0 vote140 views2 answers
Laravel model column default value
PHP
0 vote157 views2 answers
Sortbydesc on a collection laravel
PHP Laravel
1 vote199 views1 answer
Laravel multiple orderby
PHP Laravel
1 vote166 views1 answer
Laravel routing controller get and post method
PHP Laravel