Advertisement
mstranieri

foreach problem

Oct 30th, 2015
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.52 KB | None | 0 0
  1. $data['lavorazioni'] = get_works(array('READY', 'IN PROGRESS'));
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11. /**************** HELPER ******************/
  12.  
  13. function get_works($status = array('READY')) {
  14.     $CI = &get_instance();
  15.     $query = "SELECT * FROM manager_works WHERE";
  16.    
  17.     $i = 0;
  18.     foreach ($status as $s) {
  19.         if($i > 0) {
  20.             $query .= " OR ";
  21.         }
  22.        
  23.         $query .= "state = '" . $s . "'";          
  24.         $i++;
  25.     }
  26.    
  27.     $query = $CI->db->query($query);
  28.    
  29.     if ($query->num_rows() == 1) {
  30.         return count($query->row());
  31.     } else {
  32.         return null;
  33.     }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement