SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, Host: perfect-database.cf4sk0a4ka4f.ap-south-1.rds.amazonaws.com, Port: 3306, Database: perfect_db, SQL: select * from `branch_office` where `clientgroupid` = 15 and `isactive` = 1)
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->tryAgainIfCausedByLostConnection(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->handleQueryException(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get()8use Auth;910class BranchModel extends Model 11{12 public static function get_companybranches($companyid){13 $data=DB::table('branch_office')->where('clientgroupid',$companyid)->where('isactive',1)->get();14 return $data;15 }16 17 public static function get_branches($id){18 $branchlist=DB::select("Call usp_branches_list(".($id !== '' && $id !== null ? intval($id) : 'NULL').")");19 return $branchlist;20 }21 22 23 // public static function get_branches($id) {24 // $branchlist = DB::select(" SELECT b.*, h.StateHeadofficeName FROM branch_office b LEFT OUTER JOIN state_headoffice h ON b.StateHeadofficeId = h.StateHeadofficeId25App\Models\BranchModel::get_companybranches(integer)101 }102103 public function contact_us(){104 $commandata=CommanModel::imp_ids();105 $companyid=$commandata['companyid'];106 $branch_list=BranchModel::get_companybranches($companyid);107 // print_r($branch_list);108 // die;109 $users=UserModel::get_user_count();110 111 $order=ClientCatalogModel::get_orders_count();112 $data['branches']=$branch_list;113 $data['users']=$users;114 $data['orders']=$order;115 return view('contact_us',$data);116 }117 118App\Http\Controllers\HomeController->contact_us()Illuminate\Routing\Controller->callAction(string, array)Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\HomeController), string)Illuminate\Routing\Route->runController()Illuminate\Routing\Route->run()Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Illuminate\Http\Request), object(Illuminate\Session\Store), object(Closure))Illuminate\Session\Middleware\StartSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))38 }3940 // Lax lets the cookie ride same-site top-level POSTs (the login form submit).41 config(['session.same_site' => 'lax']);4243 return $next($request);44 }45}46App\Http\Middleware\ConfigureLiveSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->handle(object(Illuminate\Http\Request))Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/../bootstrap/app.php';1920$app->handleRequest(Request::capture());21require(string)23/**4 * Root front controller so app works at /perfect-live-latest/5 * without requiring /public in the URL.6 */7require __DIR__.'/public/index.php';8