mysql - Laravel 验证器转义数据库名称

Question

我有一个带有“.”的表格登录它的名字，它叫做“database.com”。我正在使用验证器来验证我网站上注册时的输入。这是 laravel 代码

$validator = Validator::make($params,
            array(
                "username" => "required|unique:database.com.users,name",
                "email" => "required|email|unique:database.com.users,mail",
                'password' => 'required|min:6',
                'password-confirmation' => 'required|same:password'
            )
        );

这会产生一个 laravel 错误

{"error":{"type":"Illuminate\\Database\\QueryException","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`users` where `name` = ?' at line 1 (SQL: select count(*) as aggregate from `'database`.`com'`.`users` where `name` = dfgdf)","file":"C:\\wamp\\www\\mobile\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php","line":555}}

我认为问题在于“.”登录数据库名称，但如果我这样输入数据库名称，我无法正确转义

"username" => "required|unique:'database.com'.users,name",

验证无效。

Answer 1

我不确定 Laravel 独特的验证规则是否支持该语法。您始终可以轻松创建自己的自定义规则(谢谢 Taylor!) Laravel custom validation rules