PHP get one row from an array based on a variables value

Question

If i create an array from results returned in a mysqli query is there a way to select and use only one specific row from the array?

$info= array();
while($row = mysqli_fetch_assoc($query)) {
    $info[] = array(  
        'id' => $row['id'],  
        'location' => $row['location']
    );  
}

How would i go about displaying only a single row from this array where the id equals a variable like $id?

Explosion Pills · Accepted Answer · 2015-06-14 23:06:15Z

1

In your loop you could just do something like:

if ($id == $row['id']) {
    $info[] = $row;
}

However it would make more sense to me to just update your query.

SELECT cols FROM t1 WHERE id = :id

Using $id as a parameter.

answered Jun 14, 2015 at 23:06

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

Matt Over a year ago

Im using the array result in a different while loop using if(in_array) So i need all the results and not just the one the query would return. That part of my code works fine ill try your suggestion thanks.

Collectives™ on Stack Overflow

PHP get one row from an array based on a variables value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related