在Laravel 8中存储数据并同时更新不同表上的数据

// User.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $table = 'users';

    public function orders()
    {
        return $this->hasMany(Order::class);
    }
}

// Order.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Order extends Model
{
    protected $table = 'orders';

    public function user()
    {
        return $this->belongsTo(User::class);
    }
}

// UserController.php
namespace App\Http\Controllers;

use App\Models\User;
use App\Models\Order;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    public function store(Request $request)
    {
        // 开启事务
        DB::beginTransaction();

        try {
            // 创建用户
            $user = new User;
            $user->name = $request->input('name');
            $user->email = $request->input('email');
            $user->save();

            // 创建订单
            $order = new Order;
            $order->user_id = $user->id;
            $order->amount = $request->input('amount');
            $order->save();

            // 提交事务
            DB::commit();

            return response()->json(['message' => 'Data stored successfully']);
        } catch (\Exception $e) {
            // 回滚事务
            DB::rollback();

            return response()->json(['message' => 'Failed to store data']);
        }
    }
}