从其他表Laravel5.2显示数据时出错

Question

我有两张桌子。

1. 用户(名称、用户名、电子邮件、密码、remember_token)
2. dosen (iddosen，namedosen，address，phonenumber)

我想在一个视图中显示来自两个表的数据。

我的用户模型：

public function profildosen()
{
    return $this->belongsTo('App\Dosen');
}

多森模型：

public function user()
{
    return $this->hasOne('App\User');
}

意见：

 @foreach($dosen as $key => $value)                 
 <strong>Kode Dosen :</strong> {{ $value->profildosen->iddosen }}<br>
 <strong>Nama  :</strong> {{ $value->profildosen->namedosen}}<br>
 <strong>Alamat :</strong> {{ $value->profildosen->address}}<br>
<strong>No HP :</strong> {{ $value->phonenumber}} <br>
 <strong>Email :</strong> {{ $value->email }}<br>
 @endforeach

方法：

 $dosen = User::paginate(5);
 return view('admin/dosen.index', compact('dosen'));

得到了错误：

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dosen.id' in 'where       clause' (SQL: select * from `dosen` where `dosen`.`id` is null limit 1) (View: D:\XAMPP\htdocs\infodosenku\resources\views\admin\dosen\index.blade.php)

正确的方法是什么？

更新

方案数据库

Schema::create('users', function (Blueprint $table) {
        $table->increments('id');
        $table->string('name');
        $table->string('username');
        $table->string('email')->unique();
        $table->string('password', 60);
        $table->boolean('admin')->default(0);
        $table->rememberToken();
        $table->timestamps();
    });

Schema::create('dosen', function (Blueprint $table) {
        $table->string('id');
        $table->string('user_id');
        $table->string('nipy');
        $table->string('namadosen');
        $table->string('alamatdosen');
        $table->integer('notelpdosen');
        $table->timestamps();
    });

路线：

Route::resource('/admin/dosen', 'AdminController',
            ['except' => ['show']]);

主计长：

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Request;
use App\Http\Requests;
use App\Http\Requests\CreateDosenRequest;
use App\Dosen;
use App\User;
use Illuminate\Support\Facades\Input;
use DB;

class AdminController extends Controller
{
public function index()
{
     // ambil semua data dosen
    $dosen = User::paginate(5);
    return view('admin/dosen.index', compact('dosen'));

}

public function create()
{
    return view('admin/dosen.create');
}

public function store(CreateDosenRequest $request)
{
    $user = User::create([
        'name' => $request->input('name'),
        'username' => $request->input('username'),
        'email' => $request->input('email'),
        'password' => bcrypt($request->input['password']),
        'admin' => $request->input('admin')
    ]);




      $dosen = Dosen::create([
        'id' => $request->input('iddosen'),
        'nipy' => $request->input('nipy'),
        'namadosen' => $user->name,
        'user_id' => $user->id,
        'alamatdosen' => $request->input('alamatdosen'),
        'notelpdosen' => $request->input('notelpdosen'),
    ]);


    return redirect('admin/dosen')->with('message', 'Data berhasil ditambahkan!');              
}

public function show($id)
{
    $dosen = User::find($id);
    return view('admin/dosen/show', compact('dosen'));
}

public function edit($id)
{
    $dosen = User::find($id);

    return view('admin.dosen.edit', compact('dosen'));
}

public function update($id)
{
    $dosenUpdate = Request::all();
    $dosen = User::find($id);
    $dosen->update($dosenUpdate);
    return redirect('admin.dosen')->with('message', 'Data berhasil diubah!');
}

public function destroy($id)
{       
    User::find($id)->delete();
    return redirect('admin.dosen')->with('message', 'Data berhasil dihapus!');
}   
}

我的观点是：

@extends('layouts.app')
@section('content')
<div class="container">
    <div class="row">
       <div class="col-md-10 col-md-offset-1">
        <div class="panel panel-default">
            <div class="panel-heading">Daftar Dosen</div>
                <div class="panel-body">
                <form class ="form-inline" action="{{ URL('/dosen/hasil/') }}" action="GET">
                        <div class="form-group">
                            <label for="cari">Cari Dosen </label>
                            <input type="text" class="form-control" id="cari" name="cari" placeholder="Masukan Nama Dosen">
                        </div>
                            <input class="btn btn-primary" type="submit" value="Cari">

                    </form><br>
                  <table class="table table-striped table-bordered">
                            <thead>
                                <tr>

                                    <td>Nama</td>
                                    <td>username</td>

                                    <td>Actions</td>
                                </tr>
                            </thead>
                        <tbody>
            @foreach($dosen as $key => $value)
                    <tr>

                        <td>{{ $value->name }}</td>
                        <td>{{ $value->username}}</td>


                         <td>
                            {!! Form::open(['url' => 'dosen/' . $value->id . '/edit', 'style'=>'display:inline-block']) !!}
                            {!! Form::hidden('_method', 'GET') !!}
                            {{ Form::button('<i class="fa fa-pencil-square-o"></i>', ['type' => 'submit', 'class' => 'btn btn-warning', 'title' => 'Ubah'] )  }}
                            {!! Form::close() !!}

                          <button title="Tampilkan" type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal-{{ $value->id }}"><i class="fa fa-share"></i></button>

                          <!-- Modal -->
                          <div class="modal fade" id="myModal-{{ $value->id }}" role="dialog">
                            <div class="modal-dialog modal-sm">
                              <div class="modal-content">
                                <div class="modal-header">
                                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                                  <h4 class="modal-title">{{ $value->namadosen }}</h4>
                                </div>
                                <div class="modal-body" style="overflow:auto;">             
                                        <strong>Kode Dosen :</strong> {{ $value->dosen->id }}<br>
                                         <strong>NIP/NIPY :</strong> {{ $value->nipy }}<br>
                                         <strong>Nama  :</strong> {{ $value->namadosen }}<br>
                                         <strong>Alamat :</strong> {{ $value->alamatdosen }}<br>
                                         <strong>No HP :</strong> {{ $value->notelpdosen }} <br>

                                </div>
                                <div class="modal-footer">
                                  <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                                </div>
                              </div>
                            </div>
                          </div>
                            {!! Form::open(['url' => 'dosen/' . $value->id, 'style'=>'display:inline-block']) !!}
                            {!! Form::hidden('_method', 'DELETE') !!}
                            {{ Form::button('<i class="fa fa-trash"></i>', ['type' => 'submit', 'class' => 'btn btn-danger', 'title' => 'Hapus'] )  }}
                            {!! Form::close() !!}
                             {!! Form::model($value, ['route' => ['admin.dosen.update', $value->id], 'method' => 'PUT']) !!}
                        </td>
                    </tr>
            @endforeach
                    </tbody>
                </table>
                 <h5><span class="label label-default">
                Showing {!! $dosen->count() !!} results from total {!! $dosen->total() !!} results.
                </span></h5>
            <div> {!! $dosen->links() !!} </div>
         </div>
      </div>
    </div>
  </div>
</div>
@endsection

多森模型：

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Dosen extends Model
{
 protected $table = 'dosen';

protected $fillable = ['iddosen', 'namadosen', 'user_id', 'nipy', 'kodeprogdidosen','alamatdosen', 'notelpdosen', 'tempatlahirdosen', 'tanggallahirdosen', 'agamadosen', 'emaildosen', 'sandidosen', 'jkldosen', 'fotodosen'];

protected $casts = [
'iddosen' => 'varchar',
];

public function dosen()
{
     return $this->belongsTo('App\Dosen');
}
}

用户模型：

<?php
 namespace App;
 use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
protected $fillable = [
    'name', 'username', 'email', 'password', 'admin',
];

/**
 * The attributes excluded from the model's JSON form.
 *
 * @var array
 */
protected $hidden = [
    'password', 'remember_token',
];

 public function profildosen()
{
    return $this->belongsTo('App\Dosen');
}
}

Answer 1

来自Laravel博士

雄辩者通过检查关系方法的名称并用_id后缀该方法名来确定默认的外键名称。

您的函数名为profiledosen，因此Laravel将假设在您的Dosen表中，您的主要标识符是id字段。

您只可以将它从iddosen更改为id，然后将方法名更改为

public function dosen()
{
    return $this->belongsTo('App\Dosen');
}

或者，您可以向您的方法提供自定义主键，如

public function profildosen()
{
    return $this->belongsTo('App\Dosen', 'iddosen');
}

Answer 2

原因是您错误地标识了您的表id a so而不是dosen.id，您应该使用dosen.iddosen。

因此，查询应该如下所示：select * from dosen where iddosen is null limit 1

或者您可以使用Laravel 更多。

但最重要的是，您需要知道要加入哪些列。

希望它能帮上忙