Showing mysql error for DB class in laravel

Question

this example code that works with database:

    $status = DB::table('post')->where('id', 2)->update([
        'title' => 'new title',
        'content' => 'new content'
    ]);

think $status = false means there was an problem in updating action. How can I show mysql error for DB class ?

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

Use Laravel's QueryException:

use Illuminate\Database\QueryException;

try {
    $status = DB::table('post')->where('id', 2)->update([
        'title' => 'new title',
        'content' => 'new content'
    ]);
} catch (QueryException $e) {
   //var_dump($e->getMessage())
   \Log::error('QueryException: ' . $e->getMessage())   
}

UPDATE: Why laravel throw QueryException when something wrong happened with SQL executing. See this Logic in laravel's source code.

Class: \Illuminate\Database\Connection

/**
 * Run a SQL statement and log its execution context.
 *
 * @param  string    $query
 * @param  array     $bindings
 * @param  \Closure  $callback
 * @return mixed
 *
 * @throws \Illuminate\Database\QueryException
 */
protected function run($query, $bindings, Closure $callback)
{
    $this->reconnectIfMissingConnection();

    $start = microtime(true);
    try {
        $result = $this->runQueryCallback($query, $bindings, $callback);
    } catch (QueryException $e) {
        $result = $this->handleQueryException(
            $e, $query, $bindings, $callback
        );
    }
    ......
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 6, 2018 at 6:02

Kevin Yan

1,23411 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Alexey Mezenin Over a year ago

OP says $status = false, so the query was executed.

Alexey Mezenin Over a year ago

Mahdi, please explain how exactly this helped you and why did you have an exception.

Alexey Mezenin Over a year ago

Kevin, the question was addressed to Mahdi. He said that $status = false.

Kevin Yan Over a year ago

Oh I see, I misunderstood .

Collectives™ on Stack Overflow

Showing mysql error for DB class in laravel

1 Answer 1

Class: \Illuminate\Database\Connection

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Class: \Illuminate\Database\Connection

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related