Cacher is the code snippet organizer for pro developers

Creating DatabasesDelete…
0%
Create DB @ Phpmyadmin
Creating a Model W/Migration php artisan make:model ModelName -m
Adding Fields -> Databases/Migrations/TableName.php
Configure DB Config. -> .env + config. DB_CONNECTION
Fixing DB Field Value details -> App/Providers/AppServiceProvider.php + use Illuminate\Support\Facades\Schema; + public function boot() {Schema::defaultStringLength(191); }
Migrate Database/Migrations/TableName.php php artisan migrate


Add + Edit + View DB info W/Tinker (eloquent)Delete…
0%
Start Tinker php artisan tinker
Access Model/View total registries App\ModelName::count()
Post Registry $post = new App\ModelName();
$post->fieldName = 'Value';
Save $post -> save();


Showing Data from DatabaseDelete…
0%
Show All Results $posts = Post::all();
Where $posts = Post::all();return $posts = Post::where('title', 'Post Two') ->get();
Custom MySQL Query $posts = DB::select('SELECT * FROM posts');
Order By $posts = Post::orderBy('created_at','desc')->get();
Order By W/Number of Results $posts = Post::orderBy('created_at','desc')->take(1)->get();
Adds Pagination $posts = Post::orderBy('title','desc')->paginate(10);
{{$posts->links()}}



Adding fields to Database W/Migration
Save
0%
terminal -> php artisan make:migration migration_name
Go to database/migrations/migration_name
Update In function up()
Schema::table('tableName', function($table){
$table->integer('fieldName');
});
Update In function down()
Schema::table('tableName', function($table){
$table->dropColumn('fieldName');
});
terminal -> php artisan migrate