Instal.lar una versio especifica de laravel en aquest cas la 8 amb WEBPACK-MIX.

					 
composer create-project laravel/laravel proyecto "8.*"
					

routes laravel

/*
|--------------------------------------------------------------------------
| les meves routes 
|--------------------------------------------------------------------------
*/

Route::get('/', function () {
    $persons = DB::table('people')->where('categoria', 'painters')
                                ->orderBy('id', 'desc')
                                ->paginate(20);
    return View::make('welcome')->with('persons', $persons);
});

Route::get('/codis', function () {   
    $objectius = App\Objectiu::all();
    return view('codis', compact('objectius'));
});

Route::get('/tools', function () {   
    $tools = App\Tool::all();
    return view('tools', compact('tools'));
});

Route::get('/laravel', function () {   
    return view('laravel');
});

Route::get('/webs', function () {   
    $webs = App\Web::all();
    return view('webs', compact('webs'));
});

/*
|--------------------------------------------------------------------------
| jetstrream Routes
|--------------------------------------------------------------------------
*/

Route::middleware([
    'auth:sanctum',
    config('jetstream.auth_session'),
    'verified'
])->group(function () {
    Route::get('/dashboard', function () {
        return view('dashboard');
    })->name('dashboard');
	
	Route::get('/dashmodels', function () {
		$persons = DB::table('people')->where('categoria', 'models')
                                ->orderBy('nom', 'desc')
                                ->paginate(20);
        return View::make('dashmodels')->with('persons', $persons);
    })->name('dashmodels');
	
	Route::get('/dashpeople', function () {
        $persons = App\Person::all();
    return view('dashpeople', compact('persons'));
    })->name('dashpeople');
});

/*
|--------------------------------------------------------------------------
| voyager Routes
|--------------------------------------------------------------------------
*/
Route::group(['prefix' => 'admin'], function () {
    Voyager::routes();
});

migration laravel tools

 <?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('tools', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('nom', 255);
            $table->text('descripcio');
            $table->text('body');
            $table->string('categoria', 255);
            $table->string('img', 255);
            $table->string('youtube', 255);
            $table->string('web', 255);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('tools');
    }
};

vistes i layouts en laravel (views)

1-<!-- Stored in resources/views/layouts/app.blade.php -->
<!-- el codi html del header nav -->
@yield('content')
<!-- el codi html del footer -->


2-<!-- Stored in resources/views/pagina.blade.php -->

@extends('layouts.Appestudi')
@section('title', 'Gal.leria de webs')
@section('content')

<!-- el codi html del contingut -->


@stop

Crear nomes el Controlador resource

php artisan make:controller CodesController --resource

vistes laravel cridar foreach

@foreach ($persons as $person)
	
	{{$person->categoria}}
	
@endforeach
	

creacio d'un middlewares per a protegir las routes.

php artisan make:middleware EnsureTokenIsValid

<?php
 
namespace App\Http\Middleware;
 
use Closure;
 
class EnsureTokenIsValid
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        if ($request->input('token') !== 'my-secret-token') {
            return redirect('home');
        }
 
        return $next($request);
    }
}

creacio d'una consulta query

<?php
 
namespace App\Http\Controllers;
 
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;
 
class UserController extends Controller
{
    /**
     * Show a list of all of the application's users.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = DB::select('select * from users where active = ?', [1]);
 
        return view('user.index', ['users' => $users]);
    }
}

Artisan Console

php artisan list

php artisan help migrate

php artisan tinker

crear model web

 //crear model web
php artisan make:model Web -mcr

 //editar la migracio 

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('webs', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('img', 255);
            $table->string('nom', 255);
            $table->string('tipus', 255);
            $table->string('framework', 255);
            $table->string('css', 255);
            $table->string('servidor', 255);
            $table->string('url', 255);
            $table->string('download', 255);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('webs');
    }
};

 //editar el model

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Web extends Model
{
    use HasFactory;
	protected $fillable = array('img', 'nom', 'tipus', 'framework', 'css', 'servidor', 'url', 'download');
}

crear un model -mcr

 php artisan make:model Web -mcr



<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Web extends Model
{
    use HasFactory;
	 protected $fillable = array('nom', 'descripcio', 'categoria', 'css', 'framework', 'url', 'download', 'servidor', 'img');
}

filament estructura per la migracio de Code

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

/**
 * Migration auto-generated by TablePlus 4.10.1(202)
 * @author https://tableplus.com
 * @source https://github.com/TablePlus/tabledump
 */
class CreateCodesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('codes', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('nom', 255);
            $table->string('categoria', 255);
            $table->string('tags', 255);
            $table->text('descripcio')->nullable()->default(NULL);
            $table->longtext('blockcode');
            $table->string('txt', 255)->nullable()->default(NULL);
            $table->string('youtube', 255)->nullable()->default(NULL);
            $table->string('url', 255)->nullable()->default(NULL);
            $table->timestamp('updated_at')->nullable()->default(NULL);
            $table->timestamp('created_at')->nullable()->default(NULL);
        });
    }
   
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('codes');
    }
}

filament estructura migracio per crear la taula objectius

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

/**
 * Migration auto-generated by TablePlus 4.10.1(202)
 * @author https://tableplus.com
 * @source https://github.com/TablePlus/tabledump
 */
class CreateObjectiusTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('objectius', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('nom', 255);
            $table->text('descripcio');
            $table->string('status', 255);
            $table->string('urlsolucio', 255)->nullable()->default(NULL);
            $table->timestamp('created_at')->nullable()->default(NULL);
            $table->timestamp('updated_at')->nullable()->default(NULL);
        });
    }
   
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('objectius');
    }
}

filament crear un recurs per la taula objectius

php artisan make:filament-resource Objectiu --generate

crear acces directe de storage

php artisan storage:link

migracio per la taula people

 <?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('people', function (Blueprint $table) {
            $table->id();
			$table->string('nom', 255);
            $table->string('img', 255)->nullable()->default(NULL);
            $table->string('categoria', 255);
            $table->string('vestit', 255);
            $table->string('cabell', 255);
            $table->string('origen', 255);
            $table->string('web', 255)->nullable()->default(NULL);
            $table->string('folder', 255)->nullable()->default(NULL);
            $table->string('ins', 255);
            $table->string('face', 255)->nullable()->default(NULL);
            $table->string('mp3', 255)->nullable()->default(NULL);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('people');
    }
};

laravel storage link solucio per la fragmentacio del codi a servidor compartit

solucio: eliminar la carpeta storage de public i afegir ruta nova i executarla.
es mostrara una pagina en blanc i el acces directe estara creat.

Route::get('/linkstorage', function () {
    Artisan::call('storage:link');
});

consulta a la ruta

Route::get('/', function()
{
    $builds = DB::table('blogs')->where('frontpage', '1')
                                ->orderBy('id', 'desc')
                                ->paginate(20);
    return View::make('pages/home')->with('builds', $builds);
});

route que porta tots els registes de una taula

Route::get('/people', function () {   
    $persons = App\Person::all();
    return view('people', compact('persons'));
});

consultas a la route

Route::get('/people', function () {
    $persons = DB::select("SELECT * FROM `people` WHERE `categoria` IN ('photographers', 'painters', 'influencers', 'music'); ");
    return view('people', compact('persons'));
});



Route::get('/dashboard', function()
{
    $persons = DB::table('people')->where('categoria', 'models')
                                ->orderBy('id', 'desc')
                                ->paginate(20);
    return View::make('dashboard')->with('persons', $persons);
})->name('dashboard');

instalar laravel amb jetstream

laravel new project --jet

section cards uikit people

<section class="text-gray-400 bg-gray-900" style="background-image: url('liniesvoyager180.png');background-repeat: no-repeat;" >
<div class="uk-container uk-container-large">

     <div class="uk-grid uk-flex-center uk-padding-medium">
    <h1 class="uk-text-center uk-text-middle text-5xl uk-text-bold text-transparent bg-clip-text bg-gradient-to-r from-green-400 via-blue-500 to-purple-500 title-font mb-6">@yield ('title')</h1>
</div>
	
		<div class="uk-grid uk-flex-center ">
		
						<form id="search-form" action="">
							<div class="uk-inline uk-width-1-1">
								<span class="uk-form-icon uk-form-icon-flip uk-icon" data-uk-icon="icon: search"><svg width="20" height="20" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg" data-svg="search"><circle fill="none" stroke="#000" stroke-width="1.1" cx="9" cy="9" r="7"></circle><path fill="none" stroke="#000" stroke-width="1.1" d="M14,14 L18,18 L14,14 Z"></path></svg></span>
								<input class="uk-input uk-width-1-1 search-fld" type="text" placeholder="Type your search" autofocus="">
								<a hidden="" href="#" class="search-filter" data-uk-filter-control="[data-tags*='']">Search</a>
								<a hidden="" href="#" class="search-filter-all uk-active" data-uk-filter-control="">Search all</a>
								<a hidden="" href="#" class="search-filter-none" data-uk-filter-control="[data-empty='']">Filter none</a>
							</div>
						</form>
		</div>
		
		<!--CARDS WRAPPER-->
		
			
		
				<ul class="uk-subnav uk-subnav-pill">
					<li class="uk-active" data-uk-filter-control=""><a href="#">Show All</a></li>
					<li data-uk-filter-control=".painters"><a href="#">painters</a></li>
					<li data-uk-filter-control=".photographers"><a href="#">photographers</a></li>
					<li data-uk-filter-control=".influencers"><a href="#">influencers</a></li>
					<li data-uk-filter-control=".models"><a href="#">models</a></li>
					<li data-uk-filter-control=".music"><a href="#">music</a></li>
					
				</ul>
				<div class="uk-grid uk-grid-medium uk-child-width-1-2@s uk-child-width-1-3@m uk-child-width-1-4@l  uk-child-width-1-4@xl uk-grid-match js-filter" data-uk-grid="masonry: true" data-uk-sortable="handle: .drag-icon">
				
				
		@foreach ($persons as $person)
					
					<!-- card -->
					<div class="{{$person->categoria}}" data-tags="{{$person->nom}} {{$person->categoria}} ">
						<div class="uk-card uk-card-small uk-card-default">
							
							<div class="uk-card-media">
								<div class="uk-inline-clip uk-transition-toggle" tabindex="0">
									<img data-fancybox="gallery" src="storage/{{$person->img}}" >
									<div class="uk-transition-slide-bottom uk-position-bottom uk-overlay uk-overlay-primary">
										<span data-uk-icon="icon:heart; ratio: 0.8"></span>seguidors:  {{$person->ranking}} 
									</div>
								</div>
								
							</div>
							<div class="uk-card-body">
								<h4 class="uk-margin-small-bottom uk-margin-remove-adjacent uk-text-bold text-transparent bg-clip-text bg-gradient-to-r from-green-400 via-blue-500 to-purple-500">{{$person->nom}}</h4>
								<p class="uk-text-small uk-text-muted">{{$person->categoria}}-{{$person->updated_at}}</p>
							</div>
							<div class="uk-card-footer">
								<div class="uk-grid uk-grid-small uk-grid-divider uk-flex uk-flex-middle" data-uk-grid>
									
									<div class="uk-width-auto uk-text-right">
										<a href="{{$person->folder}}" data-uk-tooltip="title: gallery folder" class="uk-icon-link" data-uk-icon="icon:folder; ratio: 1.2"target="_blank"></a>
										<a href="{{$person->ins}}" data-uk-tooltip="title: Instagram" class="uk-icon-link" data-uk-icon="icon:instagram; ratio: 1.2"target="_blank"></a>
										<a href="{{$person->youtube}}" data-uk-tooltip="title: canal youtube" class="uk-icon-link" data-uk-icon="icon:youtube; ratio: 1.2"target="_blank"></a>
										<a href="{{$person->face}}" data-uk-tooltip="title: facebook" class="uk-icon-link" data-uk-icon="icon:facebook; ratio: 1.2"target="_blank"></a>
										<a href="{{$person->tiktok}}" data-uk-tooltip="title: tiktok" class="uk-icon-link" data-uk-icon="icon:tiktok; ratio: 1.2"target="_blank"></a>
										<a data-fancybox href="{{$person->video}}" data-uk-tooltip="title: veure video" class="uk-icon-link" data-uk-icon="icon:play-circle; ratio: 1.2"target="_blank"></a>
										<a href="{{$person->mp3}}" data-uk-tooltip="title: escoltar musica" class="uk-icon-link" data-uk-icon="icon:soundcloud; ratio: 1.2"target="_blank"></a>
									</div>
									<div class="uk-width-auto uk-text-right">
										<a data-uk-tooltip="title: Drag this card" href="#" class="uk-icon-link drag-icon" data-uk-icon="icon:move; ratio: 1.2"></a>
									</div>
								</div>
							</div>
						</div>
					</div>
					<!-- /card -->
				@endforeach
					
				</div>
			
			</div>
			
		</section>

instal.lar laravel ultima versio + jetstream + voyager

laravel new estudijoanpuig --jet

npm install
npm run build
npm run dev

php artisan migrate

composer require tcg/voyager
php artisan voyager:install --with-dummy
php artisan voyager:admin joanpuigbertran@gmail.com --create

Com crear un component?

php artisan make:livewire ShowPosts

crear un recurs per al model Person

//crear un recurs per al App\Models\Person.php://

php artisan make:filament-resource Person

//aixo creara varis fitxers i directori//

+-- PersonResource.php
+-- PersonResource
|   +-- Pages
|   |   +-- CreatePerson.php
|   |   +-- EditPerson.php
|   |   +-- ListPerson.php

panel filament llistar i editar la taula People: php artisan make:filament-resource Person --generate

php artisan make:model Person -mcr

//editar app\Models\Person.php//
class Person extends Model
{
    use HasFactory;
	 protected $fillable = array('nom', 'img', 'categoria', 'folder', 'web', 'ins', 'face', 'vestit', 'cabell', 'origen');
}

//editar database\migrations\create-people_table.php//
class Person extends Model
{
    use HasFactory;
	 protected $fillable = array('nom', 'img', 'categoria', 'folder', 'web', 'ins', 'face', 'vestit', 'cabell', 'origen');
}

composer require doctrine/dbal
php artisan make:filament-resource Person --generate

//editar app\Filament\PersonResource.php//

<?php

namespace App\Filament\Resources;

use App\Filament\Resources\PersonResource\Pages;
use App\Filament\Resources\PersonResource\RelationManagers;
use App\Models\Person;
use Filament\Forms;
use Filament\Resources\Form;
use Filament\Resources\Resource;
use Filament\Resources\Table;
use Filament\Tables;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\SoftDeletingScope;
use Filament\Forms\Components\FileUpload;
use Filament\Tables\Columns\ImageColumn;
use Filament\Forms\Components\Select;

class PersonResource extends Resource
{
    protected static ?string $model = Person::class;

    protected static ?string $navigationIcon = 'heroicon-o-collection';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\TextInput::make('nom')
                    ->required()
                    ->maxLength(255),
                Forms\Components\FileUpload::make('img'),
                   
                Forms\Components\Select::make('categoria')
                    ->options([
        'photographers' => 'photographers',
        'painters' => 'painters',
        'influencers' => 'influencers',
		'music' => 'music',
        'models' => 'models',
        'esports' => 'espòrts',
    ]),
                Forms\Components\Select::make('vestit')
                    ->options([
        'vestit' => 'vestit',
        'nu' => 'nu',
        'linguerie' => 'linguerie',		
    ]),
                Forms\Components\Select::make('cabell')
                    ->options([
        'rossa' => 'rossa',
        'morena' => 'morena',
        'pelroja' => 'pelroja',		
    ]),
                Forms\Components\Select::make('origen')
                    ->options([
        'caucasica' => 'caucasica',
        'negra' => 'negra',
        'asiatica' => 'asiatica',
		'catalan' => 'catalan',
        'spanish' => 'spanish',
        'asia' => 'asia',
		'africa' => 'africa',
		'north_america' => 'north_america',
        'south_america' => 'south_america',
        'antarctica' => 'antarctica',
		'europe' => 'europe',
        'australia' => 'australia',
    ]),
                Forms\Components\TextInput::make('folder')
                    ->maxLength(255),
                Forms\Components\TextInput::make('ins')
                    ->maxLength(255),
                Forms\Components\TextInput::make('face')
                    ->maxLength(255),
                Forms\Components\TextInput::make('mp3')
                    ->maxLength(255),
                Forms\Components\TextInput::make('web')
                    ->maxLength(255),
            ]);
    }

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                Tables\Columns\TextColumn::make('nom'),
                Tables\Columns\ImageColumn::make('img'),
                Tables\Columns\TextColumn::make('categoria'),
                Tables\Columns\TextColumn::make('vestit'),
                Tables\Columns\TextColumn::make('cabell'),
                Tables\Columns\TextColumn::make('origen'),
                Tables\Columns\TextColumn::make('folder'),
                Tables\Columns\TextColumn::make('ins'),
                Tables\Columns\TextColumn::make('face'),
                Tables\Columns\TextColumn::make('mp3'),
                Tables\Columns\TextColumn::make('created_at')
                    ->dateTime(),
                Tables\Columns\TextColumn::make('updated_at')
                    ->dateTime(),
                Tables\Columns\TextColumn::make('web'),
            ])
            ->filters([
                //
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\DeleteBulkAction::make(),
            ]);
    }
    
    public static function getRelations(): array
    {
        return [
            //
        ];
    }
    
    public static function getPages(): array
    {
        return [
            'index' => Pages\ListPeople::route('/'),
            'create' => Pages\CreatePerson::route('/create'),
            'edit' => Pages\EditPerson::route('/{record}/edit'),
        ];
    }    
}

Instal.lacio de Laravel versio 9 porta VITE.

composer create-project laravel/laravel:^9.0 example-app

laravel configurar el fitxer .env

APP_NAME=example-app
APP_ENV=local
APP_KEY=base64:aO1T7D9Qx+pQ5kjDIXrPcHIflOX2WImlT1U0kqROtCQ=
APP_DEBUG=true
APP_URL=http://example-app.test/

LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=example-app
DB_USERNAME=root
DB_PASSWORD=

consulta dues taules inner join al controlador

 
 1/** app\Http\Controllers\BlogPostsController.php (consulta dues taules unirles per categoria) */

    public function index()
    {
       $blog_posts = blog_posts::select(
                            "blog_posts.title",
							"blog_posts.banner",
							"blog_posts.excerpt",
							"blog_posts.published_at",
                            "blog_categories.name as name"
                        )
                        ->join("blog_categories", "blog_categories.id", "=", "blog_posts.blog_category_id")
                        ->get();
					return view('gallery_posts', compact('blog_posts'));
    }

    
    
 2/** routes/web.php */   
 
 Route::get('/gallery_posts','App\Http\Controllers\BlogPostsController@index');

 
 3/**resources\views\gallery_posts.blade.php */
 
 @foreach ($blog_posts as $blog_post)					
 @endforeach

Create fake Data using Tinker

 php artisan tinker


App\Models\User::factory(50)->create();

A instal.lar livewire

en el cas que ja tinguem nomes laravel:

composer require livewire/livewire

<html>
 <head>
   @livewireStyles
 </head>
 <body>
   @livewireScripts
 </body>
</html>

crear la taula CODES a la BBDD amb la migracio i model per administrarla

php artisan make:model Code -mcr

editar el fitxer que ha creat l'instruccio anterior que es trova a: 

 C:\xampp\htdocs\example-app\database\migrations\2023_05_26_145534_create_codes_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

/**
 * Migration auto-generated by TablePlus 5.3.8(232)
 * @author https://tableplus.com
 * @source https://github.com/TablePlus/tabledump
 */
class CreateCodesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('codes', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('nom', 255);
            $table->string('categoria', 255);
            $table->string('tags', 255);
            $table->mediumtext('descripcio')->nullable()->default(NULL);
            $table->longtext('blockcode')->nullable()->default(NULL);
            $table->string('txt', 255)->nullable()->default(NULL);
            $table->string('youtube', 255)->nullable()->default(NULL);
            $table->string('url', 255)->nullable()->default(NULL);
            $table->timestamp('updated_at')->nullable()->default(NULL);
            $table->timestamp('created_at')->nullable()->default(NULL);
        });
    }
   
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('codes');
    }
}

editar el fitxer que ha creat la instruccio anterior a:

C:\xampp\htdocs\example-app\app\Models\Code.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Code extends Model
{
    use HasFactory;
	protected $fillable = array('nom', 'categoria', 'tags', 'descripcio', 'blockcode', 'txt', 'youtube', 'url');
}

php artisan migrate

model laravel Tool

 <?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Tool extends Model
{
    use HasFactory;
	protected $fillable = array('nom', 'descripcio', 'body', 'categoria', 'img', 'youtube', 'web');
}

llistar registres desde controller

 //a routes\web.php
//cridar el controlador amb use
//afegir la route

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\WebController;


Route::get('webs', [WebController::class, 'index']);

 afegir la funcio index a app\Http\Controllers\WebController.php

public function index()
    {
        $webs = Web::all();    
		return view('webs.index', compact('webs'));
    }

 //crear directori webs i afegir index.blade.php
//fer foreach a l'element que vull repetir

@foreach ($webs as $web)
					
					<!-- card -->
					<div class="{{$web->framework}}" data-categoria="{{$web->categoria}}" data-css="{{$web->css}}" data-framework="{{$web->framework}}" data-servidor="{{$web->servidor}}" data-nom="{{$web->nom}}" data-descripcio="{{$web->descripcio}}" data-tags="{{$web->categoria}} {{$web->css}} {{$web->framework}} {{$web->servidor}} {{$web->nom}} {{$web->descripcio}}">
						<div class="uk-card uk-card-small uk-card-default">
							<div class="uk-card-header">
								<div class="uk-grid uk-grid-small uk-text-small" data-uk-grid>
									<div class="uk-width-expand">
										<span class="cat-txt">{{$web->categoria}}</span>
									</div>
									<div class="uk-width-auto uk-text-right uk-text-muted">
										{{$web->css}}
									</div>
								</div>
							</div>
							<div class="uk-card-media">
								<div class="uk-inline-clip uk-transition-toggle" tabindex="0">
									<a data-fancybox="gallery" data-src="storage/{{$web->img}}"><img src="storage/{{$web->img}}"/></a>
									<div class="uk-transition-slide-bottom uk-position-bottom uk-overlay uk-overlay-primary">
										{{$web->categoria}} - {{$web->tags}} - {{$web->css}} - {{$web->framework}}
									</div>
								</div>
								
							</div>
							<div class="uk-card-body">
								<h6 ><a class="uk-margin-small-bottom uk-margin-remove-adjacent uk-text-bold" href="{{$web->url}}">{{$web->nom}}</a></h6>
								<p class="uk-text-small uk-text-muted">{{$web->idescripcio}}</p>
							</div>
							<div class="uk-card-footer">
								<div class="uk-grid uk-grid-small uk-grid-divider uk-flex uk-flex-middle" data-uk-grid>
									<div class="uk-width-expand uk-text-small">
										{{$web->updated_at}}
									</div>
									<div class="uk-width-auto uk-text-right">
										<div class="uk-inline ">
				
					<a href="{{$web->url}}" target="_blank"><span uk-icon="link" class="uk-icon"></span></a>
					
					<a href="{{$web->download}}" target="_blank"><span uk-icon="download" class="uk-icon"></span></a>
					
					<a data-fancybox="video-gallery" href="{{$web->youtube}}"><span uk-icon="youtube" class="uk-icon"></span></a>
					
					<a data-fancybox="" data-type="iframe" data-src="embed/{{$web->codi}}" href="javascript:;"><span uk-icon="code" class="uk-icon"></span></a>
				
				
              </div>
									</div>
									<div class="uk-width-auto uk-text-right">
										<a data-uk-tooltip="title: Drag this card" href="#" class="uk-icon-link drag-icon" data-uk-icon="icon:move; ratio: 1"></a>
									</div>
								</div>
							</div>
						</div>
					</div>
					<!-- /card -->
				@endforeach	

watercolor resource

 //crear model controlador i migracio de Watercolor

php artisan make:model Watercolor -mcr

//editar model
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Watercolor extends Model
{
    use HasFactory;
	protected $fillable = array('img', 'nom', 'dimensions', 'any', 'theme', 'autor', 'url');
}

//editar controlador
<?php

namespace App\Http\Controllers;

use App\Models\Watercolor;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class WatercolorController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $watercolor = Watercolor::all()->sortByDesc("updated_at");    
		return view('watercolor.index', compact('watercolor'));
    }
    
//editar migracio

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('watercolors', function (Blueprint $table) {
            $table->integer('id')->unsigned()->autoIncrement();
            $table->string('img', 255);
            $table->string('nom', 255);
            $table->string('dimensions', 255)->nullable()->default(NULL);
            $table->string('any', 255)->nullable()->default(NULL);
            $table->string('theme', 255);
            $table->string('autor', 255)->nullable()->default(NULL);
            $table->string('url', 255)->nullable()->default(NULL);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('watercolors');
    }
};

//executar la migracio
php artisan migrate

CodeController.php

La millor forma de crear un controlador resources es fer-ho desde el principi. Amb una sola ordre per el model la migracio que creara la taula i el controlador.

php artisan make:model Code -mcr

<?php

namespace App\Http\Controllers;

use App\Models\Code;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class CodeController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $codes = Code::all();    
		return view('codes.index', compact('codes'));
    }
	
	public function install()
    {
        $codes = DB::table('codes')                
				->where('tipus', '=', 'l9f2' )
                ->get(); 
		return view('codes.install', compact('codes'));
    }
	
	public function laravel()
    {
        $codes = DB::table('codes')                
				->where('framework', '=', 'laravel' )
				
                ->get(); 
		return view('codes.laravel', compact('codes'));
    }
	
	public function filament()
    {
        $codes = DB::table('codes')                
				->where('framework', '=', 'filament' )
                ->get(); 
		return view('codes.filament', compact('codes'));
    }
	
	public function model_laravel()
    {
        $codes = DB::table('codes')                
				->where([
				['framework', '=', 'laravel'],
				['tipus', '=', 'model']
				])
                ->get(); 
		return view('codes.model', compact('codes'));
    }
	
	public function controller_laravel()
    {
        $codes = DB::table('codes')                
				->where([
				['framework', '=', 'laravel'],
				['tipus', '=', 'controllers']
				])
                ->get()->sortByDesc("updated_at"); 
		return view('codes.controller', compact('codes'));
    }
	
	

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Code  $code
     * @return \Illuminate\Http\Response
     */
    public function show(Code $code)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Code  $code
     * @return \Illuminate\Http\Response
     */
    public function edit(Code $code)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Code  $code
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Code $code)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Code  $code
     * @return \Illuminate\Http\Response
     */
    public function destroy(Code $code)
    {
        //
    }
}