Laravel help

$insert_query = "INSERT INTO `comp_voting`(audio_id,competition_id,user_id) VALUES(:audio_id,:competition_id,:user_id)"; $insert_stmt = $conn->prepare($insert_query); $insert_stmt->bindValue(':audio_id', htmlspecialchars(strip_tags($_POST["audio_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':competition_id', htmlspecialchars(strip_tags($_POST["competition_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':user_id', htmlspecialchars(strip_tags($_POST["user_id"])), PDO::PARAM_INT); $insert_stmt->execute();

$sql = 'UPDATE comp_audios SET vote = vote + 1 WHERE ( id = :id )'; $prepStatement = $conn->prepare( $sql ); $prepStatement->execute(array(':id' => $_POST["audio_id"]));

Product::with(['productdescription'=>function ($query) use ($language_id) { $query->where('language_id', '=', $language_id);},'images','productdiscount'])->active()->visibility(1)->order('DESC')->paginate($pagination) $orderdetails= OrderDetail::with(['order', 'product' => function ($query) use ($language_id ) { $query->with(['images','productdiscount', 'productdescription' => function ($query) use ($language_id) { $query->where('language_id',$language_id); }])->active(); },])->distinct('product_id')->latest()->limit(6)->paginate(6);

$latitude = $request->latitude; $longitude = $request->longitude; $distance = 30; $users = User::whereHas('userprofile', function($q) use ($latitude, $longitude, $distance) { $q->where([ ['latitude', '!=', $latitude], ['longitude', '!=', $longitude] ]) ->whereRaw( DB::raw( "(3959 * acos( cos( radians($latitude) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($longitude) ) + sin( radians($latitude) ) * sin( radians( latitude ) ) ) ) where('role', 2)->where('status', 1)->get();