Convert SQL retrieve result into a string in Laravel

Question

I have a retrieve statement that goes like this

$arrayAID = request('agentID');
    $sizeAID = count($arrayAID);
    $aidList = "null";
    for($a = 0; $a < $sizeAID; $a++){
        $email = DB::table('insuranceAgents')
                 ->select('email')
                 ->where('agentID', '=', $arrayAID[$a])
                 ->get();
        dd($email);
    }

which returns the result

What can I do to modify this $email to only get "[email protected]" as my result?

Alexey Mezenin · Accepted Answer · 2017-12-17 13:48:12Z

2

You can use the value() method:

DB::table('insuranceAgents')->where('agentID', $arrayAID[$a])->value('email');

value('email') is a shortcut for ->first()->email

You may extract a single value from a record using the value method. This method will return the value of the column directly

https://laravel.com/docs/5.5/queries#retrieving-results

edited Dec 17, 2017 at 13:48

answered Dec 17, 2017 at 13:43

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

ndrwnaguib · Accepted Answer · 2017-12-17 13:43:33Z

1

You can use ->first() . In your case,

$arrayAID = request('agentID');
$sizeAID = count($arrayAID);
$aidList = "null";
for($a = 0; $a < $sizeAID; $a++){
    $email = DB::table('insuranceAgents')
             ->select('email')
             ->where('agentID', '=', $arrayAID[$a])
             ->get()->first();
    dd($email);
}

answered Dec 17, 2017 at 13:43

ndrwnaguib

6,2463 gold badges33 silver badges56 bronze badges

Collectives™ on Stack Overflow

Convert SQL retrieve result into a string in Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related