Laravel 捕捉 Eloquent “独特"字段错误

Laravel catch Eloquent quot;Uniquequot; field error(Laravel 捕捉 Eloquent “独特字段错误)
本文介绍了Laravel 捕捉 Eloquent “独特"字段错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试识别在 Laravel 中使用 eloquent 插入记录时由于唯一字段错误而引发异常时.

I am trying to identify when inserting a record using eloquent in Laravel when it throws an exception because of a unique field error.

我目前的代码是:

try {

    $result = Emailreminder::create(array(
                       'user_id' => Auth::user()->id,
                       'email' => $newEmail,
                       'token' => $token,
              ));

} catch (IlluminateDatabaseQueryException $e) {
    return $e;
}

它抛出一个异常好吧我只是不知道该怎么做才能将其识别为列重复错误?

It throws an exception OK I just don't know what to do to identify it as a column duplicate error?

谢谢,

加文.

推荐答案

我假设你使用 MySQL,其他系统可能不同

好的,首先,重复的错误代码条目是 1062.以下是您从异常中检索错误代码的方法:

Okay first, the error code for duplicate entry is 1062. And here's how you retrieve the error code from the exception:

catch (IlluminateDatabaseQueryException $e){
    $errorCode = $e->errorInfo[1];
    if($errorCode == 1062){
        // houston, we have a duplicate entry problem
    }
}

这篇关于Laravel 捕捉 Eloquent “独特"字段错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Convert JSON integers and floats to strings(将JSON整数和浮点数转换为字符串)
in php how do I use preg replace to turn a url into a tinyurl(在php中,如何使用preg替换将URL转换为TinyURL)
all day appointment for ics calendar file wont work(ICS日历文件的全天约会不起作用)
trim function is giving unexpected values php(Trim函数提供了意外的值php)
Basic PDO connection to MySQL(到MySQL的基本PDO连接)
PHP number_format returns 1.00(Php number_Format返回1.00)