PHP - fetch value of specified key pair in mulit-dimensional array

Question

hopefully a easy one for you,

my sql query is returning a mulit-dimensional array, I need to access only one key the is nested on the second level but cant figure out how.

here is my function.

public function get_visitor_id($id)
{
  $this->db->where('mobile',$id);
  $this->db->or_where('email',$id);
  $this->db->select('uid');
  $result = $this->db->get('visitors');
  if ($result)
  {
    foreach ($result->result() as $key=>$value){
      $array[$key] = $value;
    }
    var_dump($array);
    return $array;
  }
}

The array returned is

{ [0]=> object(stdClass)#20 (1) { ["uid"]=> string(2) "24" } }

I only need the value of ['uid'] so in essence if I was to echo get_visitor_id() it would evaluate to "24".

Thanks for you help.

Cheers

xYuri, Im not sure if I needed to, but im still quite new to programming so thought it would be easiest to loop through the results and add them to an array and then return only that key's value. I am open to a better way of doing it. — Codecowboy
– Codecowboy, Commented Sep 29, 2016 at 1:07

xYuri · Accepted Answer · 2016-09-28 21:55:24Z

1

try changing foreach() func to:

foreach($result as $res){
$res = $res->fetch_assoc();
$array['uid'] = $res['uid'];}

EDIT: in case of this didn't work then try while loop:

while($res = $result->fetch_assoc()){
  $array['uid'] = $res['uid'];
}

edited Sep 28, 2016 at 21:55

answered Sep 28, 2016 at 21:48

xYuri

3854 silver badges17 bronze badges

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

4 Comments

Barmar Over a year ago

It doesn't look like he's using mysqli. I think it's Laravel.

xYuri Over a year ago

if so, i wont be much useful in that case :(

Codecowboy Over a year ago

Thanks, I will give that a try. I am using codeignitor and its built in library

xYuri Over a year ago

well try it and tell me what you got ;) hope it helps

Collectives™ on Stack Overflow

PHP - fetch value of specified key pair in mulit-dimensional array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related