mercredi 23 mai 2018

In laravel how to get the join table data in same array without where condition

I have created both employes and employes_detail tabel with the data

i have created model for both of the table that is given below:

emloye model:

<?php

namespace App\Http\Model;

use Illuminate\Database\Eloquent\Model;
use App\Http\Model\EmployeDetail;
class Employe extends Model
{
    public function employes_detail()
    {
        return $this->hasOne(EmployeDetail::class);
    }
}

and eployedetail model:

<?php

namespace App\Http\Model;

use Illuminate\Database\Eloquent\Model;

class EmployeDetail extends Model
{
   public function employe()
    {
        public function employe()
    {
        return $this->belongsTo(Employe::class);
    }
    }
}

and in controller i used like :

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use App\Http\Model\Employe;
use App\Http\Model\EmployeDetail;
class EmployeController extends Controller
{
    public function index(Request $request)
    {
        $Employe=Employe::all();
        $convert=$Employe->toArray();
        echo "<pre>";print_r($convert);exit;
        //return view('employe.employe');
    }
}

it showing only employe table data how can i show the data for the employes_detail as well as .still i am not able to understand it on laravel documentation can anyone please help me related this. how can i get the all data from employes and employes_details table for all the records

but when i used this code in controller:

public function index(Request $request)
    {
        $Employe=Employe::where('id',1)->first();
        //$convert=$Employe->toArray();
        echo "<pre>";print_r($Employe->employes_detail);exit;
        //return view('employe.employe');
    }

its shows me the employe_detail table data but i want both of the table data in a same array and i dont want to use where condition here.



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2KO72DQ
via IFTTT

Aucun commentaire:

Enregistrer un commentaire