Get data from pivot table in view laravel

Viewed 2420

I have a problem with data of relationship many to many, first i will put my models and controllers, i use laravel 5.3

Model Lists Addresses

class ListsAddresses extends Model
{
protected $table = "addresses";

protected $fillable = ['state', 'city', 'street_number', 'neighborhood', 'cp'];

public function lists()
{
    return $this->belongsToMany('App\Admin\Models\Lists', 'list_has_addresses' , 'address_id', 'list_id');
}

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

public $timestamps = false;
}

Controller Lists Addresses

public function form_edit_address( $id_list, $id_address ){

        $list = Lists::find( $id_list );

        $address = ListsAddresses::find( $id_address );

        return view( "admin.forms.form_edit_address" )
                    ->with( 'list', $list )
                    ->with( 'address', $address );

    }

View of Form

<div class="col-md-6" style="padding-right: 0">
          <div class="form-group">
            <label for="order">Orden*</label>
            <input type="order" class="form-control" id="order" name="order" value="{{ $address->order }}" required>
          </div><!-- /.form-group -->
        </div><!-- /.col -->

My table pivot of database have the next structure

id - title - order - list_id - address_id

How I can get the value of order corresponding to the address in pivot table in my view?

EDDIT

This is the way i save the order in when i create new address

if( $address->save() ){

                $address_data = array();

                $address_title = htmlspecialchars( $request->input( "state" ).' '.$request->input( "city" ).' '.$request->input( "street" ).' '.$request->input( "neighborhood" ).' '.$request->input( "cp" ) );

                $address_order = $request->input( "order" );

                $address_data[ $address->id ] = array( 'title' => $address_title, 'order' => $address_order );

                $list->addresses()->attach( $address_data );
     }
1 Answers
Related