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

How to insert data in database - Laravel

 Programing Coderfunda     January 09, 2021     Laravel     No comments   

 

        How to insert data in database - Laravel
        Insert Data In Data Base Laravel 

        We going to show you that how to insert data in database - Laravel

        These Are given steps you follow and complete your task .

        1st we create a table in databse

        The INSERT INTO statement is used to insert new data to a MySQL table:

        INSERT INTO table_name (column1, column2, column3,...)
        VALUES (value1, value2, value3,...)
        To learn more about SQL, please visit our SQL tutorial.

        For creating table the SQL query is:

        SQL Query
        CREATE TABLE student_details
        (
        id int NOT NULL AUTO_INCREMENT,
        first_name varchar(50),
        last_name varchar(50),
        city_name varchar(50),
        email varchar(50),
        PRIMARY KEY (id)
        );

        Create 3 files for insert data in Laravel :

        StudInsertController.php (app/Http/Controllers/StudInsertController.php)
        stud_create.php (resources/views/stud_create.php)
        web.php (routes/web.php)
        stud_create.blade.php(View File)

        <!DOCTYPE html>
        <html>
        <head>
        <title>Student Management | Add</title>
        </head>
        <body>
        @if (session('status'))
        <div class="alert alert-success" role="alert">
            <button type="button" class="close" data-dismiss="alert">×</button>
            {{ session('status') }}
        </div>
        @elseif(session('failed'))
        <div class="alert alert-danger" role="alert">
            <button type="button" class="close" data-dismiss="alert">×</button>
            {{ session('failed') }}
        </div>
        @endif
        <form action = "/create" 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' /></td>
            <tr>
            <td>Last Name</td>
            <td><input type="text" name='last_name'/></td>
            </tr>
            <tr>
            <td>City Name</td>
            <td>
            <select name="city_name">
            <option value="bbsr">Bhubaneswar</option>
            <option value="cuttack">Cuttack</option>
            </select></td>
            </tr>
            <tr>
            <td>Email</td>
            <td><input type="text" name='email'/></td>
            </tr>

            <tr>
            <td colspan = '2'>
            <input type = 'submit' value = "Add student"/>
            </td>
            </tr>
            </table>
        </form>
        </body>
        </html>


        <!-- StudInsertController.php(Controller File) -->

        <?php
        namespace App\Http\Controllers;
        use App\StudInsert;
        use Illuminate\Http\Request;
        use \Illuminate\Http\Response;
        use Illuminate\Support\Facades\Validator;
        use Illuminate\Validation\Rule;

        class StudInsertController extends Controller
        {
            
            public function insert(){
                $urlData = getURLList();
                return view('stud_create');
            }
            public function create(Request $request){
                $rules = [
                    'first_name' => 'required|string|min:3|max:255',
                    'city_name' => 'required|string|min:3|max:255',
                    'email' => 'required|string|email|max:255'
                ];
                $validator = Validator::make($request->all(),$rules);
                if ($validator->fails()) {
                    return redirect('insert')
                    ->withInput()
                    ->withErrors($validator);
                }
                else{
                    $data = $request->input();
                    try{
                        $student = new StudInsert;
                        $student->first_name = $data['first_name'];
                        $student->last_name = $data['last_name'];
                        $student->city_name = $data['city_name'];
                        $student->email = $data['email'];
                        $student->save();
                        return redirect('insert')->with('status',"Insert successfully");
                    }
                    catch(Exception $e){
                        return redirect('insert')->with('failed',"operation failed");
                    }
                }
            }
        }
        StudInsert.php(Model File)
        <?php
        namespace App;

        use Illuminate\Database\Eloquent\Model;

        class StudInsert extends Model
        {
            protected $table = 'student_details';
            public $timestamps = true;
            /**
             * The attributes that are mass assignable.
             *
             * @var array
             */
            protected $fillable = [
                'first_name', 'last_name','city_name', 'email',
            ];
        }
        web.php
        <?php
        /*
        |--------------------------------------------------------------------------
        | Web Routes
        |--------------------------------------------------------------------------
        |
        | You visit web page and past this route code.
        |
        */
        //insert data
        Route::get('insert','StudInsertController@insertform');
        Route::post('create','StudInsertController@insert');
  • 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

  • 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...
  • 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...
  • 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...
  • Vue.js Tutorial
      Vue.js Installation Compatibility Check Before going to install and use Vue.js in your project, you should check the compatibility issues....
  • JqueryUI Tutorial
    JqueryUI Tutorial    JqueryUI is the most popular front end frameworks currently. It is sleek, intuitive, and powerful mobile first fr...

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