Check if value in array and create php if statement

Question

I have been able to create the array after my query.

<?
    $results = array();
    while($row = mysql_fetch_assoc($result))
    {
       $results[] = $row;
    }
?>

I now have the following array from the query result:

array(2) {
  [0]=>
  array(1) {
    ["form_type"]=>
    string(6) "VF-302"
  }
  [1]=>
  array(1) {
    ["form_type"]=>
    string(6) "VF-301"
  }
}

If, for instance, the "VF-301" value exists the array, what would a php if statement be?

    <? //not working
    if(in_array("VF-300", $results)){ 
    echo "this value is in array";
    } else {
    echo "this value is not in array";
    }
    ?>

if you don't actully need the other rows, you should do this in the query. — user557846
– user557846, Commented Mar 24, 2015 at 21:47

J Hock · Accepted Answer · 2015-03-24 21:44:11Z

1

foreach($results as $result) {
    if(in_array("VF-300", $result)){ 
        echo "this value is in array";
    } else {
        echo "this value is not in array";
    }
}

need to account for nested arrays

answered Mar 24, 2015 at 21:44

J Hock

1293 bronze badges

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

Comments

exussum · Accepted Answer · 2015-03-24 21:42:20Z

0

You are searching for a value of VF-300 in an array containing other arrays.

You would need to loop though all values. If you know what you need to do when you are populating the array from the database you can use that loop.

eg

   while($row = mysql_fetch_assoc($result))
    {   
       if(in_array("VF-300", $row)){ 
          echo "this value is in array";
       } else {
          echo "this value is not in array";
       }
        $results[] = $row;

Alternatively you will need to loop again.

answered Mar 24, 2015 at 21:42

exussum

18.6k8 gold badges35 silver badges67 bronze badges

Comments

vcanales · Accepted Answer · 2015-03-24 22:06:43Z

0

Here, I felt like making something. This works because your original array is made of other arrays, so if you just use in_array, it's checking for a value and not a value within the members. This function does that for you:

    function in_array_m($needle,$haystack) {
        return in_array(true,array_map(function($v) use($needle,$haystack) { 
            return in_array($needle,$v); 
        },$haystack));
    }

The typical solution involves a loop, but I wanted to make a mess!

The advantage of this solution over others here is that you get just true or false, and not one result for each subset!

edited Mar 24, 2015 at 22:06

answered Mar 24, 2015 at 21:56

vcanales

1,82816 silver badges20 bronze badges

Collectives™ on Stack Overflow

Check if value in array and create php if statement

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related