How to add and update a column in database table?

Dming9999

Hi @Saurabh @[deleted],

I have added two columns
in the Orders table in the database.
I'm looking to add a script in the fixUpdateIssues function in the AdminController to update the user_email and user__phone columns.

But I'm getting this error and these are the code I'm using.

Is there any better way to achieve this?

`            $orders = Order::all();
            foreach ($orders as $order){
                $userId = $order->user_id;
                $userEmail = User::where('id', $userId)->first()->email;

                DB::table('orders')->whereIn('id',$userId)->update(['user_email' => $userEmail]);
                }`

Saurabh

Dming9999 paste your code before the try statement in fixupdateissues function and then run the code.

"serialization of closure is not allowed" this occurs when the error cannot be handled by the catch statement, so assuming something is going wrong with your code. So if you write it befor the try statement, it should give the detailed error message if something is wrong.

Dming9999

Saurabh

getting this error when I paste the code before the try statement.

Symfony \ Component \ Debug \ Exception \ FatalThrowableError (E_RECOVERABLE_ERROR)
Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type array, int given, called in C:\xampp\htdocs\foodomaa_3_3\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php on line 870

Saurabh

This is incorrect:
DB::table('orders')->whereIn('id',$userId)->update(['user_email' => $userEmail]);

This is correct:
DB::table('orders')->where('id',$userId)->update(['user_email' => $userEmail]);

(changed whereIn to where)
whereIn takes array as the second argument, where takes a single int/string.

Dming9999

Saurabh
Thanks, It works, but it seems some of the rows are randomly missed out.
and the email is not matching to the right field, am I doing my for each loop right?

Dming9999

Got it, it was used the user ID as the order ID by mistake 😅 ,

Thank You very much @Saurabh