我有一個名為地址的表，它有一個列名user_ids，它是具有相同地址的用戶的陣列。當我請求/api/addresses它回傳的是{id:1,name:"lorem", user_ids:[1,2]}。我希望它回傳用戶而不是他們的 ID

這是地址模型

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Address extends Model
{
    use HasFactory;

    protected $fillable = [
        'coordinates',
        'title',
        'description',
        'user_ids',
    ];



    protected $appends = ['user_ids'];

    protected $casts = [
        'user_ids' => 'array',
    ];
    
    public function users()
    {
        return $this->belongsToMany(User::class,"addresses");
    }

}

這是 create_table_addresses

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('addresses', function (Blueprint $table) {
            $table->id();
            $table->string('coordinates');
            $table->string('title');
            $table->string('description');
            $table->json("user_ids");
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('addresses');
    }
};

地址控制器

<?php

namespace App\Http\Controllers;

use App\Http\Requests\StoreAddressRequest;
use App\Http\Requests\UpdateAddressRequest;
use App\Models\Address;

class AddressController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return Address::with('users')->get();
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //

    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \App\Http\Requests\StoreAddressRequest  $request
     * @return \Illuminate\Http\Response
     */
    public function store(StoreAddressRequest $request)
    {
        $address = Address::create($request->validated());

        return response()->json($address, 201);

    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Address  $address
     * @return \Illuminate\Http\Response
     */
    public function show(Address $address)
    {
        return $address;
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Address  $address
     * @return \Illuminate\Http\Response
     */
    public function edit(Address $address)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \App\Http\Requests\UpdateAddressRequest  $request
     * @param  \App\Models\Address  $address
     * @return \Illuminate\Http\Response
     */
    public function update(UpdateAddressRequest $request, Address $address)
    {
        $address->update($request->validated());
        return response()->json($address, 200);
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Address  $address
     * @return \Illuminate\Http\Response
     */
    public function destroy(Address $address)
    {
        $address->delete();
        return response()->json(null, 204);
    }
}

uj5u.com熱心網友回復：

我的建議是為此使用資料庫（因為您已經在使用with('addresses')）。

（該關系的檔案從這里開始）

移民：

Schema::create('address_user', function (Blueprint $table) {
    $table->integer('user_id')->unsigned()->index();
    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
    $table->integer('address_id')->unsigned()->index();
    $table->foreign('address_id')->references('id')->on('addresses')->onDelete('cascade');
    $table->primary(['user_id', 'address_id']);
});

用戶模型：

use App\Models\User;

class Address extends Model {

    public function users() {
        return $this->belongsToMany(User::class);
    }

}

地址模型：

use App\Models\Address;

class User extends Model {

    public function addresses() {
        return $this->belongsToMany(Address::class);
    }
}

現在您可以使用您的應用程式的關系：

$address->users  // Get all the users with that address
$user->addresses // Get all the addresses for the user

Address::with('users')  // Get addresses with the users as an attribute
User::with('addresses') // Get users with the Address as an attribute

uj5u.com熱心網友回復：

我假設回應來自控制器，那么在構建回應的地方，您需要附加用戶資訊。

也許像

User::whereIn('id', [1,2])->get() ...

如果您發布控制器，那么我可以準確地告訴您將它放在哪里或如何做得更好。

標籤：PHP数据库拉维数据库

上一篇：僅選擇列laravel9中的專案

下一篇：如何使用Laravel從外部API獲取資料到資料表