footer query data from db show in master.blade laravel 5.4

Question

I need to query information form database [company name ,company address] and my code can show 1 page

my controller

public function index()
{
    $footer = DB::table('pjt_setting')->pluck('value','setting_name')->toArray();
    //dd($footer);
    return view('frontend.index',compact('footer'));
}

Master blade

<!-- topbar -->
@include('frontend.layouts.topbar')
<!-- top -->
@include('frontend.layouts.nav')
<!-- header slide -->
<!-- Main content -->
    @yield('content')
<!-- /.content -->
<footer class="footer-distributed">
    @include('frontend.layouts.footer')
</footer>

Footer blade

<div class="row">
<div class="col-md-6">
    <div class="footer-left">
        <h3>{{ $footer["companyname"]}}</h3>
        <p class="footer-company-name">Phuket Jet Tour &copy; 2018</p>
    </div>
</div>
<div class="footer-center"></div>
<div class="col-md-6">
    <div class="footer-right">
        <div class="companyaddress">
            <i class="fa fa-map-marker"></i>
            <p>{{ $footer["companyaddress"] }}</p>
        </div>
        <div>
            <i class="fa fa-phone"></i>
            <p>{{ $footer["phone"] }}</p>
        </div>
        <div>
            <i class="fa fa-envelope"></i>
            <p><a href="mailto:{{ $footer["email"] }}">{{ $footer["email"] }}</a></p>
        </div>
    </div>
</div>

Index page no problem but, I link to contact page show error "Undefined variable:footer". How I can edit

public function index() { return view('frontend.contact-us'); } — story ks, Apr 02 '18 at 10:58

Sohel0415 · Accepted Answer · 2018-04-02T11:02:22.387

1

Pass $footer in your contact view:

$footer = DB::table('pjt_setting')->pluck('value','setting_name')->toArray();
return view('frontend.contact-us',compact('footer'));

Best way would be to share this footer from base controller for every view

class BaseController extends \Controller
{

   protected $footer;

   public function __construct() 
   {
       $this->footer = DB::table('pjt_setting')->pluck('value','setting_name')->toArray();
       View::share('footer', $footer);
   }

}

edited Apr 02 '18 at 11:02

answered Apr 02 '18 at 10:59

Sohel0415

9,523
21
30

thank you so much , i don't know trait you have document online ? – story ks Apr 02 '18 at 11:07
trait won't help here but you can see its official doc – Sohel0415 Apr 02 '18 at 11:50

score 1 · Answer 2 · answered Apr 02 '18 at 11:03

1

You can do this as said by @Sohel0415

Or you can do this using Trait.

answered Apr 02 '18 at 11:03

Nirali

1,776
2
12
23

you mean https://laravel.com/docs/5.6/notifications#using-the-notifiable-trait right? – story ks Apr 02 '18 at 11:05
No, using php trait functionality – Nirali Apr 02 '18 at 11:07
Check - https://stackoverflow.com/questions/36657629/how-to-use-traits-laravel-5-2 and http://php.net/manual/en/language.oop5.traits.php – Nirali Apr 02 '18 at 11:09

footer query data from db show in master.blade laravel 5.4

2 Answers2