时间戳

首页 > 解决方案 > 如何连接两个表并从 Laravel 的第一个表中获取 id

laravel - 如何连接两个表并从 Laravel 的第一个表中获取 id

问题描述

我正在尝试加入表格posts并tags获取表格的 ID posts，但是这段代码给了我tags表格的 ID（11），但帖子 ID 是 15。

结果

$posts = Post::leftJoin('tags', 'tags.post_id', '=', 'posts.id')
                ->where('tags.slug', $slug)->get();

 dd($posts);

表格标签

Schema::create('tags', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->unsignedBigInteger('post_id');
    $table->string('tag');
    $table->string('slug');
    $table->integer('views')->nullable();
    $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
});

表帖

Schema::create('posts', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->unsignedBigInteger('category_id');
    $table->unsignedBigInteger('admin_id')->nullable();
    $table->string('title');
    $table->string('slug')->unique();
    $table->integer('views')->default(0);
    $table->longText('content');
    $table->text('meta_keywords')->nullable();
    $table->text('meta_description')->nullable();
    $table->enum('is_home', ['0', '1',])->default('1');
    $table->enum('is_featured', ['0', '1',])->default('0');
    $table->enum('is_slider', ['0', '1',])->default('0');
    $table->integer('slider_order')->default(0);
    $table->enum('type', ['Article', 'Video']);
    $table->enum('status', ['Visible', 'Invisible', 'Draft', 'Pending']);
    $table->foreign('category_id')->references('id')->on('categories');
    $table->foreign('admin_id')->references('id')->on('admins');
    $table->timestamps();
});

型号标签

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model
{
    protected $fillable = [
        'post_id', 'tag', 'slug',
    ];

    public $timestamps = false;
}

模特帖子

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    public function tags()
    {
        return $this->hasMany(Tag::class);
    }
}

标签： laravel

解决方案

尝试

 $posts = Post::leftJoin('tags', 'tags.post_id', '=', 'posts.id')
           ->select('tags.id as tag_id','posts.*')
           ->where('tags.slug','=', $slug)
           ->get();

现在$posts->id将上桌id。将是表。posts$posts->tag_ididtags

推荐阅读