laravel eloquent using a json object to search and array in my database

Question

I have a json object

'developer' => 
  array (
    'count' => 1,
    'docPosition' => 100,
    'countCv' => 1,
    'weight' => '0.077',
  ),
  'Software Engineer' => 
  array (
    'count' => 4,
    'docPosition' => 716,
    'countCv' => 4,
    'weight' => '0.308',
  ),
  'engineer' => 
  array (
    'count' => 5,
    'docPosition' => 725,
    'countCv' => 5,
    'weight' => '0.385',
  ),
  'Software Development Engineer' => 
  array (
    'count' => 1,
    'docPosition' => 1272,
    'countCv' => 1,
    'weight' => '0.077',
  ),
  'Development Engineer' => 
  array (
    'count' => 1,
    'docPosition' => 1281,
    'countCv' => 1,
    'weight' => '0.077',
  ),
  'Contract' => 
  array (
    'count' => 1,
    'docPosition' => 1303,
    'countCv' => 1,
    'weight' => '0.077',
  ),
)

I want to get the keys of the object (developer, Software Engineer, engineer, etc) and use them to search the db for matches that are in a field called Industry that is an array. I am unsure about the following.

How to get the keys on the object and turn it into an array.
Search my db for any matches between the array I created and the array in the field Industry.

I have searched google and stack and have not found anything helpful. Any ideas or strategies would be appreciated.

What SQL you are using? array is a vendor-specific column type. iirc eloquent just converts arrays to strings to persist it in the db. — Alex Blex
– Alex Blex, Commented May 15, 2017 at 17:10

Rezrazi · Accepted Answer · 2017-05-15 17:03:23Z

1

You can make that json object into a Collection :

$collection=collect(json_decode($yourObject);

And get the keys :

$keys = $collection->keys();

And you can retrieve from your data like this

$data = collect($yourData);
$results = $keys->each(function($key){
             $data->only($key);
             //do your logic with it
});

you can learn more about it here : Laravel Collection

answered May 15, 2017 at 17:03

Rezrazi

9051 gold badge7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

laravel eloquent using a json object to search and array in my database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related