how to get inner array from Outer array

Question

I want to pull a array from outer array.

My result

I want to remove circle symbol of array

{
"Success": "1",
"Message": "Subtopic Wise Questions...",
"Subtopic Questions": [
    [
        {
            "id": "93",
            "topic_id": "36",
            "name": "Cell membrane and organelle",
            "created_at": "2018-08-29 23:06:34",
            "updated_at": "2018-08-29 23:06:34",
            "q_count": "127"
        }
    ],   
]

}

Here is my output result of array. the

My Controller code

 foreach($findid as $v)
        {
            $count[] = DB::table('questions')
                        ->join('subtopics', 'subtopics.id', 'questions.subtopic_id')
                        ->select('subtopics.*', DB::raw('count(questions.id) as q_count'))
                        ->where('subtopic_id', $v)
                        ->get();
        }


        return response([
                    'Success' => "1",
                    'Message' => "Subtopic Wise Questions...",
                    'Subtopic Questions'   => $count
                    ]);

make foreach loop through Subtopic Questions->Subtopic Questions — Jinal Somaiya
– Jinal Somaiya, Commented Nov 29, 2018 at 5:53
@JigneshJoisar if i use $count it's return only first column of result. — Krish Bhardwaj
– Krish Bhardwaj, Commented Nov 29, 2018 at 5:57
Seems to my you should try to fetch all required rows at once instead of one each time. — DigiLive
– DigiLive, Commented Nov 29, 2018 at 5:58

Leena Patel · Accepted Answer · 2018-11-29 06:11:51Z

2

use first() to obtain just an object as per your image you want to remove extra array quotes so

$count[] = DB::table('questions')
                    ->join('subtopics', 'subtopics.id', 'questions.subtopic_id')
                    ->select('subtopics.*', DB::raw('count(questions.id) as q_count'))
                    ->where('subtopic_id', $v)
                    ->first();

Hope it helps you!

edited Nov 29, 2018 at 6:11

answered Nov 29, 2018 at 5:56

Leena Patel

2,4531 gold badge17 silver badges30 bronze badges

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

4 Comments

Leena Patel Over a year ago

@KrishBhardwaj Eloquent will return an array of objects as you have displayed result it is clearly shown that its an array of objects if you dont use toArray() . So if you just want to pull array not object than you will need to use toArray()

Krish Bhardwaj Over a year ago

i used toArray() but not working to achieve result according me.

Leena Patel Over a year ago

ohh okay i got it ! please check my edited answer. @KrishBhardwaj

Ijas Ameenudeen Over a year ago

@KrishBhardwaj QueryBuilder will return Illuminate\Support\Collection. @LeenaPatel Eloquent will return `Illuminate\Database\Eloquent\Collection. Not array or array of objects.

Jignesh Joisar · Accepted Answer · 2018-11-29 06:21:43Z

1

use whereIn method instead of where method

note only store id in array then used whereIn method

$count = DB::table('questions')
                ->join('subtopics', 'subtopics.id', 'questions.subtopic_id')
                ->select('subtopics.*', DB::raw('count(questions.id) as q_count'))
                ->whereIn('subtopic_id', array_wrap($findid))
                ->get();

note if not working as u want restult then add toArray() method in query like this

$count->toArray();

 return response([
               'Success' => "1",
               'Message' => "Subtopic Wise Questions...",
               'Subtopic Questions'   => $count
     ]);

edited Nov 29, 2018 at 6:21

answered Nov 29, 2018 at 6:15

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

1 Comment

Ijas Ameenudeen Over a year ago

Can replace is_array($findid) ? $findid : [ $findid] with array_wrap($findid)

Ijas Ameenudeen · Accepted Answer · 2018-11-29 06:33:51Z

0

Your query is expensive. Since you are looping through array of ids, you are going to run queries count(findid) number of times. You can optimize and achieve the same as,

$count = DB::table('questions')
            ->join('subtopics', 'subtopics.id', 'questions.subtopic_id')
            ->select('subtopics.*', DB::raw('count(questions.id) as q_count'))
            ->whereIn('subtopic_id', $findid)
            ->get();


return response([
    'Success' => "1",
    'Message' => "Subtopic Wise Questions...",
    'Subtopic Questions'   => $count
]);

answered Nov 29, 2018 at 6:33

Ijas Ameenudeen

9,2794 gold badges44 silver badges55 bronze badges

Collectives™ on Stack Overflow

how to get inner array from Outer array

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related