Data Table Inline Editing using jQuery, Ajax, and MySQL in Laravel

This Laravel project demonstrates the implementation of Data Table Inline Editing using jQuery, Ajax, and MySQL. The application provides functionalities such as Add, Update, Delete, Inline Edit, Bulk Delete, and more.

Table of Contents

• Features
• Requirements
• Installation
• Usage
• Screenshots
• Contributing
• License

Features

1. Add / Update / Delete Operations: Perform CRUD operations on the data table.
2. Inline Edit: Edit data directly within the table row using Ajax.
3. Delete Confirmation: Confirm before deleting a particular row's data using Ajax.
4. Bulk Delete: Delete selected rows with confirmation using Ajax.
5. Add New Member: Hide the current table and show an add form using Ajax.
6. Category Dropdown: Populate categories from the category table.
7. Save Button: Hide the current form and show the table on Save using Ajax.

Requirements

PHP: Version 7.2 or higher is required for running the Laravel application. Composer: Composer is used for managing PHP dependencies in the project. Laravel: The project is built on Laravel framework version 8 or higher. MySQL Database: Laravel typically uses MySQL as the default database system. Web Server (e.g., Apache, Nginx): A web server is required to serve the Laravel application.

Installation

1. Clone the repository:

   git clone https://github.com/Sapansathawara/data_table_inline_editing_using_jQuery_ajax_and_mysql_in_laravel.git

2. Navigate to the project directory:

   cd data_table_inline_editing_using_jQuery_ajax_and_mysql_in_laravel

3. Install dependencies:

   composer install

4. Copy the .env.example file to .env and configure your database:

   cp .env.example .env

5. Generate application key:

   php artisan key:generate

6. Run database migrations and seed:

   php artisan migrate --seed

Usage

1. Start the Laravel development server:

   php artisan serve

2. Visit http://localhost:8000 in your web browser.

Screenshots

Listing

Add New Member

Inline Edit

Contributing

Contributions are welcome! If you have any suggestions, improvements, or issues, please open an issue or submit a pull request.

License

This project is licensed under the MIT License.