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

17 May, 2022

In Laravel 9, how to insert data into a database [closed]

 Programing Coderfunda     May 17, 2022     Laravel, php     No comments   

 

In Laravel 9, how to insert data into a database [closed]





Q

I am working with Laravel 9. I am trying to insert data into database. It is not user data, data will be inserted into database on form submit button.

My view:

    <form action="{{ route('store.category') }}" method="POST">
    @csrf
    <div class="mb-3">
    <label for="categoryName" class="form-label">Category Name</label>
    <input type="text" class="form-control" id="category_name" placeholder="Enter Category Name">
    @error('category_name')
    <span class="text-danger">{{ $message }}</span>
    @enderror
    </div>
    <button type="submit" style="float: right;" class="btn form-control btn-primary">Add</button>
    </form>

My web.php:

Route::post('/category/add', [CategoryController::class, 'AddCat'])->name('store.category');

My model

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Category extends Model
{
protected $table = 'categories';
use SoftDeletes;
protected $fillable = [
    'user_id',
    'category_name'
];

} My table migration:

public function up()
{
    Schema::create('categories', function (Blueprint $table) {
        $table->id();
        $table->integer('user_id');
        $table->string('category_name');
        $table->timestamps();
        $table->SoftDeletes();
    });
}

My controller:

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Category;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;

class CategoryController extends Controller

{

public function AddCat(Request $request)
{
    $validated = $request->validate([
        'category_name' => 'required|unique:categories|max:255',
    ]);

First i tried this

    $category = Category::create([
        'user_id'       => Auth::user()->id,
        'category_name' => $request->category_name,
    ]);
    $category->save();

Then this

    $category = new Category;
    $category->user_id = Auth::user()->id;
    $category->category_name = $request->category_name;
    $category->save();

Then this

    $user_id = Auth::user()->id;
    $category_name = $request->input('category_name');
    $data=array("user_id"=>,"$user_id"=>$category_name);
    DB::table('categories')->insert($data);
}

}

But the data not inserting into database. The command is showing the below every time the form is submitted

[Fri May 13 20:06:36 2022] 127.0.0.1:8821 Accepted
[Fri May 13 20:06:36 2022] 127.0.0.1:8821 Closing
[Fri May 13 20:06:36 2022] 127.0.0.1:8823 Accepted
[Fri May 13 20:06:37 2022] 127.0.0.1:8823 Closing
[Fri May 13 20:06:37 2022] 127.0.0.1:8825 Accepted
[Fri May 13 20:06:37 2022] 127.0.0.1:8826 Accepted
[Fri May 13 20:06:37 2022] 127.0.0.1:8827 Accepted
[Fri May 13 20:06:37 2022] 127.0.0.1:8825 [200]: GET /css/app.css
[Fri May 13 20:06:37 2022] 127.0.0.1:8826 [200]: GET /js/app.js
[Fri May 13 20:06:37 2022] 127.0.0.1:8825 Closing
[Fri May 13 20:06:37 2022] 127.0.0.1:8826 Closing
[Fri May 13 20:06:42 2022] 127.0.0.1:8827 Closed without sending a request; it was probably just an unused speculative preconnection
[Fri May 13 20:06:42 2022] 127.0.0.1:8827 Closing

Can someone help me with the solution




Found the answer. The issue created due to my stupidity!

    <input type="text" class="form-control" id="category_name" placeholder="Enter Category Name">

Forgot to put name attribute in the input tag

    <input type="text" class="form-control" name="category_name" id="category_name" placeholder="Enter Category Name">
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • Keep Track of Model Inventory with Laravel Stock Laravel Stock is a package by Appstract for keeping track of inventory counts on models:Keep stock for Eloquent models. This package w… Read More
  • Blade Icons Package Dries Vints has created a new package to easily make use of Hero icons in your Laravel Blade views.By far my most favorite a… Read More
  • Terminal: An Elegant Wrapper around the Symfony Process Component Terminal is a neat PHP package by Titas Gailius that provides a “wrapper around Symfony’s Process component.” It has a fluent interface, wh… Read More
  • Using Google Sheets with Eloquent Eloquent Sheets is a package by Ed Grosvenor that lets you work with Google Sheets via Eloquent models:This package provides an Eloque… Read More
  • Class-Based Factories with Laravel Poser With Laravel Poser, you can “create class-based model factories in Laravel applications in seconds.” This package works by creating factory… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • 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...
  • 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...
  • 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...
  • Laravel auth login with phone or email
          <?php     Laravel auth login with phone or email     <? php     namespace App \ Http \ Controllers \ Auth ;         use ...
  • Cashier package and Blade files
    I'm a little confused about this Cashier package. I installed it using the Laravel website (with composer), but noticed there's no...

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

  • Filter Model Attributes with Laravel's New except() Method - 5/13/2025
  • Arr::from() Method in Laravel 12.14 - 5/14/2025
  • Streamline API Resources with Laravel's Fluent Methods - 5/13/2025
  • Customize URL Handling with Laravel's Macroable URI Class - 5/13/2025
  • Use Passkeys in Your Laravel App - 5/13/2025

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