Level 75
Do you know spacebar? Start using it.
With eager loading you get all your images.
$albums = Album::with('images')->get();
Always return redirect inside store method.
Mar 31, 2022
28
Level 2
Showing images from DB
I'm storing albums in table albums and the images in table images with relations but i cannot find the logic to show the images from the blade Index/Store Method in controller
public function index()
{
$albums=Album::all();
return view('admin.albums.all',compact('albums'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$album=Album::create([
'name'=>$request->name,
'price'=>$request->price,
'image'=>$request->image,
'category_id'=>$request->category_id,
]);
foreach($request->images as $image){
$filename = $image->store('album');
$images=Image::create([
'album_id' => $album->id,
'filename' => $filename
]);
}
$albums=Album::all();
return view('admin.albums.all',compact('albums'));
}
all.blade.php
<tbody>
@foreach ($albums as $album)
<tr>
<th scope="row">{{$album->id}}</th>
<td>{{$album->name}}</td>
<td>{{$album->category_id}}</td>
<td><img style="width:5vw; hieght:5vh" src="{{$album->id}}" alt=""></td>
<td>
<a href="{{route('albums.show',$album->id)}}" class="btn btn-success">Show</a>
@if (Auth::user()->role_id==1)
<a href="{{route('albums.edit',$album->id)}}" class="btn btn-warning">Edit</a>
<form action="{{route('albums.destroy',$album->id)}}" method="post" class="d-inline">
@csrf
@method('DELETE')
<input type="submit" class="btn btn-danger" value="Delete" />
</form>
@else
@endif
</td>
</tr>
@endforeach
</tbody>
Image Model
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Image extends Model
{
use HasFactory;
protected $fillable = ['album_id','filename'];
public function images(){
return $this->belongsTo(Album::class,'images_id','id');
}
}
Album Model
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Album extends Model
{
use HasFactory;
protected $fillable = [
'name',
'category_id',
];
public function categories(){
return $this->belongsTo(Category::class,'category_id','id');
}
public function images(){
return $this->HasMany(Image::class);
}
}
Level 2
@MichalOravec I didn't get it
Level 2
@MichalOravec i didn't get what should i write in blade.php
i've used the spacebar you advised me to use
Level 73
You can do a foreach on $album->images, I recommend eagar loding the relation in your controller.
$albums = Album::with('images')->get();
However if you have a shitload of images and albums you need to paginate the albums and the pictures.
Level 2
@Tray2 the album related to images table with the ID i've tried
$albums = Album::with('images')->get();
but its not working.
Level 104
@karimali1337 its not working? Maybe you need to be more descriptive!
Also, what is the story with the relationships; Image has a BelongsTo relationship named images; and you have a non-conventional foreign key, but Album has a HasMany images relationship without a non-conventional key?
Level 2
@tykus i mean that i used the spacebar but i don't know how to show them in blade as the relation between albums and images related with the album ID,
about the relations im practicing on it in this small project because i don't understand them well then i'm trying to practicing.
Level 73
@karimali1337 what happen if you do a dd($albums) after the fetch?
Level 104
@karimali1337 spacebar??? WTF are you talking about?
Level 2
^ Illuminate\Database\Eloquent\Collection {#1224 ▼
#items: array:4 [▼
0 => App\Models\Album {#1234 ▼
#connection: "mysql"
#table: "albums"
#primaryKey: "id"
#keyType: "int"
+incrementing: true
#with: []
#withCount: []
+preventsLazyLoading: false
#perPage: 15
+exists: true
+wasRecentlyCreated: false
#escapeWhenCastingToString: false
#attributes: array:5 [▶]
#original: array:5 [▶]
#changes: []
#casts: []
#classCastCache: []
#attributeCastCache: []
#dates: []
#dateFormat: null
#appends: []
#dispatchesEvents: []
#observables: []
#relations: array:1 [▶]
#touches: []
+timestamps: true
#hidden: []
#visible: []
#fillable: array:2 [▶]
#guarded: array:1 [▶]
}
1 => App\Models\Album {#1235 ▶}
2 => App\Models\Album {#1236 ▶}
3 => App\Models\Album {#1237 ▶}
]
#escapeWhenCastingToString: false
}
Level 2
@tykus forget it, its misunderstanding from me.
Level 104
@karimali1337 okay 🤷♂️
Still what is up with the relationship? What is the foreign key on the images table?
Level 2
@tykus foreign key is id on albums table
Level 2
@tykus when i upload album the images saved in table images with the id of album in table albums
Level 104
@karimali1337 what is the name of the column on the images table which relates to the ID on albums?
Level 2
@tykus album_id , i know i'm stupid but beginnings is always hard.
Level 104
@karimali1337 so why is this not working - what are you getting???
$albums = Album::with('images')->get();
Level 2
@tykus i don't know what to write in my all.blade.php to preview the image here's my blade all info like id ,album , category is shown right but the images is not previewed
Index in album controller
public function index()
{
$albums = Album::with('images')->get();
return view('admin.albums.all',compact('albums'));
}
albums all.blade.php
<tbody>
@foreach ($albums as $album)
<tr>
<th scope="row">{{$album->id}}</th>
<td>{{$album->name}}</td>
<td>{{$album->category_id}}</td>
<td><img style="width:5vw; hieght:5vh" src="{{$album->id}}" alt=""></td>
<td>
<a href="{{route('albums.show',$album->id)}}" class="btn btn-success">Show</a>
@if (Auth::user()->role_id==1)
<a href="{{route('albums.edit',$album->id)}}" class="btn btn-warning">Edit</a>
<form action="{{route('albums.destroy',$album->id)}}" method="post" class="d-inline">
@csrf
@method('DELETE')
<input type="submit" class="btn btn-danger" value="Delete" />
</form>
@else
@endif
</td>
</tr>
@endforeach
</tbody>
Level 104
@karimali1337 well $album->images will be a Collection, so you would need a nested loop to iterate over the images, e.g.
@foreach ($albums as $album)
@foreach ($album->images as $image)
< img style="width:5vw; height:5vh" src="{{$image->filename}}" alt="">
@endforeach
@endforeach
Level 2
@tykus When i apply this code the output looks like i've deleted the
<td><img style="width:5vw; hieght:5vh" src="{{$image->filename}}" alt=""></td>
and the image not previewed
Level 104
@karimali1337 does the album in question have any images?
Level 2
@tykus yes sure i've inserted 2 images and its saved to the DB
Level 73
@karimali1337 Is the path to the image correct and line up with where the image actually is in your filesystem?
Level 2
@Tray2 i was storing in folder name albums, and the images was stored in right way, now if im inserted new album it doesn't store photo but store a temp file named php008.tmp
Level 73
@karimali1337 I suggest using intervention https://image.intervention.io/v2
Level 2
@Tray2 Okay i'll try,Thank you.
Level 73
@karimali1337 I also highly recommend the free Laravel 8 from scratch series
Level 2
@Tray2 i'm on it now series 28
Please or to participate in this conversation.