Forum Query with Query Builder. What's wrong?

haseeb90

posted 9 years ago

Database

Last updated 1 year ago.

usm4n

replied 9 years ago

Solution

Hi Haseeb, You should not use the user input directly inside a raw query expression. Neways I hope this solves your problem:

    $users = DB::table("feedMentions")
                ->select(
                    DB::raw('taggedUserName'),
                    DB::raw('COUNT(taggedUserId) AS freq')
                )
                ->whereRaw(DB::raw('postId IN (SELECT postId FROM feedPosts WHERE postedByUserName = :userId)'),['userId'=>$userId])
                ->groupBy('taggedUserId')
                ->orderBy('freq', 'DESC')->get();

Last updated 1 year ago.