<!DOCTYPE html> <html> <head> <title>Student Management | Edit</title> </head> <body> <form action = "/edit/<?php echo $users[0]->id; ?>" method = "post"> <input type = "hidden" name = "_token" value = "<?php echo csrf_token(); ?>"> <table> <tr> <td>First Name</td> <td> <input type = 'text' name = 'first_name' value = '<?php echo$users[0]->first_name; ?>'/> </td> </tr> <tr> <td>Last Name</td> <td> <input type = 'text' name = 'last_name' value = '<?php echo$users[0]->last_name; ?>'/> </td> </tr> <tr> <td>City Name</td> <td> <input type = 'text' name = 'city_name' value = '<?php echo$users[0]->city_name; ?>'/> </td> </tr> <tr> <td>Email</td> <td> <input type = 'text' name = 'email' value = '<?php echo$users[0]->email; ?>'/> </td> </tr> <tr> <td colspan = '2'> <input type = 'submit' value = "Update student" /> </td> </tr> </table> </form> </body> </html>
StudUpdateController.php
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use DB; use App\Http\Requests; use App\Http\Controllers\Controller; class StudUpdateController extends Controller { public function index(){ $users = DB::select('select * from student'); return view('stud_edit_view',['users'=>$users]); } public function show($id) { $users = DB::select('select * from student where id = ?',[$id]); return view('stud_update',['users'=>$users]); } public function edit(Request $request,$id) { $first_name = $request->input('first_name'); $last_name = $request->input('last_name'); $city_name = $request->input('city_name'); $email = $request->input('email'); //$data=array('first_name'=>$first_name,"last_name"=>$last_name,"city_name"=>$city_name,"email"=>$email); //DB::table('student')->update($data); // DB::table('student')->whereIn('id', $id)->update($request->all()); DB::update('update student set first_name = ?,last_name=?,city_name=?,email=? where id = ?',[$first_name,$last_name,$city_name,$email,$id]); echo "Record updated successfully. "; echo 'Click Here to go back.'; } }
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('edit-records','StudUpdateController@index'); Route::get('edit/{id}','StudUpdateController@show'); Route::post('edit/{id}','StudUpdateController@edit');
Introduction to PHP CRUD Operations In web development, managing data is a fundamental aspect of creating dynamic and interactive applications. CRUD operations,…