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

  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • Features CodeIgniter
    Features CodeIgniter There is a great demand for the CodeIgniter framework in PHP developers because of its features and multiple advan...
  • Laravel Breeze with PrimeVue v4
    This is an follow up to my previous post about a "starter kit" I created with Laravel and PrimeVue components. The project has b...
  • Fast Excel Package for Laravel
      Fast Excel is a Laravel package for importing and exporting spreadsheets. It provides an elegant wrapper around Spout —a PHP package to ...
  • Credit card validation in laravel
      Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...

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)

Loading...

Laravel News

Loading...

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