Introduction

A fully automated CRUD system with AJAX & tailwind css that seamlessly detects database columns and their requirements, generating corresponding tags for swift implementation. It also Search and Pagination Featured

The system generated every entry, be it table names, column names, or even relational data dynamically. The system uses various SQL queries to fetch data about the table in question, such as the number of columns, names of the columns, type constraints, foreign key constraints, record values and so on to seamlessly generate dynamic rows and columns for each DB entity. It also uses a bunch of keywords and cases from the table_alias.php file to identify the datatype of the columns from the database and generate corresponding input types in Insert as well as Edit forms. The code uses a variety of reusable functions from the table_fuctions.php. file to perform every task. It can be even said that the table_functions.php is the system's backbone.

To be able to make this system your own, read carefully the comments of table_alias.php and adjust the keyword according to your own needs.

Getting Started

Installation

To seamlessly integrate the AutoCRUD system into your project, follow these simple installation steps:

Download Source Code:

Visit the GitHub repository at AutoCRUD and download the source code.

Integration:

Integrate the downloaded source code into your project's admin panel.

Setup

Configure AutoCRUD to align with your project requirements by following these setup instructions:

Edit config.php:

Locate the config.php file and update the following values:
• Username
• Password
• Database name
• Server name

Customize table_alias.php:

Locate the config.php file and update the following values:
• Open the table_alias.php file.
• Navigate to the $columnAliases array.
• Create a switch case for every table in your database.
• Beneath each case, assign an associative array to $columnAliases, mapping original attribute names in the table to preferred display names.

Customize $tableAliases array:

Store the display name of the tables in the similar fashion.\

Customize $foreignKey array:

Stores the primary keys of the tables that are acting as foreign keys in the corresponding table case.

Customize $categoryColumnList array:

Store the column of the related table that is to fetched using the foreign key. For example, category_name is fetched using the foreign key category_id from the table item_category.