我知道如何使用单个id检查唯一性,如以下
$addrules = array(
'GradeName' => array('required','regex:/^./','unique:class,GradeName,'.$id.',AutoID'),
);
然后我想使用来检查唯一的两个id(主密钥和外键)
这是我的代码:
$update = array(
'GradeName' => array('required','regex:/^./','unique:class,GradeName,'.$schoolid.',schoolid,'.$data.',AutoID'),
);
但我有以下错误:
SQLSTATE[42S22]: Column not found: 1054 Unknown column '20' in 'where clause' (SQL: select count(*) as aggregate from `class` where `GradeName` = g1 and `schoolid` <> 3 and `20` = AutoID)
我该如何解决这个问题?
我已经使用以下代码修复了这个错误
$update = array(
'GradeName' => array('required','regex:/^./','unique:class,GradeName,'.$data.',AutoID,schoolid,'.$schoolid),
);
您传递了错误的参数,随后是文档
unique:table,column,except,idColumn
You may also specify more conditions that will be added as "where" clauses to the query:
'email' => 'unique:users,email_address,NULL,id,account_id,1'
In the rule above, only rows with an account_id of 1 would be included in the unique check.
所以,你可以把foregein键传给你。