Cách Sử Dụng Hàm VLOOKUP Kết Hợp Hàm LEFT Trong Excel

Trang chủ » Cách Sử Dụng Vlookup Và Left » Cách Sử Dụng Hàm VLOOKUP Kết Hợp Hàm LEFT Trong Excel

Có thể bạn quan tâm

Application frames (1) All frames (40) 39 ErrorException …/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php122 38 file_put_contents …/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php122 37 Illuminate\Filesystem\Filesystem put …/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php83 36 Illuminate\Session\FileSessionHandler write …/vendor/laravel/framework/src/Illuminate/Session/Store.php129 35 Illuminate\Session\Store save …/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php170 34 Illuminate\Session\Middleware\StartSession saveSession …/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php65 33 Illuminate\Session\Middleware\StartSession handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 32 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 31 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php37 30 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 29 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 28 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php66 27 Illuminate\Cookie\Middleware\EncryptCookies handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 26 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 25 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php104 24 Illuminate\Pipeline\Pipeline then …/vendor/laravel/framework/src/Illuminate/Routing/Router.php682 23 Illuminate\Routing\Router runRouteWithinStack …/vendor/laravel/framework/src/Illuminate/Routing/Router.php657 22 Illuminate\Routing\Router runRoute …/vendor/laravel/framework/src/Illuminate/Routing/Router.php623 21 Illuminate\Routing\Router dispatchToRoute …/vendor/laravel/framework/src/Illuminate/Routing/Router.php612 20 Illuminate\Routing\Router dispatch …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php176 19 Illuminate\Foundation\Http\Kernel Illuminate\Foundation\Http\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php30 18 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php21 17 Illuminate\Foundation\Http\Middleware\TransformsRequest handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 16 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 15 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php21 14 Illuminate\Foundation\Http\Middleware\TransformsRequest handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 13 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 12 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php27 11 Illuminate\Foundation\Http\Middleware\ValidatePostSize handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 10 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 9 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php62 8 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 7 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 6 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/fideloper/proxy/src/TrustProxies.php57 5 Fideloper\Proxy\TrustProxies handle …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php163 4 Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure} …/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53 3 Illuminate\Routing\Pipeline Illuminate\Routing\{closure} …/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php104 2 Illuminate\Pipeline\Pipeline then …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php151 1 Illuminate\Foundation\Http\Kernel sendRequestThroughRouter …/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php116 0 Illuminate\Foundation\Http\Kernel handle …/public/index.php55 /home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php * * @param string $path * @return string */ public function hash($path) { return md5_file($path); } /** * Write the contents of a file. * * @param string $path * @param string $contents * @param bool $lock * @return int|bool */ public function put($path, $contents, $lock = false) { return file_put_contents($path, $contents, $lock ? LOCK_EX : 0); } /** * Write the contents of a file, replacing it atomically if it already exists. * * @param string $path * @param string $content * @return void */ public function replace($path, $content) { // If the path already exists and is a symlink, get the real path... clearstatcache(true, $path); $path = realpath($path) ?: $path; $tempPath = tempnam(dirname($path), basename($path)); // Fix permissions of tempPath because `tempnam()` creates it with permissions set to 0600... chmod($tempPath, 0777 - umask()); Arguments
  1. "file_put_contents(): Only 0 of 240 bytes written, possibly out of free disk space"
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php * * @param string $path * @return string */ public function hash($path) { return md5_file($path); } /** * Write the contents of a file. * * @param string $path * @param string $contents * @param bool $lock * @return int|bool */ public function put($path, $contents, $lock = false) { return file_put_contents($path, $contents, $lock ? LOCK_EX : 0); } /** * Write the contents of a file, replacing it atomically if it already exists. * * @param string $path * @param string $content * @return void */ public function replace($path, $content) { // If the path already exists and is a symlink, get the real path... clearstatcache(true, $path); $path = realpath($path) ?: $path; $tempPath = tempnam(dirname($path), basename($path)); // Fix permissions of tempPath because `tempnam()` creates it with permissions set to 0600... chmod($tempPath, 0777 - umask()); Arguments
  1. "/home/www/hoctv/public_html/storage/framework/sessions/bKHkJtwm6ksxn7csWRaiVojQRbVMm0VZy6L79bKo"
  2. "a:3:{s:6:"_token";s:40:"raxLznl6RIeHdkbulCqDM3fXFeqyUlg9QzIRiF0i";s:9:"_previous";a:1:{s:3:"url";s:82:"https://hoc.tv/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166";}s:6:"_flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}"
  3. 2
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php /** * {@inheritdoc} */ public function read($sessionId) { if ($this->files->isFile($path = $this->path.'/'.$sessionId)) { if ($this->files->lastModified($path) >= Carbon::now()->subMinutes($this->minutes)->getTimestamp()) { return $this->files->sharedGet($path); } } return ''; } /** * {@inheritdoc} */ public function write($sessionId, $data) { $this->files->put($this->path.'/'.$sessionId, $data, true); return true; } /** * {@inheritdoc} */ public function destroy($sessionId) { $this->files->delete($this->path.'/'.$sessionId); return true; } /** * {@inheritdoc} */ public function gc($lifetime) { $files = Finder::create() Arguments
  1. "/home/www/hoctv/public_html/storage/framework/sessions/bKHkJtwm6ksxn7csWRaiVojQRbVMm0VZy6L79bKo"
  2. "a:3:{s:6:"_token";s:40:"raxLznl6RIeHdkbulCqDM3fXFeqyUlg9QzIRiF0i";s:9:"_previous";a:1:{s:3:"url";s:82:"https://hoc.tv/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166";}s:6:"_flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}"
  3. true
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Session/Store.php * * @param string $data * @return string */ protected function prepareForUnserialize($data) { return $data; } /** * Save the session data to storage. * * @return void */ public function save() { $this->ageFlashData(); $this->handler->write($this->getId(), $this->prepareForStorage( serialize($this->attributes) )); $this->started = false; } /** * Prepare the serialized session data for storage. * * @param string $data * @return string */ protected function prepareForStorage($data) { return $data; } /** * Age the flash data for the session. * * @return void Arguments
  1. "bKHkJtwm6ksxn7csWRaiVojQRbVMm0VZy6L79bKo"
  2. "a:3:{s:6:"_token";s:40:"raxLznl6RIeHdkbulCqDM3fXFeqyUlg9QzIRiF0i";s:9:"_previous";a:1:{s:3:"url";s:82:"https://hoc.tv/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166";}s:6:"_flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}"
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php protected function addCookieToResponse(Response $response, Session $session) { if ($this->sessionIsPersistent($config = $this->manager->getSessionConfig())) { $response->headers->setCookie(new Cookie( $session->getName(), $session->getId(), $this->getCookieExpirationDate(), $config['path'], $config['domain'], $config['secure'] ?? false, $config['http_only'] ?? true, false, $config['same_site'] ?? null )); } } /** * Save the session data to storage. * * @param \Illuminate\Http\Request $request * @return void */ protected function saveSession($request) { $this->manager->driver()->save(); } /** * Get the session lifetime in seconds. * * @return int */ protected function getSessionLifetimeInSeconds() { return ($this->manager->getSessionConfig()['lifetime'] ?? null) * 60; } /** * Get the cookie lifetime in seconds. * * @return \DateTimeInterface|int */ protected function getCookieExpirationDate() { $config = $this->manager->getSessionConfig(); /home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php // If a session driver has been configured, we will need to start the session here // so that the data is ready for an application. Note that the Laravel sessions // do not make use of PHP "native" sessions in any way since they are crappy. $request->setLaravelSession( $session = $this->startSession($request) ); $this->collectGarbage($session); $response = $next($request); $this->storeCurrentUrl($request, $session); $this->addCookieToResponse($response, $session); // Again, if the session has been configured we will need to close out the session // so that the attributes may be persisted to some storage medium. We will also // add the session identifier cookie to the application response headers now. $this->saveSession($request); return $response; } /** * Start the session for the given request. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Contracts\Session\Session */ protected function startSession(Request $request) { return tap($this->getSession($request), function ($session) use ($request) { $session->setRequestOnHandler($request); $session->start(); }); } /** Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#329 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php * Create a new CookieQueue instance. * * @param \Illuminate\Contracts\Cookie\QueueingFactory $cookies * @return void */ public function __construct(CookieJar $cookies) { $this->cookies = $cookies; } /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $response = $next($request); foreach ($this->cookies->getQueuedCookies() as $cookie) { $response->headers->setCookie($cookie); } return $response; } } Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#330 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php * Disable encryption for the given cookie name(s). * * @param string|array $name * @return void */ public function disableFor($name) { $this->except = array_merge($this->except, (array) $name); } /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return \Symfony\Component\HttpFoundation\Response */ public function handle($request, Closure $next) { return $this->encrypt($next($this->decrypt($request))); } /** * Decrypt the cookies on the request. * * @param \Symfony\Component\HttpFoundation\Request $request * @return \Symfony\Component\HttpFoundation\Request */ protected function decrypt(Request $request) { foreach ($request->cookies as $key => $cookie) { if ($this->isDisabled($key)) { continue; } try { $request->cookies->set($key, $this->decryptCookie($key, $cookie)); } catch (DecryptException $e) { $request->cookies->set($key, null); } Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#331 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php public function via($method) { $this->method = $method; return $this; } /** * Run the pipeline with a final destination callback. * * @param \Closure $destination * @return mixed */ public function then(Closure $destination) { $pipeline = array_reduce( array_reverse($this->pipes), $this->carry(), $this->prepareDestination($destination) ); return $pipeline($this->passable); } /** * Run the pipeline and return the result. * * @return mixed */ public function thenReturn() { return $this->then(function ($passable) { return $passable; }); } /** * Get the final piece of the Closure onion. * * @param \Closure $destination * @return \Closure */ Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php * * @param \Illuminate\Routing\Route $route * @param \Illuminate\Http\Request $request * @return mixed */ protected function runRouteWithinStack(Route $route, Request $request) { $shouldSkipMiddleware = $this->container->bound('middleware.disable') && $this->container->make('middleware.disable') === true; $middleware = $shouldSkipMiddleware ? [] : $this->gatherRouteMiddleware($route); return (new Pipeline($this->container)) ->send($request) ->through($middleware) ->then(function ($request) use ($route) { return $this->prepareResponse( $request, $route->run() ); }); } /** * Gather the middleware for the given route with resolved class names. * * @param \Illuminate\Routing\Route $route * @return array */ public function gatherRouteMiddleware(Route $route) { $middleware = collect($route->gatherMiddleware())->map(function ($name) { return (array) MiddlewareNameResolver::resolve($name, $this->middleware, $this->middlewareGroups); })->flatten(); return $this->sortMiddleware($middleware); } /** * Sort the given middleware by priority. * Arguments
  1. Closure($request) {#264 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php return $route; } /** * Return the response for the given route. * * @param \Illuminate\Http\Request $request * @param \Illuminate\Routing\Route $route * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ protected function runRoute(Request $request, Route $route) { $request->setRouteResolver(function () use ($route) { return $route; }); $this->events->dispatch(new Events\RouteMatched($route, $request)); return $this->prepareResponse($request, $this->runRouteWithinStack($route, $request) ); } /** * Run the given route within a Stack "onion" instance. * * @param \Illuminate\Routing\Route $route * @param \Illuminate\Http\Request $request * @return mixed */ protected function runRouteWithinStack(Route $route, Request $request) { $shouldSkipMiddleware = $this->container->bound('middleware.disable') && $this->container->make('middleware.disable') === true; $middleware = $shouldSkipMiddleware ? [] : $this->gatherRouteMiddleware($route); return (new Pipeline($this->container)) ->send($request) ->through($middleware) Arguments
  1. Illuminate\Routing\Route {#232}
  2. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ public function dispatch(Request $request) { $this->currentRequest = $request; return $this->dispatchToRoute($request); } /** * Dispatch the request to a route and return the response. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ public function dispatchToRoute(Request $request) { return $this->runRoute($request, $this->findRoute($request)); } /** * Find the route matching a given request. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Routing\Route */ protected function findRoute($request) { $this->current = $route = $this->routes->match($request); $this->container->instance(Route::class, $route); return $route; } /** * Return the response for the given route. * Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Illuminate\Routing\Route {#232}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ public function respondWithRoute($name) { $route = tap($this->routes->getByName($name))->bind($this->currentRequest); return $this->runRoute($this->currentRequest, $route); } /** * Dispatch the request to the application. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ public function dispatch(Request $request) { $this->currentRequest = $request; return $this->dispatchToRoute($request); } /** * Dispatch the request to a route and return the response. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response|\Illuminate\Http\JsonResponse */ public function dispatchToRoute(Request $request) { return $this->runRoute($request, $this->findRoute($request)); } /** * Find the route matching a given request. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Routing\Route */ protected function findRoute($request) Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php * @return void */ public function bootstrap() { if (! $this->app->hasBeenBootstrapped()) { $this->app->bootstrapWith($this->bootstrappers()); } } /** * Get the route dispatcher callback. * * @return \Closure */ protected function dispatchToRouter() { return function ($request) { $this->app->instance('request', $request); return $this->router->dispatch($request); }; } /** * Call the terminate method on any terminable middleware. * * @param \Illuminate\Http\Request $request * @param \Illuminate\Http\Response $response * @return void */ public function terminate($request, $response) { $this->terminateMiddleware($request, $response); $this->app->terminate(); } /** * Call the terminate method on any terminable middleware. * Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php use Symfony\Component\Debug\Exception\FatalThrowableError; /** * This extended pipeline catches any exceptions that occur during each slice. * * The exceptions are converted to HTTP responses for proper middleware handling. */ class Pipeline extends BasePipeline { /** * Get the final piece of the Closure onion. * * @param \Closure $destination * @return \Closure */ protected function prepareDestination(Closure $destination) { return function ($passable) use ($destination) { try { return $destination($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php namespace Illuminate\Foundation\Http\Middleware; use Closure; use Symfony\Component\HttpFoundation\ParameterBag; class TransformsRequest { /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $this->clean($request); return $next($request); } /** * Clean the request's data. * * @param \Illuminate\Http\Request $request * @return void */ protected function clean($request) { $this->cleanParameterBag($request->query); if ($request->isJson()) { $this->cleanParameterBag($request->json()); } elseif ($request->request !== $request->query) { $this->cleanParameterBag($request->request); } } /** Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#154 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php namespace Illuminate\Foundation\Http\Middleware; use Closure; use Symfony\Component\HttpFoundation\ParameterBag; class TransformsRequest { /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $this->clean($request); return $next($request); } /** * Clean the request's data. * * @param \Illuminate\Http\Request $request * @return void */ protected function clean($request) { $this->cleanParameterBag($request->query); if ($request->isJson()) { $this->cleanParameterBag($request->json()); } elseif ($request->request !== $request->query) { $this->cleanParameterBag($request->request); } } /** Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#207 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php class ValidatePostSize { /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed * * @throws \Illuminate\Http\Exceptions\PostTooLargeException */ public function handle($request, Closure $next) { $max = $this->getPostMaxSize(); if ($max > 0 && $request->server('CONTENT_LENGTH') > $max) { throw new PostTooLargeException; } return $next($request); } /** * Determine the server 'post_max_size' as bytes. * * @return int */ protected function getPostMaxSize() { if (is_numeric($postMaxSize = ini_get('post_max_size'))) { return (int) $postMaxSize; } $metric = strtoupper(substr($postMaxSize, -1)); $postMaxSize = (int) $postMaxSize; switch ($metric) { case 'K': return $postMaxSize * 1024; case 'M': Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#233 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php * * @throws \Symfony\Component\HttpKernel\Exception\HttpException */ public function handle($request, Closure $next) { if ($this->app->isDownForMaintenance()) { $data = json_decode(file_get_contents($this->app->storagePath().'/framework/down'), true); if (isset($data['allowed']) && IpUtils::checkIp($request->ip(), (array) $data['allowed'])) { return $next($request); } if ($this->inExceptArray($request)) { return $next($request); } throw new MaintenanceModeException($data['time'], $data['retry'], $data['message']); } return $next($request); } /** * Determine if the request has a URI that should be accessible in maintenance mode. * * @param \Illuminate\Http\Request $request * @return bool */ protected function inExceptArray($request) { foreach ($this->except as $except) { if ($except !== '/') { $except = trim($except, '/'); } if ($request->fullUrlIs($except) || $request->is($except)) { return true; } } Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#237 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/fideloper/proxy/src/TrustProxies.php { $this->config = $config; } /** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * * @throws \Symfony\Component\HttpKernel\Exception\HttpException * * @return mixed */ public function handle(Request $request, Closure $next) { $request::setTrustedProxies([], $this->getTrustedHeaderNames()); // Reset trusted proxies between requests $this->setTrustedProxyIpAddresses($request); return $next($request); } /** * Sets the trusted proxies on the request to the value of trustedproxy.proxies * * @param \Illuminate\Http\Request $request */ protected function setTrustedProxyIpAddresses(Request $request) { $trustedIps = $this->proxies ?: $this->config->get('trustedproxy.proxies'); // Trust any IP address that calls us // `**` for backwards compatibility, but is deprecated if ($trustedIps === '*' || $trustedIps === '**') { return $this->setTrustedProxyIpAddressesToTheCallingIp($request); } // Support IPs addresses separated by comma $trustedIps = is_string($trustedIps) ? array_map('trim', explode(',', $trustedIps)) : $trustedIps; Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php // the appropriate method and arguments, returning the results back out. return $pipe($passable, $stack); } elseif (! is_object($pipe)) { [$name, $parameters] = $this->parsePipeString($pipe); // If the pipe is a string we will parse the string and resolve the class out // of the dependency injection container. We can then build a callable and // execute the pipe function giving in the parameters that are required. $pipe = $this->getContainer()->make($name); $parameters = array_merge([$passable, $stack], $parameters); } else { // If the pipe is already an object we'll just make a callable and pass it to // the pipe as-is. There is no need to do any extra parsing and formatting // since the object we're given was already a fully instantiated object. $parameters = [$passable, $stack]; } $response = method_exists($pipe, $this->method) ? $pipe->{$this->method}(...$parameters) : $pipe(...$parameters); return $response instanceof Responsable ? $response->toResponse($this->getContainer()->make(Request::class)) : $response; }; }; } /** * Parse full pipe string to get name and parameters. * * @param string $pipe * @return array */ protected function parsePipeString($pipe) { [$name, $parameters] = array_pad(explode(':', $pipe, 2), 2, []); if (is_string($parameters)) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
  2. Closure($passable) {#238 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php return $this->handleException($passable, new FatalThrowableError($e)); } }; } /** * Get a Closure that represents a slice of the application onion. * * @return \Closure */ protected function carry() { return function ($stack, $pipe) { return function ($passable) use ($stack, $pipe) { try { $slice = parent::carry(); $callable = $slice($stack, $pipe); return $callable($passable); } catch (Exception $e) { return $this->handleException($passable, $e); } catch (Throwable $e) { return $this->handleException($passable, new FatalThrowableError($e)); } }; }; } /** * Handle the given exception. * * @param mixed $passable * @param \Exception $e * @return mixed * * @throws \Exception */ protected function handleException($passable, Exception $e) { Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php public function via($method) { $this->method = $method; return $this; } /** * Run the pipeline with a final destination callback. * * @param \Closure $destination * @return mixed */ public function then(Closure $destination) { $pipeline = array_reduce( array_reverse($this->pipes), $this->carry(), $this->prepareDestination($destination) ); return $pipeline($this->passable); } /** * Run the pipeline and return the result. * * @return mixed */ public function thenReturn() { return $this->then(function ($passable) { return $passable; }); } /** * Get the final piece of the Closure onion. * * @param \Closure $destination * @return \Closure */ Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php } /** * Send the given request through the middleware / router. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ protected function sendRequestThroughRouter($request) { $this->app->instance('request', $request); Facade::clearResolvedInstance('request'); $this->bootstrap(); return (new Pipeline($this->app)) ->send($request) ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware) ->then($this->dispatchToRouter()); } /** * Bootstrap the application for HTTP requests. * * @return void */ public function bootstrap() { if (! $this->app->hasBeenBootstrapped()) { $this->app->bootstrapWith($this->bootstrappers()); } } /** * Get the route dispatcher callback. * * @return \Closure */ protected function dispatchToRouter() Arguments
  1. Closure($request) {#44 …4}
/home/www/hoctv/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php $router->middlewareGroup($key, $middleware); } foreach ($this->routeMiddleware as $key => $middleware) { $router->aliasMiddleware($key, $middleware); } } /** * Handle an incoming HTTP request. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function handle($request) { try { $request->enableHttpMethodParameterOverride(); $response = $this->sendRequestThroughRouter($request); } catch (Exception $e) { $this->reportException($e); $response = $this->renderException($request, $e); } catch (Throwable $e) { $this->reportException($e = new FatalThrowableError($e)); $response = $this->renderException($request, $e); } $this->app['events']->dispatch( new Events\RequestHandled($request, $response) ); return $response; } /** * Send the given request through the middleware / router. * Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }
/home/www/hoctv/public_html/public/index.php */ $app = require_once __DIR__.'/../bootstrap/app.php'; /* |-------------------------------------------------------------------------- | Run The Application |-------------------------------------------------------------------------- | | Once we have the application, we can handle the incoming request | through the kernel, and send the associated response back to | the client's browser allowing them to enjoy the creative | and wonderful application we have prepared for them. | */ $kernel = $app->make(Illuminate\Contracts\Http\Kernel::class); $response = $kernel->handle( $request = Illuminate\Http\Request::capture() ); $response->send(); $kernel->terminate($request, $response); Arguments
  1. Illuminate\Http\Request {#43 #json: null #convertedFiles: null #userResolver: Closure($guard = null) {#256 …4} #routeResolver: Closure() {#257 …4} +attributes: Symfony\Component\HttpFoundation\ParameterBag {#45} +request: Symfony\Component\HttpFoundation\ParameterBag {#51} +query: Symfony\Component\HttpFoundation\ParameterBag {#51} +server: Symfony\Component\HttpFoundation\ServerBag {#47} +files: Symfony\Component\HttpFoundation\FileBag {#48} +cookies: Symfony\Component\HttpFoundation\ParameterBag {#46} +headers: Symfony\Component\HttpFoundation\HeaderBag {#49} #content: null #languages: null #charsets: null #encodings: null #acceptableContentTypes: array:1 [ 0 => "*/*" ] #pathInfo: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #requestUri: "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166" #baseUrl: "" #basePath: null #method: "GET" #format: null #session: Illuminate\Session\Store {#343} #locale: null #defaultLocale: "en" -preferredFormat: null -isHostValid: true -isForwardedValid: true basePath: "" format: "html" }

Environment & details:

GET Data empty POST Data empty Files empty Cookies empty Session empty Server/Request Data
Key Value
USER "www-static"
HOME "/home/www-static"
HTTP_ACCEPT_ENCODING "deflate, gzip"
HTTP_ACCEPT "*/*"
HTTP_HOST "hoc.tv"
HTTP_USER_AGENT "Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0"
REDIRECT_STATUS "200"
SERVER_NAME "hoc.tv"
SERVER_PORT "443"
SERVER_ADDR "203.171.20.67"
REMOTE_PORT "56938"
REMOTE_ADDR "103.110.85.167"
SERVER_SOFTWARE "nginx/1.10.3"
GATEWAY_INTERFACE "CGI/1.1"
HTTPS "on"
REQUEST_SCHEME "https"
SERVER_PROTOCOL "HTTP/1.1"
DOCUMENT_ROOT "/home/www/hoctv/public_html/public"
DOCUMENT_URI "/index.php"
REQUEST_URI "/tutorial/cach-su-dung-ham-vlookup-ket-hop-ham-left-trong-excel-1166"
SCRIPT_NAME "/index.php"
CONTENT_LENGTH ""
CONTENT_TYPE ""
REQUEST_METHOD "GET"
QUERY_STRING ""
SCRIPT_FILENAME "/home/www/hoctv/public_html/public/index.php"
FCGI_ROLE "RESPONDER"
PHP_SELF "/index.php"
REQUEST_TIME_FLOAT 1735118609.3378
REQUEST_TIME 1735118609
APP_NAME "Laravel"
APP_ENV "production"
APP_KEY "base64:/TiBQvE9XDvtTbeC84kPYSLTAlFIfBp9aqIsSbezoVw="
APP_DEBUG "true"
APP_URL "http://localhost"
LOG_CHANNEL "stack"
DB_CONNECTION "mysql"
DB_HOST "127.0.0.1"
DB_PORT "3306"
DB_DATABASE "hoctv"
DB_USERNAME "hoctv_root"
DB_PASSWORD "kHgjQeh56RzyEBkr6ZS"
BROADCAST_DRIVER "log"
CACHE_DRIVER "file"
QUEUE_CONNECTION "sync"
SESSION_DRIVER "file"
SESSION_LIFETIME "120"
REDIS_HOST "127.0.0.1"
REDIS_PASSWORD "null"
REDIS_PORT "6379"
MAIL_DRIVER "smtp"
MAIL_HOST "smtp.mailtrap.io"
MAIL_PORT "2525"
MAIL_USERNAME "null"
MAIL_PASSWORD "null"
MAIL_ENCRYPTION "null"
AWS_ACCESS_KEY_ID ""
AWS_SECRET_ACCESS_KEY ""
AWS_DEFAULT_REGION "us-east-1"
AWS_BUCKET ""
PUSHER_APP_ID ""
PUSHER_APP_KEY ""
PUSHER_APP_SECRET ""
PUSHER_APP_CLUSTER "mt1"
MIX_PUSHER_APP_KEY ""
MIX_PUSHER_APP_CLUSTER "mt1"
FTP_URL "https://media.hoc.tv"
FTP_HOST "media.hoc.tv"
FTP_USER "mediahoctv"
FTP_PASS "uwhrgkZWh2zU6"
FTP_ROOT ""
CACHE_TIME "300"
CACHE_HIGHT "600"
FROALA_KEY "XAG4eH3I3C8C7D6B4C-11VKOJ1FGULVKHXDXNDXc1d1Kg1SNdD5B4A4B3H3I3B2B7A4E2=="
R_POST_DETAIL "post"
R_TAG "tag"
R_COLLECT "null"
Environment Variables
Key Value
APP_NAME "Laravel"
APP_ENV "production"
APP_KEY "base64:/TiBQvE9XDvtTbeC84kPYSLTAlFIfBp9aqIsSbezoVw="
APP_DEBUG "true"
APP_URL "http://localhost"
LOG_CHANNEL "stack"
DB_CONNECTION "mysql"
DB_HOST "127.0.0.1"
DB_PORT "3306"
DB_DATABASE "hoctv"
DB_USERNAME "hoctv_root"
DB_PASSWORD "kHgjQeh56RzyEBkr6ZS"
BROADCAST_DRIVER "log"
CACHE_DRIVER "file"
QUEUE_CONNECTION "sync"
SESSION_DRIVER "file"
SESSION_LIFETIME "120"
REDIS_HOST "127.0.0.1"
REDIS_PASSWORD "null"
REDIS_PORT "6379"
MAIL_DRIVER "smtp"
MAIL_HOST "smtp.mailtrap.io"
MAIL_PORT "2525"
MAIL_USERNAME "null"
MAIL_PASSWORD "null"
MAIL_ENCRYPTION "null"
AWS_ACCESS_KEY_ID ""
AWS_SECRET_ACCESS_KEY ""
AWS_DEFAULT_REGION "us-east-1"
AWS_BUCKET ""
PUSHER_APP_ID ""
PUSHER_APP_KEY ""
PUSHER_APP_SECRET ""
PUSHER_APP_CLUSTER "mt1"
MIX_PUSHER_APP_KEY ""
MIX_PUSHER_APP_CLUSTER "mt1"
FTP_URL "https://media.hoc.tv"
FTP_HOST "media.hoc.tv"
FTP_USER "mediahoctv"
FTP_PASS "uwhrgkZWh2zU6"
FTP_ROOT ""
CACHE_TIME "300"
CACHE_HIGHT "600"
FROALA_KEY "XAG4eH3I3C8C7D6B4C-11VKOJ1FGULVKHXDXNDXc1d1Kg1SNdD5B4A4B3H3I3B2B7A4E2=="
R_POST_DETAIL "post"
R_TAG "tag"
R_COLLECT "null"
Registered Handlers 0. Whoops\Handler\PrettyPageHandler

Từ khóa » Cách Sử Dụng Vlookup Và Left