check if value exists in array

Question

I have 2 queries and I want to check if values of one queries exists in array of other query. I have "maintenance" which has "process_id" and "processes" (array of process id's). I want to check for each process_id if exists in processes. in my controller:

$processes = DB::select('select id from processes');
$maintenance = DB::select('select process_id from maintenances where car_id ="' . $id . '" group by process_id');
        $result = array();
        foreach ($processes as $key => $value) {
            $result[] = $value->id;
        }

In my Helper.php

public static function array_value($value, $array) {
        $results = 0;
        $str = "$value";
        if (in_array($str, $array)) {
            $results += 5;
        } else {
            $results += 1;
        }
        return $results;
    }

In my view

 @foreach ($maintenance as $m)                         
          <tr> @if (Helpers\Helper::array_value($m->process_id, $processes)== 5)
               <td>   {{ $m->process }} </td>
                @elseif (Helpers\Helper::array_value($m->process_id, $processes)== 1) 
                  <td>Missing</td>    
                   @endif
          </tr>                                                 
  @endforeach

And it displays only values in the first if. It doesn't displays Missing when process_id isn't found in array processes

Ray · Accepted Answer · 2014-05-26 15:21:59Z

1

If you're using laravel have you considered setting up a relationship to make this task simpler?

I assume process and maintenance will have a one to many relationship?

You could set up a many to many relationship:

in your process model:

public function maintenance() {
    return $this->belongsTo('Maintenance')
}

(where Maintenance is the name of your model class. The function name can be anything)

In your maintenance model:

public function process() {
    return $this->hasMany('Process')
}

Then your revised model retrieval is:

$maintenance = Maintenance::find($id);

UPDATED: $maintenance = Maintenance::where('car_id', '=', $id)->first();

$maintenance->load('process');

(you could chain these)

Then in your view:

@if($maintenance->process()->first())

{{$maintenance->process()->name}} //or whatever positive output

@else

"NO process found" //or your negative output

@endif

The relationship does the hard work for you - you also then have the properties of the related mode available such as name etc which may be more user friendly.

the first() method retrieves the first related model. if this is null (ie not found) then the negative response works. YOu could also use count() which may be better then use:

@if($maintence->process()->count() > 0)

but all depends what you want to do.

YOu can also explore the get() method which will return a collection, useful if you expand your relationship to a many to many eg each maintenance may have many processes/

Hope this helps

edited May 26, 2014 at 15:21

answered May 26, 2014 at 13:39

Ray

3,0609 gold badges55 silver badges93 bronze badges

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

11 Comments

user3612192 Over a year ago

thank you for response. It shows this error in my controller: Call to a member function load() on a non-object at this line: $maintenance->load('process');

user3612192 Over a year ago

and dd($maintenance) shows NULL and I don't have a construct, what should I put there?

Ray Over a year ago

if $maintenance is null then it's not found your maintenance model with the id specified. The find() method looks for the model with an id and searched the id column - just re-read your question and your searching on a different column. You'll need to change the approach - just updated the answer

user3612192 Over a year ago

now it shows Call to a member function process() on a non-object at line @if($maintence->process()->first()) in my view. Also I want to check for distinct process_id, is this included ?

Ray Over a year ago

there's a spelling mistake! $maintence should be $maintenance

|

Collectives™ on Stack Overflow

check if value exists in array

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest