Skip to main content

get records using location by dynamic radius from database.

$postads = PostAds::with('userInfo')
                            ->has('userInfo')
                            ->where('user_id','!=',Auth::id())
                            ->whereRaw('(ST_Distance_Sphere(POINT('.$lng.','.$lat.'), POINT(longitude,latitude))/1000) <= radius')
                            ->paginate(10);
Labels:

Comments

Post a Comment

Popular posts from this blog

Issue - Laravel Socialite: Legacy People API has not been used in project

If you have an issue with Google Login in Laravel Socialite, Follow these instructions. Change this file ./vendor/laravel/socialite/src/Two/GoogleProvider.php with this: <?php namespace Laravel\Socialite\Two; use Illuminate\Support\Arr; class GoogleProvider extends AbstractProvider implements ProviderInterface {     protected $scopeSeparator = ' ';     /**      * The scopes being requested.      *      * @var array      */     protected $scopes = [         'openid',         'profile',         'email',     ];     /**      * {@inheritdoc}      */     protected function getAuthUrl($state)     {         return $this->buildAuthUrlFromBase('https://accounts.google.com/o/oauth2/auth', $state); ...
Post a Comment
Read more

Paypal Payment API

/*******************/ $payment_type = 'Sale'; $amount = $invoice->price + $invoice->due_price + $invoice->service_charge; $send = 'VERSION=51.0'; $send.= '&USER=' . urlencode('Credit card Username'); $send.= '&PWD=' . urlencode('Credit Card Password'); $send.= '&SIGNATURE=' . urlencode('Credit Card Signature'); $send.= '&METHOD=DoDirectPayment'; $send.= '&PAYMENTACTION=' . $payment_type; $send.= '&IPADDRESS=' . urlencode($_SERVER['REMOTE_ADDR']); $send.= '&AMT=' . $amount; $send.= '&CREDITCARDTYPE=' . $request->cc_type; $send.= '&ACCT=' . urlencode(str_replace(' ', '', $request->cc_number)); $send.= '&EXPDATE=' . urlencode($request->cc_expire_date_month . $request->cc_expire_date_year); $send.= '&CVV2=' . urlencode($request->cvv); $send...
Post a Comment
Read more