PHP foreach to make query

Question

I have an array like this

Array ( [12313] => 1 [12312] => 1 ) 1

The array keys are the items that exist in the warehouse and values are the number of items.

I would like to check if the items and amounts actually exist in the warehouse database using php. I thought maybe I could use a foreach for each item check but I don't know how to use foreach. I would like to make a query like:

$query=$this->db->query("SELECT COUNT(*) as amount FROM warehouse where item=12313");
$check=$query->row_array();
$amt=$check['amount'];
if($amt>0){
   return true;
}
else{
   return false;
}

are those solution really works for you? make value of 12312=>0 and check what happens — Shaiful Islam
– Shaiful Islam, Commented Jan 12, 2015 at 19:04
all the solution checks only the first item has minimum one data — Shaiful Islam
– Shaiful Islam, Commented Jan 12, 2015 at 19:28
I will replace inner codes with working code. The code in the question is just a description. The main solution i would like to get is how to use key and value of array in foreachloop.:) — user3789191
– user3789191, Commented Jan 14, 2015 at 6:35

user3789191 · Accepted Answer · 2015-01-12 10:25:14Z

3

$array=array ( '12313' => 1,'12312' => 1 );
foreach($array as $k=>$val)
{
  $query=$this->db->query("SELECT COUNT(*) as amount FROM warehouse where item='".$k."'");
  $check=$query->row_array();
  $amt=$check['amount'];
  if($amt>0){
    return true;
  }
  else{
   return false;
  }
}

edited Jan 12, 2015 at 10:25

user3789191

9710 bronze badges

answered Jan 12, 2015 at 10:11

Ankur Bhadania

4,1681 gold badge25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Indra Kumar S Over a year ago

Your query should be encapsulated with Double quotes....And wrap $k with single quote bcz if it will work for both string as well as int.... and while selecting metion amount not all *

Shaiful Islam Over a year ago

why the foreach loop?it will query only for 12312 and return true or false.will not do anything for 12312

pbaldauf · Accepted Answer · 2015-01-12 10:14:21Z

1

Are you looking for something like:

$items = array(
        12313 => 1,
        12312 => 1,
    );

foreach ( $items as $key => $value ) : //iterate over array
    $query = "SELECT COUNT(*) as amount FROM warehouse where item = $key";
    $check = $query->row_array();
    $amt = $check['amount'];
    if( $amt>0 ) {
        return true;
    }
    else {
        return false;
    }

endforeach;

answered Jan 12, 2015 at 10:14

pbaldauf

1,6812 gold badges26 silver badges35 bronze badges

Comments

Priyank · Accepted Answer · 2015-01-12 10:24:31Z

0

try this

$arr = array("[12313]" => "1" ,"[12312]" => "2");
foreach ($arr as  $key=>$value) {
$query="SELECT COUNT(*) as amount FROM warehouse where item='".$key."'";
$check=$query->row_array();
$amt=$check['amount'];
if($amt>0){
return true;
}
else{
return false;
}
}

edited Jan 12, 2015 at 10:24

answered Jan 12, 2015 at 10:15

Priyank

3,8884 gold badges33 silver badges50 bronze badges

1 Comment

Priyank Over a year ago

@user3789191 let me know if it is working for you :)

Rahul Chipad · Accepted Answer · 2015-01-12 10:53:38Z

0

  $array = array('12313' => 1, '12312' => 1);
            foreach ($array as $key => $value) {

                $this->db->select('COUNT(*) as amount');
                $this->db->from('warehouse');
                $this->db->where('item', $key);
                $result = $this->db->get()->row_array();

                return ($result['amount'] >= $value) ? TRUE : FALSE; //match no of items
             // return ($result['amount'] > 0) ? TRUE : FALSE; //OR if just check the count
            }

answered Jan 12, 2015 at 10:53

Rahul Chipad

2,41118 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP foreach to make query

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related