Obtaining data from a different table which has a different controller, model and route

Question

I currently have 2 different tables(article and cost), controllers, models and routes. I am currently in a view of the cost but I want to access a column from the article database, how do I do so? The page is displaying undefined variable: article error.

Currently in view page of cost table, this results in an error

value="{{ $article->articlecost }}"

Web.php

Route::resource('articles', ArticleController::class);
Route::resource('costs', CostController::class);

CostController

use App\Models\Cost;
use App\Models\Article;

class SalaryController extends Controller
{
    public function create()
    {
        $articles = Article::all();
        return view('costs.create');
    }
}

First: `$article->articlecost` Gives an error, correct? Then in your controller, `dd($article->articlecost);`, see what it gives you and update your original question. Then... check all the questions above here ^^^ and try to answer them, update your original question with those answers. I like your answer here: `I dont think I've made any `, so try to look in your models and maybe update that answer in your original question — UnderDog, Dec 20 '22 at 03:40

score -1 · Answer 1 · answered Dec 20 '22 at 02:55

-1

You should pass the article to the view if you want to use it.

use App\Models\Cost;
use App\Models\Article;

class SalaryController extends Controller
{
    public function create()
    {
        $articles = Article::latest()->paginate(5);
        return view('costs.create', compact('articles'));
        
        // or
        // return view('costs.create', [
        //     'articles' => $articles 
        // ]);
    }
}

answered Dec 20 '22 at 02:55

xenooooo

1,106
1
2
8

Every time you think you want to post an answer to a new question, the first thing you should do is take 5 or 10 minutes to search Stack Overflow (via Google search) and hunt aggressively for duplicate pages that already exist. If you find a duplicate that resolves the new question, please vote to close the new question. If you have something unique and valuable to add to the older page, please post your advice there. By ignoring pre-existing content, researchers have a harder time finding and comparing relevant insights on a given topic. – steven7mwesigwa Dec 20 '22 at 02:56

Obtaining data from a different table which has a different controller, model and route

1 Answers1