CodeIgniter Forums
how to use IS NULL? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: how to use IS NULL? (/thread-67783.html)



how to use IS NULL? - falcon812311 - 04-08-2017

Hi,

I have problem with my query, its not update my table

*I want select NULL col with limit then update the DB.

this is my code model:

PHP Code:
function SetUserTakenStock($data$id$totalTaken)
 
 {
 
   $this->db->trans_start();
 
   $this->db->select('*');
 
   $this->db->from('user_id');
 
   $this->db->where('status IS NULL');
 
   $this->db->set('status'$data);
 
   $this->db->where('user_id'$id);
 
   $this->db->limit($totalTaken);
 
   $this->db->update('gen_set');

 
   $this->db->trans_complete();
 
   if ($this->db->trans_status() === TRUE)
 
   {
 
     return true;
 
   }
 
   else
    
{
 
     return false;
 
   }
 
 



RE: how to use IS NULL? - janudewangga - 04-09-2017

(04-08-2017, 09:37 PM)falcon812311 Wrote: Hi,

I have problem with my query, its not update my table

*I want select NULL col with limit then update the DB.

this is my code model:

PHP Code:
function SetUserTakenStock($data$id$totalTaken)
 
 {
 
   $this->db->trans_start();
 
   $this->db->select('*');
 
   $this->db->from('user_id');
 
   $this->db->where('status IS NULL');
 
   $this->db->set('status'$data);
 
   $this->db->where('user_id'$id);
 
   $this->db->limit($totalTaken);
 
   $this->db->update('gen_set');

 
   $this->db->trans_complete();
 
   if ($this->db->trans_status() === TRUE)
 
   {
 
     return true;
 
   }
 
   else
    
{
 
     return false;
 
   }
 
 

I think that should be :
Code:
$this->db->where('status', null);



RE: how to use IS NULL? - dave friend - 04-09-2017

Not related to the answer but this code

PHP Code:
if ($this->db->trans_status() === TRUE)
 
   {
 
     return true;
 
   }
 
   else
    
{
 
     return false;
 
   

Can be expressed with a lot less typing Rolleyes

PHP Code:
return $this->db->trans_status();