Laravel : How to retrieve data from inside an nested array

Question

I am trying to retrieve a specific column from a table in my database. Name of the column is verification_type_id and table is certificate_verification_type.

When I vardump() the variable which I am using to retrieve the column, here is what I get:

array(2)
{
    [14]=> array(2)
    {
        ["certificate_id"]=> int(9)
        ["verification_type_id"]=> int(2)
    }
    [15]=> array(2)
    {
        ["certificate_id"]=> int(9)
        ["verification_type_id"]=> int(3)
    }
}

Here is my laravel eloquent query:

$certVeriType = CertificateVerificationType::all()->where('certificate_id', $certType)->toArray();

How can I only retrieve the column 'verification_type_id' form the table. Here is the migration file of the table:

$table->integer('certificate_id');
$table->integer('verification_type_id');
$table->index('certificate_id');

Thanks in advance!

Loop it with `foreach(){}` and access the specific member which you need. — MonkeyZeus, Dec 13 '18 at 17:45
Possible duplicate of [Loop through an array php](https://stackoverflow.com/questions/4414623/loop-through-an-array-php) — MonkeyZeus, Dec 13 '18 at 17:46
You can use the `select()` method in your query to specify which column(s) you want. — Don't Panic, Dec 13 '18 at 17:50

score 0 · Accepted Answer · answered Dec 13 '18 at 17:48

0

Add -> pluck() ( The pluck method retrieves all of the values for a given key ) to your eloquent query:

$certVeriType = CertificateVerificationType::all()
    ->where('certificate_id', $certType)
    ->pluck('verification_type_id')
    ->toArray();

answered Dec 13 '18 at 17:48

Emmanuel HD

191
7

Laravel : How to retrieve data from inside an nested array

1 Answers1