This is simply user management.
The fields are name, email & phone No. I have not given emphasis on design part. You can customize as per your requirement.
So following files are needed.
1. web.php (This is the route)
Path: /Applications/MAMP/htdocs/laravel/routes/web.php
1. UserController.php (This is the controller). path: /Applications/MAMP/htdocs/laravel/app/Http/Controllers/UserController.php
2. User.php (This is the model)
Path: /Applications/MAMP/htdocs/laravel/app/User.php
3. 4 view files
index.blade.php
create.blade.php
edit.blade.php
show.blade.php
Path: /Applications/MAMP/htdocs/laravel/resources/views/index.blade.php /Applications/MAMP/htdocs/laravel/resources/views/create.blade.php /Applications/MAMP/htdocs/laravel/resources/views/edit.blade.php /Applications/MAMP/htdocs/laravel/resources/views/show.blade.php
4. users table. The structure is as follows.
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
web.php
<?php
/*
|————————————————————————–
| Web Routes
|————————————————————————–
|
| Here is where you can register web routes for your application.These
| routes are loaded by the RouteServiceProvider within a group which
| contains the “web” middleware group. Now create something great!
|
*/
Route::get('/', 'UserController@index');
Route::get('user/home', 'UserController@index');
Route::get('user/create', function () {
return view('create');
});
Route::get('user/create/{id}', 'UserController@edit');
Route::post('store', 'UserController@store');
Route::post('update/{id}', 'UserController@update');
Route::get('user/show/{id}', 'UserController@show');
Route::get('user/delete/{id}', 'UserController@destroy');
UserController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\Model;
use App\User;
use DB;
use Illuminate\Support\Facades\Redirect;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$userobj = new User();
$users = $userobj->getusers();
return view('index')->with('users',$users);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('create');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, [
'user_name' => 'required',
'email' => 'required',
'phone' => 'required',
]);
$name = $request->input('user_name');
$email = $request->input('email');
$phone = $request->input('phone');
DB::table('users')->insert(
['name' => $name, 'email' => $email, 'phone' => $phone]);
return redirect('user/home')->with('status', 'Record inserted successfully!');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$user = User::find($id);
return view('show', compact('user'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$user= User::find($id);
return view('edit',compact('user'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
DB::table('users')
->where('id', $id);
$this->validate($request, [
'user_name' => 'required',
'email' => 'required',
'phone' => 'required',
]);
$name = $request->input('user_name');
$email = $request->input('email');
$phone = $request->input('phone');
DB::table('users')
->where('id', $id)
->update(['name' => $name,'email'=>$email,'phone' => $phone]);
return redirect('user/home')->with('status', 'Updated successfully!');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$user = User::find($id);
$user->delete();
return redirect('user/home')->with('status', 'deleted successfully!');
}
}
User.php
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
class User extends Model
{
protected $table="users";
public function getusers(){
//$users = DB::select('SELECT * FROM users');
//$users = DB::table('users')->get();
$users = User::all();//User is the model here
return $users;
}
}
index.blade.php
<html>
<a href="{{ url('/') }}/user/create">Add New</a>
@if (session('status'))
<div class="alert" style="color: blue;">
{{ session('status') }}
</div>
@endif
<table border="1">
<tr>
</tr>
<tr>
<th>Sl No</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Action</th>
</tr>
@foreach($users as $key=>$user)
<tr>
<td>{{$key+1}}</td>
<td>{{$user->name}}</td>
<td>{{$user->email}}</td>
<td>{{$user->phone}}</td>
<td><a href="{{ url('/') }}/user/create/{{$user->id}}">Edit</a> | <a href="{{ url('/') }}/user/show/{{$user->id}}">Show</a>| <a href="{{ url('/') }}/user/delete/{{$user->id}}">Delete</a></td>
</tr>
@endforeach
</table>
</html>
create.blade.php
<html>
<head>
<title>User Management</title>
</head>
<body>
<form action = "/store" method = "post">
<input type = "hidden" name = "_token" value = "<?php echo csrf_token(); ?>">
<table>
<tr>
<td>Name</td>
<td><input type='text' name='user_name' /></td>
</tr>
<tr>
<td>Email</td>
<td><input type='text' name='email' /></td>
</tr>
<tr>
<td>Phone</td>
<td><input type='text' name='phone' /></td>
</tr>
<tr>
<td colspan = '2'>
<input type = 'submit' value = "Add user"/>
</td>
</tr>
</table>
</form>
</body>
</html>
edit.blade.php
<html>
<head>
<title>User Management</title>
</head>
<body>
<form action = "/update/{{$user->id}}" method = "post">
<input type = "hidden" name = "_token" value = "<?php echo csrf_token(); ?>">
<table>
<tr>
<td>Name</td>
<td><input type='text' name='user_name' value="{{$user->name}}" /></td>
</tr>
<tr>
<td>Email</td>
<td><input type='text' name='email' value="{{$user->email}}"/></td>
</tr>
<tr>
<td>Phone</td>
<td><input type='text' name='phone' value="{{$user->phone}}"/></td>
</tr>
<tr>
<td colspan = '2'>
<input type = 'submit' value = "Update user"/>
</td>
</tr>
</table>
</form>
</body>
</html>
show.blade.php
<html>
<a href="{{ url('/') }}">Back</a>
<div>
<div>Name:{{$user->name}}</div>
<div>Email:{{$user->email}}</div>
<div>Phone:{{$user->phone}}</div>
</div>
</html>
The home screen is like as follows
It’s showing all the records from users table. By clicking on add new you can add new records. And there is options for edit record, view record & delete record.
Add New Page
Edit Page
Show Page
Delete Record
After clicking on delete link of any record the message will show as below.
