controller

---------------------------------------------------------------------------
Simple Controller
--------------------------------------------------------------------------- 
use Illuminate\Support\Facades\File;
use App\Models\Blog;
          
public function create(){                                                 
    return view('create');
}        
public function index(){
    $data['blogs'] = Blog::all();
    return view('index', $data);
}
public function store(Request $request){
    $data = new Blog;                                              
    $data->title = $request->title; 
          
    // enctype="multipart/form-data"
    if($request->hasFile('image')) {
        $file=$request->file('image');
        $imageName=date('YmdHis') . "." . $file->getClientOriginalName();
        $request->file('image')->storeAs('images/blogs/',$imageName);
        $file->move(public_path('images/blogs/'),$imageName);
        $data->image = $imageName;
    } 
    if($request->hasFile('image')) {
        $imageName = time().".".$request->file('image')->extension();
        $request->file('image')->move(public_path('images/blogs/'),$imageName);
        $data->image = $imageName;
    } 
    $data->save();                                                 
    return redirect()->back();
}
public function store(Request $request){
    //Blog.php //protected $fillable = ['title',];
    $data = Blog::create([
        'title'=>$request->title,
    ]);
    return redirect()->back();
}
public function show($id){
    $data['blog'] = Blog::find($id);                                                                                       
    return view('show', $data);
} 
public function edit($id){
    $data['blog'] = Blog::find($id);                                          
    return view('edit', $data);
} 
public function update(Request $request, $id){
    $data = Blog::find($id);                           
    $data->title = $request->title;                                    
    if($request->hasfile('image')){
        $destination = 'images/blog/'.$data->image;
        if(File::exists($destination)){ File::delete($destination); }
        $file=$request->file('image');
        $imageName=date('YmdHis') . "." . $file->getClientOriginalName();
        $request->file('image')->storeAs('images/blogs/',$imageName);
        $file->move(public_path('images/blogs/'),$imageName);
        $data->image = $imageName;
    }                                                      
    $data->update();                                            
    return redirect()->back();  
}
public function delete($id){
    $data = Blog::find($id);
    $destination = 'images/blog/'.$data->image;
    if(File::exists($destination)){ File::delete($destination); }                    
    $data->delete();                                     
    return redirect()->back();
} 
          
return redirect()->back()->with('success', 'Added Successfully Done');            
return redirect()->back()->with('success', 'Updated Successfully Done');        
return redirect()->back()->with('error', 'Deleted Successfully Done');
          
return redirect()->to('/checkout/'.$id);          
return redirect()->to('/checkout/{$id}');           
return redirect()->route('abc.xyz');        
return redirect()->route('abc.xyz', ['id' => $id]);
          
---------------------------------------------------------------------------
RESIZE IMAGE   
---------------------------------------------------------------------------          
composer require intervention/image:^2.7
use Image; 
if($request->hasFile('image')) {
    $imageName = time().".".$request->file('image')->extension();
          
    $path = public_path('images/blogs/');
    $img = Image::make($request->file('image')->path());
    $img->resize(300,300)->save($path.'/'.$imageName);
    $data->image = $imageName;
}    
php.ini search extension=fileinfo remove ; OR
composer require intervention/image:^2.7 --ignore-platform-req=ext-fileinfo [not recommended]
in cpanel Select PHP Version -> fileinfo ENABLE
---------------------------------------------------------------------------
DIFFERENT IMAGE   
---------------------------------------------------------------------------        
php artisan storage:link
$image = $request->file('image');
$imageName = time().'.'.$image->getClientOriginalExtension();
$image->storeAs('public/blogs', $imageName);
$data->image=$imageName;
$data->save();
<img src="{{ asset('storage/blogs/'.$blog->image) }}">
          
---------------------------------------------------------------------------
SEARCHING SYSTEM   
---------------------------------------------------------------------------      
$categories = Category::select('*')->where('name','LIKE','%'.$request->search.'%')->orWhere('id','LIKE','%'.$request->search.'%')->latest()->get();
      
---------------------------------------------------------------------------
REPORT         
---------------------------------------------------------------------------
use Carbon\Carbon;
Earn::latest()->whereMonth('created_at', Carbon::now()->month)->get();
Earn::latest()->whereDate('created_at',Carbon::yesterday())->get();
Earn::latest()->whereDate('created_at',Carbon::today())->get();

public function store(Request $request){
    $category = Category::create([
        'name'=>$request->name,
    ]);
    if(!empty($category)){
        return redirect()->route('categories.index')->with('success' ,'Created');
    }
    return redirect()->back()->withInput();
}
public function update(Request $request, Category $category){
    $category->update([
        'name'=>$request->name,
    ]);
    if(!empty($category)){
        return redirect()->route('categories.index')->with('success' ,'Updated');
    }
    return redirect()->back()->withInput();
}
public function destroy($id){
    $category = Category::find($id);
    if (!$category) {
        return redirect()->back()->with('error', 'Not Found');
    }
    $category->subCategories()->delete();
    $category->delete();
    return redirect()->route('categories.index')->with('error','Deleted');
}

$pivotDatas = WarehouseProduct::with('warehouse', 'product')->get();

public function show($id){
  $data = User::find($id);
  $peronal_chats = PersonalChat::select('*')
              ->where('teacher_email',$data->email)
              ->where('student_email',Auth::user()->email)
              ->orderBy('id', 'DESC')
              ->get();
  return view('student.chat.show', compact('data','peronal_chats'));
}

public function teacherPersonal($email){

$peronal_chats = PersonalChat::select('*')
              ->where('student_email',$email)
              ->where('teacher_email',Auth::user()->email)
              ->orderBy('id', 'DESC')
              ->get();

return view('teacher.chat.single', ['email' => $email], compact('peronal_chats'));
}
          
---------------------------------------------------------------------------         
Ajker Date Auto niye nibe          
---------------------------------------------------------------------------
use Carbon\Carbon;
if(!empty($request->date)){
  $credit->r_date=$request->date;
}
else{
  $credit->r_date= Carbon::today();
}

DB
use DB;

INDEX
$a = DB::table('posts')->get();
          
STORE
$data = array();
$data['name'] = $request->name;
DB::table('users')->insert($data);

JOIN
DB::table('subcategories')
          ->Join('categories', 'subcategories.category_id', 'categories.id')
          ->select('categories.name','categories.*')
          ->get();

DISTINCT and get all
use Illuminate\Support\Facades\DB;
$all_data = Student::select('*')
->whereIn('id', function ($query) {
    $query->select(DB::raw('max(id)'))->from('students')->groupBy('mobile');
})
->get();
          
NOTIFICATION
$notification = array(
            'message' => '_____',
            'alert-type' => 'success'
          );
return back()->with->($notification);          
          
---------------------------------------------------------------------------  
SESSION          
---------------------------------------------------------------------------
public function english(){
  Session::get('lang');
  session()->forget('lang');
  session()->put('lang','english');
  return back();
}
            
---------------------------------------------------------------------------        
CHECK          
---------------------------------------------------------------------------
public function test($course_id,$chapter_id){ 
    $questions = Question::select('*')->where('course_id',$course_id)->where('chapter_id',$chapter_id)->get();
    foreach($questions as $question){
        if(!is_null($question->id)){
            return view('student.exam.test',compact('questions'));
        }
    }
    return redirect()->back()->with('delete', 'No MCQ available NOW.');
}

if(auth()->check()){}
          
---------------------------------------------------------------------------
ONE FILED STATIC ONE FILED DYNAMIC          
---------------------------------------------------------------------------
<form method="POST" action="{{ route('products.store') }}">
    @csrf
    <div class="form-group">
        <label for="product_name">Product Name</label>
        <input type="text" name="product_name" id="product_name" class="form-control" required>
    </div>
    
    <div class="form-group">
        <label for="prices">Prices</label>
        @for ($i = 0; $i < 5; $i++)
            <input type="text" name="prices[]" class="form-control" required>
        @endfor
    </div>

<button type="submit" class="btn btn-primary">Submit</button>
</form>

public function store(Request $request)
{
    // Create a new product
    $product = new Product();
    $product->name = $request->input('product_name');
    $product->save();

// Attach prices to the product
    foreach ($request->input('prices') as $price) {
        $product->prices()->create(['value' => $price]);
    }
    return redirect()->route('products.index')->with('success', 'Product created successfully.');
}