'where' like querying an array or object

Question

[{"id":1,"username":"example","email":"example@gmail.com","password":"example123","created_at":"2015-01-13 11:39:24","updated_at":"2015-01-13 11:39:24"},
{"id":2,"username":"ex2","email":"ex@ex.com","password":"example","created_at":"2015-01-13 11:39:02","updated_at":"2015-01-13 11:39:02"}]

I got an object like above. The thing I want to is select the object that's id is 1 for example. Like

select * from object where id=1

with SQL

How to do it?

@NoLiver92 I really can't consider how to search about this? — Philosopher, Jan 13 '15 at 10:16
You might be looking for PHPLinq or YaLinqo http://stackoverflow.com/questions/5792388/is-there-something-in-php-equivalent-to-linq-in-c — nl-x, Jan 13 '15 at 10:25
@Mark Baker He didn't ask how to use SQL on a json object, he asked how to get to the same result via php. — Masiorama, Jan 13 '15 at 10:27
@MarkBaker I don't understand if you are being sarcastic or what. I din't mean to bother you, I just pointed out something that seemed wrong to me. — Masiorama, Jan 13 '15 at 10:56

score 0 · Answer 1 · answered Jan 13 '15 at 10:16

Decode your object (http://php.net/manual/it/function.json-decode.php) and then traverse your array with a foreach checking the id value inside of it with an if statement.

$obj_to_array = json_decode($json_object);
$target = '';
foreach($obj_to_array as $row){
  if($row['id'] == 1)
    $target = $row;
}

// $target holds your row with id = 1

score 0 · Answer 2 · answered Jan 13 '15 at 10:18

$data = '[{"id":1,"username":"example","email":"example@gmail.com","password":"example123","created_at":"2015-01-13 11:39:24","updated_at":"2015-01-13 11:39:24"},
{"id":2,"username":"ex2","email":"ex@ex.com","password":"example","created_at":"2015-01-13 11:39:02","updated_at":"2015-01-13 11:39:02"}]';

$data = json_decode($data);

$id = 1;
$key = 'id';
$data = array_filter(
    $data,
    function($value) use ($key, $id) {
        return ($value->$key == $id);
    }
);
var_dump($data);

score 0 · Answer 3 · answered Jan 13 '15 at 10:18

Decode the object using json_decode. Use the code below

    <?php
    $json='[{"id":1,"username":"example","email":"example@gmail.com","password":"example123","created_at":"2015-01-13 11:39:24","updated_at":"2015-01-13 11:39:24"},
    {"id":2,"username":"ex2","email":"ex@ex.com","password":"example","created_at":"2015-01-13 11:39:02","updated_at":"2015-01-13 11:39:02"}]';
    $p = json_decode($json,true);
    $l=count($p);
    for($i=0;$i<=$l;$i++){
    $id=$p[$i]["id"];
if($id==1){
    print_r($p[$i]); // WIll print the id if 1
}
    }

Hope this helps you

score 0 · Accepted Answer · answered Jan 13 '15 at 10:19

0

I hope i got your question right. Try the following

<?php
$array = json_decode('[{"id":1,"username":"example","email":"example@gmail.com","password":"example123","created_at":"2015-01-13 11:39:24","updated_at":"2015-01-13 11:39:24"},
{"id":2,"username":"ex2","email":"ex@ex.com","password":"example","created_at":"2015-01-13 11:39:02","updated_at":"2015-01-13 11:39:02"}]');

foreach( $array as $v ) {
  if( $v["id"] == 1 ) {
    echo "I am ID 1";
    break;
  }
}

answered Jan 13 '15 at 10:19

Jonas m

2,646
3
22
43

1

Well. No matter what method you are using, filtering or direct traversing ( Same stuff basically ) It's going to be slow and ressource hungry if you have a thousand objects, so dont get yourself a thousand objects. Filter them out before recieving the JSON string. Where do you get the data from? Don't the service have a limit parameter or something like that? – Jonas m Jan 13 '15 at 10:26
I got comments table and user_id row. In single post page I got all of the usernames for now but yes I can filter but that will not make statement clearer.. – Philosopher Jan 13 '15 at 10:28
1

The point is to do searches/filterings on the platforms ment for it and optimized for it. If you can do the select through sql before getting the JSON or through the API, do so, if not. Well, then do the traversing/foreach. It wont break your server :-) – Jonas m Jan 13 '15 at 10:31

'where' like querying an array or object

4 Answers4