Search in Snippets
 

All Projects

Building mini ecommerce in Laravel

Building RESTful APIs in Laravel

Building Mini Issue tracker with Laravel and Vue



All Snippets

Using Like

BookingDates::where('email', Input::get('email')) ->orWhere('name', 'like', '%' . Input::get('name') . '%')->get();


How to get names in list instead of associated array ( id as key and name as value )

PiggyBankCategory::orderBy( 'name', 'asc' )->get()->pluck('name', 'id');


How to use count with where condition

$active_requests = UserPiggyBank::where('process',1)->count();


How to delete all the rows in a table

\App\Model::query()->delete();


Updating multiple rows

$values = Value::where('project_id', $id)->update(['data'=>$data]);


In a nutshell following are my weeknesses

1. Code & CI/CD, optimized2. Microservices3. Unit testing / Add tests / Software testing with PHP UNIT, PHPSpec, Behat 4....


Using WhereIn

$whereTypes = ['png','jpeg','JPG','jpg']; $media = PostFile::where('post_id', $post->id)->whereIn('type', $whereTypes)->first();


Using selectRaw with aggregate function, where, orderBy, groupBy, take and get

UserPoint::selectRaw("TRUNCATE(SUM(amount),2) as summ, COUNT(id) as cnt") ->where('archive', 0) ->orderBy("dat",desc) ->groupBy("dat") ->take(13) ->get()


To make api resource controller which excludes create and edit actions

php artisan make:controller Api/TaskController --api


To check available routes in application

Artisan command to check available routes in applicationphp artisan route:list


mahfooz

Hello, I am Mahfoozur Rahman and LCS is a site where I have been put together all my development experience with laravel in tutorials and step by step manner.

I am also working remotely for clients with development services so that they can achieve their business goals.

If that is what you want, you can contact me on mahfoozur.rahman.bd@gmail.com

I am currently also available for freelance work.

Categories

VS Code Tips and Tricks (2)
Restful API (1)
Coding Assistance (1)
Database Concepts (1)
Schema Design (0)
Data Retrieval (1)
Searching Data (0)
DevOps (1)
Amazon web services (1)
Livewire (1)
Crud (1)
Storage and retrieval (1)
Caching (1)
Frontend (2)
Select dropdown (2)
File Uploads (1)
File Uploads (1)
Vue (2)
Vite Vue (1)
Mixin (1)
Packages (1)
Debugging (1)
Security (1)
Authentication (1)
View (1)
View Composer (1)
Projects (99)
Model Performance (4)
Registration (1)
Login (1)
Restful API (16)
Topic oriented Community (1)
Mini Ecommerce (38)
Mini Blog (2)
Mini Issue tracker (28)
Database tables and data scaffolding (1)
Stripe (1)
Topic oriented user community (6)
Collections (7)
Collection Methods (7)
Sessions (2)
Storing Data (1)
Retrieving Data (1)
Improvements (7)
Laravel Code Snippets (6)
Mini Ecommerce (1)
Definitions (2)
Generating Commands (0)
Eloquent Builder (1)
Resource Controllers (0)
Seeding (1)
Executing Commands (0)
Controller (4)
Resource Controllers (0)
Middleware (4)
My Weeknesses (1)
My Weekness (1)
Eloquent ORM (50)
Eloquent Builder (30)
Seeding (4)
Relationship (6)
Configurations (8)
Accessors (2)
Artisan Console (4)
Executing Commands (4)
Generating Commands (0)