CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

09 January, 2021

Insert Data In Database by laravel FrameWork

 Programing Coderfunda     January 09, 2021     Laravel     No comments   

<?php 
    <!-- Insert Data In Database by laravel FrameWork -->

    These Are given step : how to insert data in database laravel smart

    1. // Create databse in Mysql 
    2. // Create Model in Laravel
    3. // Create Controller in laravel 
    4. // Create View page in laravel
    5. // Create Route 
    6. // Edit
    7. // Delte 

    NOte: Edit section value change pls use mind and complet this is only
        for example .

    
    ** Note ** // Create Same Name Model & Databse Name Like this way
            
        Databse Name : Coursepages //

    1. //  DataBase Field Name 
                = $DataBaseFieldName['course_id'];
                = $DataBaseFieldName['start_date'];
                = $DataBaseFieldName['end_date'];
                = $DataBaseFieldName['duration'];
                = $DataBaseFieldName['instructor_id'];
                = $DataBaseFieldName['total_course_time'];

    2. // Create Model Name ;
        <?php

        namespace App;
        
        use Illuminate\Database\Eloquent\Model;
        
        class Coursepage extends Model
        {
            //
        }
        
        ?>
    
    3.// Create Controller 
    <?php
    namespace App\Http\Controllers;
    use App\Coursepage;

    class CoursepageController extends Controller
    {
        public function add(Request $request){

            if($request->isMethod('post')){
                $data = $request->all();

                    $validatedData = $request->validate 
                    ([
                        'course_id'=>'required|max:90|min:2',
                    ]);

                    $course_page_data                           = new Coursepage;
                    $course_page_data->course_id                = $data['course_id']; //index page value
                    $course_page_data->start_date               = $data['start_date'];
                    $course_page_data->end_date                 = $data['end_date'];
                    $course_page_data->duration                 = $data['duration'];
                    $course_page_data->instructor_id            = $data['instructor_id'];
                    $course_page_data->total_course_time        = $data['total_course_time'];
                    $course_page_data->save();
                if($course_page_data->save())
                {
                    return redirect('/course-page')->with('success','Course Page added successfully');
                }
                else
                {
                    return redirect('/course-page')->with('errors',COMMON_ERROR);
                }
            }    
                $page = 'Add Course Page';
                return view('admin.coursepage.insert',compact('page')); 
        }
    }

    ?>


    4. // Create View page

            <form action="{{ route('coursepage.insert') }}" method="post" 
                    enctype="multipart/form-data">

                <input type="text"  name="course_id" >
                <input type="text"  name="start_date ">
                <input type="text"  name="end_date  ">
                <input type="text"  name="duration ">
                <input type="text"  name=" instructor_id">
                <input type="text"  name="total_course_time  ">
                <input type="submit"  value="submit">
                
            </form>

    5. // Route page
        Route::get('/coursepage','CoursepageController@index');
        Route::post('/data/cuisines','CoursepageController@cuisinesList');
        Route::match(['get','post'],'/coursepage/add','CoursepageController@add');
        Route::match(['get','post'],'/coursepage/edit/{Coursepage}','CoursepageController@edit');

        //soft-delete of cusisine
        Route::match(['get','post'],'/coursepage/delete/{Coursepage}','CoursepageController@delete');


    6. public function edit(Request $request,$Coursepage)
        {
            $cuisine_detail = Coursepage::where('id',$Coursepage)->first();
            if ($request->isMethod('post')){
                $data = $request->all();
                $this->validate($request,[
                    'name'=>'required|max:20|min:3',
                ]);          
                $cuisine_detail->name    = $data['name'];

                if ($cuisine_detail->save()) {
                    return redirect('/admin/cuisines')->with('success', 'Course Updated');
                }else{
                    return redirect()->back()->with('errors',COMMON_ERROR);
                }
            }
            $page = 'cuisines';
            return view('backEnd.contentManagement.cuisines.form', 
                        compact('page','cuisine_detail','Coursepage'));
        }

    7.
     public function delete($Coursepage)
        {
            $del = Coursepage::where('id',$Coursepage)
                            ->update(['deleted_at'=> date('Y-m-d h:i:s')]);
            if ($del)
                {
                    return redirect()->back()->with('success', 'Coursepage deleted');
                }
                else
                {
                    return redirect()->back()->with('errors',COMMON_ERROR);
                }
        }




  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • Laravel if elseon join “laravel if elseon join” Coderfunda Code Answerlaravel if elseon join01md asif… Read More
  • Left join laravel “left join laravel” Coderfunda Code Answer’slaravel join231Inner Join : ->join('contacts', 'users.id', '=', 'contacts.user_id')2Left Jo… Read More
  • Select selected fields in laravel join“select selected fields in laravel join” Coderfunda Code Answerselect selected fields in laravel join11->select('accounts.*', 'users.id as uid… Read More
  • How to add a additional condition in a join using query builder laravel 5.3? “How to add a additional condition in a join using query builder laravel 5.3?” Coderfunda Code Answer01->leftJoin('table3 AS c', functio… Read More
  • join in laravel “join in laravel” Coderfunda Code Answer’slaravel join231Inner Join : ->join('contacts', 'users.id', '=', 'contacts.user_id')2Left Join… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh
    I had follow these steps to install an configure firebase to my cordova project for cloud messaging. https://medium.com/@felipepucinelli/how...
  • Spring boot app (error: method getFirst()) failed to run at local machine, but can run on server
    The Spring boot app can run on the online server. Now, we want to replicate the same app at the local machine but the Spring boot jar file f...
  • Step-by-step guide to linking gnuplot to Octave within Virtual Studio Code (VSC)
    I am aware of a number of previous questions (here, here and here for example) pointing out to the need to modify a file named .octaverc. ...
  • Log activity in a Laravel app with Spatie/Laravel-Activitylog
      Requirements This package needs PHP 8.1+ and Laravel 9.0 or higher. The latest version of this package needs PHP 8.2+ and Laravel 8 or hig...
  • SQL Tutorial
    SQL Tutorial SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null V...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh - 9/21/2024
  • pyspark XPath Query Returns Lists Omitting Missing Values Instead of Including None - 9/20/2024
  • SQL REPL from within Python/Sqlalchemy/Psychopg2 - 9/20/2024
  • MySql Explain with Tobias Petry - 9/20/2024
  • How to combine information from different devices into one common abstract virtual disk? [closed] - 9/20/2024

Laravel News

  • Track Metrics Effortlessly with Laravel's Context Increment and Decrement Methods - 5/4/2025
  • NativePHP Hit $100K — And We're Just Getting Started 🚀 - 5/8/2025
  • Name Queued Closures in Laravel 12.13 - 5/9/2025
  • Simplify HasManyThrough Relationships with Laravel's CanBeOneOfMany Support - 5/4/2025
  • Using Database Comments to Track Columns With Sensitive Data - 5/7/2025

Copyright © 2025 CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda