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独特的验证规则是否支持这种语法。您总是可以轻松地创建自己的自定义规则(谢谢泰勒！) Laravel custom validation rules