This will cover
1. Get email from user
2. save them to database
3. Able to edit in admin panel<\/p>\r\n
1. Create Table email_alerts_vehicles_data_table<\/strong><\/p>\r\n 2. Create A input form to show on front end <\/strong><\/p>\r\n 3. Create A route to show form that accept input values ie email<\/strong><\/p>\r\n 4. Make model that is use to insert and retrive data from database , also add below two lines 5. Add new method in controller to handle it<\/strong><\/p>\r\n Now data will be inserted to DB<\/p>\r\n 6. Now if you want to update it add below code ie in admin panel<\/strong><\/p>\r\n 7.Admin panel view<\/strong><\/p>\r\n note: add update_profile route and use this method update_profile<\/p>\r\n <\/p>","category_id":"4","is_private":"0","created_at":"2023-03-20T11:58:33.000000Z","updated_at":"2023-03-20T11:58:33.000000Z","category":{"id":4,"user_id":"2","name":"Laravel","slug":"laravel-nmib","parent_id":"3","created_at":"2023-03-15T02:49:42.000000Z","updated_at":"2023-03-15T02:49:42.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"This will cover1. Get email from user2. save them to database 3. Able to edit in admin panel 1. Create Table email_alerts_vehicles_data_tabl - Email alerts subscription laravel 10 (Updated: March 20, 2023) - Read more about Email alerts subscription laravel 10 at my programming site [SITE]","categories":[]}DROP TABLE IF EXISTS `email_alerts`;\r\nCREATE TABLE `email_alerts` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `user_id` bigint(20) unsigned DEFAULT NULL,\r\n `email` varchar(255) DEFAULT NULL,\r\n `alert_status` varchar(255) DEFAULT NULL COMMENT '1,0 for sending emails to only that are 1 ',\r\n `alert_keyword` varchar(255) DEFAULT NULL,\r\n `zip_city_state` varchar(255) DEFAULT NULL,\r\n `alert_nature` varchar(255) DEFAULT NULL COMMENT 'daily, weekly, monthly',\r\n `created_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),\r\n `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),\r\n PRIMARY KEY (`id`),\r\n KEY `user_id` (`user_id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;<\/code><\/pre>\r\n<div class=\"email_subs mt-3\">\r\n @if(session('success'))\r\n <div class=\"alert alert-success\"> {{ session('success') }} <\/div>\r\n @endif\r\n <form method=\"POST\" action=\"{{route('subscription_submit')}}\"> \r\n @csrf\r\n <input type=\"email\" placeholder=\"Enter email\" name=\"email\">\r\n <button type=\"submit\">\r\n Subscribe\r\n <\/button>\r\n <\/form>\r\n<\/div> <!-- email_subs end --><\/code><\/pre>\r\nRoute::post('subscription_submit',[App\\Http\\Controllers\\HomeController::class,'subscription_submit'])->name('subscription_submit');<\/code><\/pre>\r\n
php artisan make:model Email_alerts <\/strong><\/p>\r\nprotected $guarded = [];\r\nprotected $table = 'email_alerts'; \/\/custom table name<\/code><\/pre>\r\nuse App\\Models\\Email_alerts;\r\npublic function subscription_submit(Request $request){\r\n $validated = $request->validate([\r\n 'email' => 'required',\r\n ]);\r\n\r\n \/\/ check if already email exists \r\n $record = Email_alerts::where('email', $request->email)->first();\r\n if(is_null($record)){\r\n if(auth()->user()){\r\n $emailis = auth()->user()->email;\r\n $user_id = auth()->user()->id;\r\n }else{\r\n $emailis = $request->email;\r\n $user_id=NULL;\r\n }\r\n\r\n $insert = Email_alerts::create([\r\n 'email' => $emailis, \r\n 'user_id' => auth()->user()->id,\r\n 'alert_status' =>1,\r\n 'alert_nature'=>'daily'\r\n ]);\r\n return redirect()->back()\r\n ->with('success', 'Email Subscription Success.');\r\n }\r\n return redirect()->back();\r\n }<\/code><\/pre>\r\npublic function index(){\r\n $user = User::with('has_email_alert')\r\n ->find(auth()->id());\r\n}\r\npublic function update_profile(Request $request){ \/\/used when user click on update\r\n $update_user = \\App\\Models\\Email_alerts::where('user_id', auth()->id())\r\n ->where(\"id\", $request->has_email_alert_id)\r\n ->update(['alert_status' => $request->email_alert]);\r\n return redirect()->route('profile');\r\n }\r\n<\/code><\/pre>\r\n@if(!empty($user->has_email_alert))\r\n <input type=\"hidden\" name=\"has_email_alert_id\" value=\"{{ $user->has_email_alert->id }}\">\r\n <input type=\"checkbox\" name=\"email_alert\" @if($user->has_vehcicle_alert->alert_status) checked=\"true\" @endif>\r\n <button type=\"submit\">Update<\/button>\r\n@endif<\/code><\/pre>\r\n