Update row of database on laravel

Then you can set in your orderdatabase migration payment as like below

    $table->integer('payment')->default(1);

and in your user Model use as like below then you can use user_order_id as foreign key

protected $primaryKey = 'user_id';

Are you sure that you are entering the if statement?

if($order->user_order_id == $order->inventory->user_id){
dd('hey');
DB::table('orders')->update(array('payment' => 1));
} 

If you are entering the if status but is not updating maybe you have the mysql server safe update mode, if you don't want to disable it, you can try something like this:

DB::table('orders')->where('id', 'id')->update(['payment' => 1]);

@munazzil I already set that up. I was planning to change all column payment to 1 if the user order and inventory is the same.

There must be a query with a join between orders and inventories (or whatever the table name is), then you would add a where like this ->where('orders.user_order_id', '=', DB::raw('inventories.user_id')) and then call ->delete()