How does larval catch mysql errors

How larval catches mysql errors: 1. Use the errorInfo variable to return SQLSTATE errors and messages; 2. Use the exception handler “app/Exceptions/Handler.php and listen to QueryExceptions” to log all SQL errors to the data . Recommendation: “Mysql Video Tutorial” Laravel uses PDO, so you can use the errorInfo variable to return SQLSTATE errors and messages. Basically, you need to use $e->errorInfo; If you want to log all SQL errors to the database, you can use an exception handler (app/Exceptions/Handler.php and listen for QueryExceptions. Like this The: public function render($request, Exception $e) { switch ($e) { case ($e instanceof \Illuminate\Database\QueryException): LogTracker::saveSqlError($e); break; default: LogTracker::saveError($e, $e->getCode()); } return parent::render($request, $e); } Then you can use something like this: public function saveSqlError($exception) { $sql = $exception->getSql(); $bindings = $exception->getBindings() // Process the query’s SQL and parameters and create the exact query foreach ($bindings as $i => $binding) { if ($binding instanceof \DateTime) { $bindings[$i] = $binding->format('\'Y-m-d H:i:s\''); } else { if (is_string($binding)) { $bindings[$i] = “'$binding'”; } } } $query = str_replace(array('%', '?'), array('%%', '%s' ), $sql); $query = vsprintf($query, $bindings); // Here’s the part you need $errorInfo = $exception->errorInfo; $data = [ ‘sql’ => $query, 'message' => isset($errorInfo[2]) ? $errorInfo[2] : '',…