How to add product add, update, edit, delete in Laravel with product table?

-

The process of creating a basic CRUD (Create, Read, Update, Delete) functionality for a product table in Laravel. First, make sure you have Laravel installed on your system.

Step 1: Database Setup

Create a migration for the product table:

bash code

php artisan make:migration create_products_table

Edit the generated migration file to define the columns of your products table. Then, run the migration:

bash code

php artisan migrate

Step 2: Model

Create a model for the Product:

bash code

php artisan make:model Product

Step 3: Routes

Define your routes in web.php:

php code

Route::resource('products', 'ProductController');

Step 4: Controller

Create a controller for the Product:

bash code

php artisan make:controller ProductController

In the ProductController, you can define methods for the CRUD operations:

php code

<?php

namespace App\Http\Controllers;

use App\Product;

use Illuminate\Http\Request;

class ProductController extends Controller

{

    public function index()

    {

        $products = Product::all();

        return view('products.index', compact('products'));

    }

    public function create()

    {

        return view('products.create');

    }

    public function store(Request $request)

    {

        $product = new Product();

        $product->name = $request->input('name');

        $product->description = $request->input('description');

        // Set other fields as needed

        $product->save();

        return redirect()->route('products.index')->with('success', 'Product created successfully.');

    }

    public function edit($id)

    {

        $product = Product::find($id);

        return view('products.edit', compact('product'));

    }

    public function update(Request $request, $id)

    {

        $product = Product::find($id);

        $product->name = $request->input('name');

        $product->description = $request->input('description');

        // Update other fields as needed

        $product->save();

        return redirect()->route('products.index')->with('success', 'Product updated successfully.');

    }

    public function destroy($id)

    {

        $product = Product::find($id);

        $product->delete();

        return redirect()->route('products.index')->with('success', 'Product deleted successfully.');

    }

}

Step 5: Views

Create the necessary views inside the resources/views/products directory: index.blade.php, create.blade.php, edit.blade.php.

index.blade.php

php

Copy code

@extends('layouts.app')

@section('content')

    <h1>Products</h1>

    <a href="{{ route('products.create') }}" class="btn btn-primary">Add Product</a>

    <table class="table">

        <thead>

            <tr>

                <th>Name</th>

                <th>Description</th>

                <th>Actions</th>

            </tr>

        </thead>

        <tbody>

            @foreach($products as $product)

                <tr>

                    <td>{{ $product->name }}</td>

                    <td>{{ $product->description }}</td>

                    <td>

                        <a href="{{ route('products.edit', $product->id) }}" class="btn btn-warning">Edit</a>

                        <form action="{{ route('products.destroy', $product->id) }}" method="POST" style="display:inline;">

                            @csrf

                            @method('DELETE')

                            <button type="submit" class="btn btn-danger" onclick="return confirm('Are you sure you want to delete this product?')">Delete</button>

                        </form>

                    </td>

                </tr>

            @endforeach

        </tbody>

    </table>

@endsection

create.blade.php

php code

@extends('layouts.app')

@section('content')

    <h1>Create Product</h1>

    <form action="{{ route('products.store') }}" method="POST">

        @csrf

        <div class="form-group">

            <label for="name">Product Name:</label>

            <input type="text" class="form-control" id="name" name="name" required>

        </div>

        <div class="form-group">

            <label for="description">Description:</label>

            <textarea class="form-control" id="description" name="description" required></textarea>

        </div>

        <!-- Add other fields as needed -->

        <button type="submit" class="btn btn-primary">Create Product</button>

    </form>

@endsection

edit.blade.php

php code

@extends('layouts.app')

@section('content')

    <h1>Edit Product</h1>

    <form action="{{ route('products.update', $product->id) }}" method="POST">

        @csrf

        @method('PUT')

        <div class="form-group">

            <label for="name">Product Name:</label>

            <input type="text" class="form-control" id="name" name="name" value="{{ $product->name }}" required>

        </div>

        <div class="form-group">

            <label for="description">Description:</label>

            <textarea class="form-control" id="description" name="description" required>{{ $product->description }}</textarea>

        </div>

        <!-- Add other fields as needed -->

        <button type="submit" class="btn btn-primary">Update Product</button>

    </form>

@endsection

Make sure to have appropriate styles and scripts in your layout file (layouts/app.blade.php).

That's it! You now have a basic CRUD functionality for a product table in Laravel. Customize the code as per your requirements.

Comments

Post a Comment

Popular posts from this blog

Shopping cart in PHP

-
 Creating a simple shopping cart in PHP involves several steps. In this example, I'll provide a basic outline of how you can implement a shopping cart functionality. Please note that this is a simplified example, and in a real-world scenario, you'd need to consider more advanced features like user authentication, product management, and secure payment processing. Here's a step-by-step guide to create a basic shopping cart in PHP: Set up your environment: Make sure you have a web server (e.g., Apache) and PHP installed on your machine or hosting server. Create a database (optional): If you want to store product information, you can set up a database and create a table to store product details. For this example, we'll assume you have a "products" table with fields like id, name, price, and description. Create the HTML and PHP files: index.php (Main page to display products): html code <!DOCTYPE html> <html> <head>     <title>Simple Shoppi...
Read more

What are the different ways of handling the result set of MySQL in PHP?

-
 In PHP, you can handle the result set of MySQL in several ways, depending on your specific requirements. Here are some common methods to handle MySQL result sets in PHP: 1. Using mysql_fetch_array() , mysql_fetch_assoc() , or mysql_fetch_object() (deprecated, removed in PHP 7.0) These functions were used to fetch rows from a MySQL result set as an array, associative array, or object, respectively. However, they have been deprecated as of PHP 5.5 and removed in PHP 7.0. It is not recommended to use them in modern PHP applications. Example (deprecated method - not recommended for use in PHP 7.0 and later): php code $result = mysql_query("SELECT * FROM table"); while ($row = mysql_fetch_assoc($result)) {     echo $row['column_name']; } 2. Using mysqli_fetch_array() , mysqli_fetch_assoc() , or mysqli_fetch_object() (MySQLi Extension) MySQLi (MySQL Improved) extension is the improved version of the MySQL extension and provides an object-oriented and procedural A...
Read more

Google pagination in PHP

-
To implement Google-style pagination in PHP, you need to understand the basic concept of pagination. Pagination is the process of dividing a large set of data into smaller, more manageable chunks or "pages." In the context of a PHP web application, this often involves querying a database and displaying a limited number of records per page. Here's a step-by-step guide on how to implement Google-style pagination in PHP: Database Setup : First, make sure you have a database with the data you want to paginate. In this example, we'll assume you have a MySQL database. HTML Structure : Create an HTML structure for displaying the paginated data on your web page. You'll typically have a list of items (e.g., search results) and navigation links for the pages. html code <!DOCTYPE html> <html> <head>     <title>Google-style Pagination</title> </head> <body>     <h1>Search Results</h1>     <ul>     ...
Read more

PHP admin panel with class

-
 Creating a PHP admin panel with classes can help you structure your code in a more organized and maintainable way. Below, I'll provide a basic example of how you can create a simple admin panel using PHP classes. This example will include a login system and a basic dashboard. Note: This is a simplified example for demonstration purposes. In a real-world scenario, you should consider using a framework like Laravel or Symfony for more robust and secure admin panels. Create a directory structure: admin/ ├── classes/ │   ├── User.php ├── config.php ├── index.php ├── login.php ├── dashboard.php └── logout.php Create a User class (classes/User.php): php code <?php class User {     private $username;     private $password; public function __construct($username, $password) {         $this->username = $username;         $this->password = $password;     } public function authenticate() {     ...
Read more

Navigating the WordPress dashboard

-
 Navigating the WordPress dashboard is essential for managing your website, creating content, and customizing its appearance and functionality. Here's a step-by-step guide on how to navigate the WordPress dashboard: Log In : To access the WordPress dashboard, you first need to log in. Open your web browser and enter your website's URL followed by "/wp-admin" (e.g., www.yourwebsite.com/wp-admin). You will be prompted to enter your username and password. Dashboard Overview: Once logged in, you'll land on the WordPress dashboard. The dashboard is the control center for your website, providing access to various tools and features. Admin Bar : At the top of the screen, you'll see the admin bar. This bar provides quick access to essential features, such as adding new posts or pages, editing your profile, or viewing your site. It also displays notifications and updates. Sidebar Menu: On the left side of the dashboard is the sidebar menu. This is where you'll find...
Read more