We are creating a controller that will fetch all data of table.
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
public function index()
{
$data = DB::table('employee')->get();
echo "<pre>";
print_r($data->toArray());
}
}
We creating controller that allow us to perform all crud operation on account or profile.
<?php
namespace App\Http\Controllers;
use App\Http\Requests\ProfileUpdateRequest;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Redirect;
use Illuminate\View\View;
class ProfileController extends Controller
{
/**
* Display the user's profile form.
*/
public function edit(Request $request): View
{
return view('profile.edit', [
'user' => $request->user(),
]);
}
/**
* Update the user's profile information.
*/
public function update(ProfileUpdateRequest $request): RedirectResponse
{
$request->user()->fill($request->validated());
if ($request->user()->isDirty('email')) {
$request->user()->email_verified_at = null;
}
$request->user()->save();
return Redirect::route('profile.edit')->with('status', 'profile-updated');
}
/**
* Delete the user's account.
*/
public function destroy(Request $request): RedirectResponse
{
$request->validateWithBag('userDeletion', [
'password' => ['required', 'current_password'],
]);
$user = $request->user();
Auth::logout();
$user->delete();
$request->session()->invalidate();
$request->session()->regenerateToken();
return Redirect::to('/');
}
}
We creating a controller that will fetch or get data from table where address is india.
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class Query_Controller extends Controller
{
public function index()
{
$data = DB::table('employee')->where('address', 'india')->get();
echo "<pre>";
print_r($data->toArray());
}
}
We creating a controller that will return string data.
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class Home_Controller extends Controller
{
public function index($value='')
{
return "Wellcome to Home Controller <br>Value is :".$value;
}
public function show($value='')
{
return "Wellcome to Home Controller <br>Value is :".$value;
}
public function edit($value='')
{
return "Wellcome to Home Controller <br>Value is :".$value;
}
}
We creating a controller that will load view with data
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class View_Load_Controller extends Controller
{
public function index($value='')
{
return view('load_view_page')->with(['value'=>$value]);
}
}