Using concat in laravel

Question

iam trying to give url to my image, so i try to use concat. but in there i have trouble if the concat just use to 1 column i can make it. but is use 3 column, so i dont now how to do it ?

this is my controller :

$site = asset("uploads").'/';
        $result = DB::table('log_patrol_details')
        ->select("*",DB::raw("concat('$site',photo1) as photo1"))
        ->where('id_log_patrols', $request->input('id_log_patrols'))
        ->orderBy('id', 'desc')
        ->first();
        if(count($result)==0) {
            $response['api_status'] = 0;
            $response['api_message'] = "Belum ada data";
        }else{
            $response['api_status'] = 1;
            $response['api_message'] = "success";
            $response['items'] = $result;
        }
        return response()->json($response);

iam try to add concat to my photo1, photo2, and photo3

haakym · Accepted Answer · 2016-05-25 07:53:17Z

1

I'm not fully sure I've understood your question. Can't you just add two more statements to your select for photo2 and photo3 and you're good to go?

->select("*",
    DB::raw("concat('$site',photo1) as photo1"),
    DB::raw("concat('$site',photo2) as photo2"),
    DB::raw("concat('$site',photo3) as photo3")
)

answered May 25, 2016 at 7:53

haakym

12.4k12 gold badges72 silver badges101 bronze badges

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

2 Comments

APSB Over a year ago

iam try it : ("concat('$site',photo2) as photo2"),("concat('$site',photo3) as photo3") just like that so thanks ya for the correction :D

haakym Over a year ago

@AdamProjo You're welcome. If it worked for you please accept the answer. Thanks!

Collectives™ on Stack Overflow

Using concat in laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related