php - Check an MySQL output -

php - Check an MySQL output -

i'm wondering how go around checking on mysql about, know if type: homecoming $seat[0].

i output: {"id":1,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null}

but how illustration check on timestamp value id equal something?

the total statement if type homecoming $seat is:

[{"id":1,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":2,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":3,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":4,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":5,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":6,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":7,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":8,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":9,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":10,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":11,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":12,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":13,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":14,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":15,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":16,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":17,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":18,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":19,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":20,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":21,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":22,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":23,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":24,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":25,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":26,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":27,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":28,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":29,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":30,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":31,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":32,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":33,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":34,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":35,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":36,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":37,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":38,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":39,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":40,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":41,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":42,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":43,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":44,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":45,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":46,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":47,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":48,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":49,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null},{"id":50,"user_id":null,"timestamp":null,"temp_user_id":null,"temp_timestamp":null}]

but again, want check 1 item specific id. result, not mysql query

might you're looking for? selecting values 2 tables same id?

edit: if not please elaborate.

select * yourtable inner bring together othertable on yourtable.id=othertable.id;

this might work.

foreach($seat $sea){ $int = 1 if (in_array($int, $sea->id)) { echo $sea->id } else { echo "1 not here"; }}

else seek this

foreach($seat $sea => st){ $int = 1 $null = null; if (in_array($null, $st->timestamp)) { //timestamp null go else } else { if(in_array($int, $st->id)){ //checked if id equal } }}

php laravel website