PHP - Extract value from query array

Question

Do you have to use a loop to extract the value from a query array.

Query:

$fetchRegion = Singlequery("SELECT region FROM regions WHERE id = :id LIMIT 1",
                           array('id' => $_GET['region']),
                           $conn);

This is my array:

array(1) {
  [0]=>
  array(1) {
    ["region"]=>
    string(10) "South West"
  }
}

I want to take the value and use it in another query, I didn't know if I had to use a foreach for example to get the value to use in my next query. The other stackoverflow questions that I saw used a loop

Rather than take that value and use it in another query, consider using a single query with a JOIN: What's the query that you want to use it in? — Mark Baker
– Mark Baker, Commented Jan 26, 2015 at 11:48

krzysiej · Accepted Answer · 2015-01-26 12:19:48Z

1

If i understand your question correctly and you want to acces to value then access it like so:

$fetchRegion[0]['region'];

You don't need to use foreach or any other loop since it will return at most one element because LIMIT 1 you used in query.

edited Jan 26, 2015 at 12:19

answered Jan 26, 2015 at 11:52

krzysiej

9089 silver badges22 bronze badges

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

2 Comments

Sam Over a year ago

Can I use this to get a string and store it in another variable so for example $region = 'string from array';

krzysiej Over a year ago

Yes, you can ex. $region = $fetchRegion[0]['region'];

Rakesh Sharma · Accepted Answer · 2015-01-26 11:50:43Z

1

Using loop :-

foreach($fetchRegion as $v) {
  $var = $v["region"];
}

or you get directly like:-

echo $fetchRegion[0]["region"];

answered Jan 26, 2015 at 11:50

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Comments

James Waddington · Accepted Answer · 2015-01-26 11:51:57Z

0

No, there is no need to use a loop with that query because it will not return more than a single row. Instead, just check that you got a row back (it could return no results), and then use it.

answered Jan 26, 2015 at 11:51

James Waddington

2,9252 gold badges18 silver badges24 bronze badges

Comments

Simon Brahan · Accepted Answer · 2015-01-26 11:52:56Z

0

If you're certain that your result is going to look like that, reset(reset($fetchRegion)) will give you the value 'south west'. It will behave badly if you don't get that exact format back though - for example, if the query does not return a row.

answered Jan 26, 2015 at 11:52

Simon Brahan

2,1042 gold badges15 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP - Extract value from query array

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related