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
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Sitaare Zameen Par Full Movie Review
     Here’s a  complete Vue.js tutorial for beginners to master level , structured in a progressive and simple way. It covers all essential topi...
  • AI foot tracking model
    I am a student doing a graduation project. I urgently need to deal with this model (I am attaching a link). I've never worked with pytho...
  • Laravel Search String
      Laravel Search String is a package by   Loris Leiva   that generates database queries based on one unique string using a simple and custom...
  • Writing and debugging Eloquent queries with Tinkerwell
    In this article, let's look into the options that you can use with Tinkerwell to write and debug Eloquent queries easier. The post Wr...
  • The token request was rejected by the remote server
    error:invalid_granterror_description:The token request was rejected by the remote server.error_uri: https://documentation.openiddict.com/err...

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 (69)
  • 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

  • July (4)
  • 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)

Loading...

Laravel News

Loading...

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