dimanche 16 juin 2019

Can't retrive data from join table

i have some table call guru and siswa they are joined in show method but when it show error on show.blade

this my show method

 public function show($id)
{
    $data = DB::table('siswas')
    ->join('gurus','gurus.id','=','siswas.kelas')
    ->select('siswas.id','siswas.nama','gurus.guruKelas','siswas.status'
    ,'siswas.fotoSiswa','siswas.alamat','siswas.noTelp','siswas.tempatLahir'
    ,'siswas.tanggalLahir','siswas.namaBapak','siswas.namaIbu')
    ->where("siswas.id",$id)
    ->get();
    return view ('siswa.show')->with('siswa',$data);
}

and this is my show.blade

<div class="row">
                    <div class="col-md-4 col-sm-4">
                        <img class="img-circle" style="width: 100%" src="/storage/fotoSiswa/">
                    </div>
                    <div class="col-sm">
                        <h3>Nama : </h3>
                        <p>Kelas : </p>
                        <p>alamat : </p>
                        <p>Nomor Telfon : </p>
                        <p>Tempat Tanggal Lahir :  , </p>
                        <p>Nama Orang Tua</p>
                        <p>Bapak : </p>
                        <p>Ibu : </p>
                    </div>

this the error what im talking about error report



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire