dongqiuge5435 2016-12-15 05:25
浏览 7

Laravel现有验证

I want to validate the input if the client_id in inserting is existing from the other table

Table where client_id is selected if existing

Schema::create('cluster_members', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('cluster_id')->unsigned()->nullable();
            $table->integer('client_id')->unsigned()->nullable();
            $table->softDeletes();
            $table->timestamps();

});

Table where i will insert the record if passed the validation

Schema::create('loan_applications', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('client_id')->unsigned()->index();
            $table->integer('product_id')->unsigned()->index();


});

So in my Controller

Here is my rule

$rule = ['client_id'=>'required | numeric | exists:clients,id | exists:cluster_members,client_id'];

And this throws me this error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id ' in 'where clause'

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)
    • ¥15 keil里为什么main.c定义的函数在it.c调用不了
    • ¥50 切换TabTip键盘的输入法