上传到服务器时，DB :: raw是否会产生影响？(Does DB::raw affect when uploaded on server?)

 目前使用此代码来获取mysql上的数据及其在本地主机上的工作，但是当我将其上传到我们的AWS服务器时，它会停止排序？ 
 
$raw = "( 3959 * acos( cos( radians('$lat') ) * cos( radians( '$lat' ) ) * cos( radians( longitude ) - radians('$lon') ) + sin( radians('$lat') ) * sin( radians( latitude ) ) ) ) AS distance";
$stores = DB::table('stores')
    ->select('storename', 'id', 'photo', 'address', DB::raw($raw))
    ->orderBy('distance')
    ->where('domain', $domain->appEnv)
    ->take(25)
    ->get();
 
 当我上传AWS时，是否有某些内容会受到影响？ 
 
 请注意，我们的数据库位于不同的RDS服务器上 

Currently using this code to fetch data on mysql and its working on my localhost but when I uploaded it on our AWS server it stop sorting?
 
$raw = "( 3959 * acos( cos( radians('$lat') ) * cos( radians( '$lat' ) ) * cos( radians( longitude ) - radians('$lon') ) + sin( radians('$lat') ) * sin( radians( latitude ) ) ) ) AS distance";
$stores = DB::table('stores')
    ->select('storename', 'id', 'photo', 'address', DB::raw($raw))
    ->orderBy('distance')
    ->where('domain', $domain->appEnv)
    ->take(25)
    ->get();
 
Is there something that is being affected when I uploaded on AWS?
 
Note that our DB is on a different server for RDS

原文：https://stackoverflow.com/questions/31720363