Hilfe bei Laravel

DarkEvolution · 23. März 2017

Hallo Breadfish Benutzer,
ich hab eine frage ich will ein News System erstellen in Laravel.
da hab nun ein Problem, wenn die die daten von der datenbank abrufe habe ich eine author_id,
will daraus eine authorname also Benutzername der dieses erstellt hat haben.

Kurze Info:
Ich benutze Laravel 5.4

Meine Daten:

User.php:

PHP: User.php

<?php


namespace App;


use Illuminate\Auth\Notifications\ResetPassword;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;


class User extends Authenticatable
{
    use Notifiable;


    protected $table = 'users';


    protected $fillable = ['name', 'email', 'password'];


    protected $hidden = ['password', 'remember_token'];


    protected $dates = ['logged_in_at' , 'logged_out_at'];




    public function sendPasswordResetNotification($token)
    {
        $this->notify(new ResetPassword($token));
    }


    public function news(){
        return $this->hasMany('App\News');
    }


}

Alles anzeigen

News.php:

PHP: News.php

<?php


namespace App;


use Illuminate\Database\Eloquent\Model;


class News extends Model
{
    protected $table = 'news';


    protected $fillable = ['author_id', 'title', 'slug', 'body', 'excerpt', 'published_at'];


    protected $dates = ['published_at'];




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




}

Alles anzeigen

NewsController.php:

PHP: NewsController.php

namespace App\Http\Controllers;


use App\News;
use App\User;


class NewsController extends Controller
{


    protected $news;


    public function __construct( News $news)
    {
        $this->news = $news;
    }


    public function show(){
        $news = News::all();
        return view('news.show',compact('news'));
    }
}

Alles anzeigen

show.blade.php:

PHP: show.blade.php

@extends('layouts.app')
@section('content')
    @foreach($news as $p)
    <blockquote>
        <div>{{$p->title}}</div>
        <div>{{$p->desc}}</div>
        <div>
<a href="{{ url('profile/'.$p->author_id) }}">{{$p->name}}</a>
</div>
    </blockquote>
    @endforeach
@endsection

Alles anzeigen

Bitte um schnelle hilfe.

Mit Freundlichen Grüßen,
DarkEvolution

Developer · 23. März 2017

1. Klassen immer in ::class Syntax schreiben
z.B.

PHP

<?php
$this->belongsTo(App\User::class);

In der View kannst du dann via darauf zugreifen

PHP

<?php 
$p->user->name

Dann 2. deine Übergabe im NewsController Konstruktor ist an der stelle unnötig (du greifst ja nicht drauf zu sondern holst dir nochmal speziell alle Daten per News::all();)

DarkEvolution · 23. März 2017

Dies funktioniert nicht.
Da kommt immer dieser fehler:

Code

ErrorException thrown with message "Trying to get property of non-object (View: C:\Dev\PHP\YES_NewEra\resources\views\news\show.blade.php)"


Stacktrace:
#53 ErrorException in C:\Dev\PHP\YES_NewEra\storage\framework\views\bd2e5d612fd59236bdde19249252e5d4352530df.php:6
#52 ErrorException in C:\Dev\PHP\YES_NewEra\storage\framework\views\bd2e5d612fd59236bdde19249252e5d4352530df.php:6
#51 Illuminate\Foundation\Bootstrap\HandleExceptions:handleError in C:\Dev\PHP\YES_NewEra\storage\framework\views\bd2e5d612fd59236bdde19249252e5d4352530df.php:6
#50 include in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php:42
#49 Illuminate\View\Engines\PhpEngine:evaluatePath in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php:59
#48 Illuminate\View\Engines\CompilerEngine:get in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\View.php:137
#47 Illuminate\View\View:getContents in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\View.php:120
#46 Illuminate\View\View:renderContents in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\View.php:85
#45 Illuminate\View\View:render in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Http\Response.php:38
#44 Illuminate\Http\Response:setContent in C:\Dev\PHP\YES_NewEra\vendor\symfony\http-foundation\Response.php:225
#43 Symfony\Component\HttpFoundation\Response:__construct in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Router.php:602
#42 Illuminate\Routing\Router:prepareResponse in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Router.php:560
#41 Illuminate\Routing\Router:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30
#40 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php:41
#39 Illuminate\Routing\Middleware\SubstituteBindings:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php:65
#36 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php:49
#33 Illuminate\View\Middleware\ShareErrorsFromSession:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#31 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:64
#30 Illuminate\Session\Middleware\StartSession:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#28 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php:37
#27 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#25 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php:59
#24 Illuminate\Cookie\Middleware\EncryptCookies:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#22 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:102
#21 Illuminate\Pipeline\Pipeline:then in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Router.php:561
#20 Illuminate\Routing\Router:runRouteWithinStack in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Router.php:520
#19 Illuminate\Routing\Router:dispatchToRoute in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Router.php:498
#18 Illuminate\Routing\Router:dispatch in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:174
#17 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30
#16 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:30
#15 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#14 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#13 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:30
#12 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#10 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php:27
#9 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#8 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#7 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:46
#6 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:148
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#4 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:102
#3 Illuminate\Pipeline\Pipeline:then in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:149
#2 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in C:\Dev\PHP\YES_NewEra\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:116
#1 Illuminate\Foundation\Http\Kernel:handle in C:\Dev\PHP\YES_NewEra\public\index.php:54
#0 require_once in C:\Dev\PHP\YES_NewEra\server.php:21

Alles anzeigen

Developer · 23. März 2017

wie ist denn die Bennenung deiner Spalten?

probier mal in den News:

$this->belongsTo(App\User::class, 'author_id');

DarkEvolution · 23. März 2017

Funtzt nun danke.
@Developer: danke für deine hilfsbereitschaft

breadfish.de 12. März 2022