Php mysql crud generator

CRUD Generator

You are here in the PHP CRUD generator, which allows you to generate your Bootstrap admin panel from any MySQL/MariaDB, Oracle, PostgreSQL, Firebird database in a few clicks.

1. Select the table that you want to add in your admin panel.
2. To create your CRUD pages, click one of the 3 big buttons:

Switch to the CRUD Generator Switch to the Admin Dashboard

All the CRUD operations are disabled in this demo.

PHP CRUD Generator — Configuration

The Configuration form is disabled in this demo.

PHP CRUD Generator — Compare files

The file comparison tool is disabled in this demo.

PHP CRUD Generator — Authentication module

The user authentication module is disabled

getTables => Get tables from DB

getTables => generator default table = actor

getDbColumns

registerColumnsProperties => From JSON : sakila/actor.json

Table	Column	Referenced table	Referenced column
address	city_id	city	city_id
city	country_id	country	country_id
customer	address_id	address	address_id
customer	store_id	store	store_id
film	language_id	language	language_id
film	original_language_id	language	language_id
film_actor	actor_id	actor	actor_id
film_actor	film_id	film	film_id
film_category	category_id	category	category_id
film_category	film_id	film	film_id
inventory	film_id	film	film_id
inventory	store_id	store	store_id
payment	customer_id	customer	customer_id
payment	rental_id	rental	rental_id
payment	staff_id	staff	staff_id
phpcg_users	profiles_id	phpcg_users_profiles	id
rental	customer_id	customer	customer_id
rental	inventory_id	inventory	inventory_id
rental	staff_id	staff	staff_id
staff	address_id	address	address_id
staff	store_id	store	store_id
store	address_id	address	address_id
store	manager_staff_id	staff	staff_id

Источник

CRUD Admin Generator

Generate a complete backend from a MySql database. In seconds.

The backend is generated in seconds without configuration files, you have total control over the code.
Other tools use configuration files where there is a lot of «magic» and is very difficult to adapt to your needs.

Open Source

The code is hosted on GitHub. Fork it and send us your pull requests.

PHP code

It has been programmed with the Silex framework, so the resulting code is PHP.

CRUD

Generates one menu section for each database table. Now will be much easier to list, create, edit and delete items!

From your existing database

Generate the backend from your existing database.

Download now!

Table relations

When a column ends in «_id» and the first part is a database table, the edit and create form automatically generates a select with the «name», «title», «username» or «email» column of this table. Also, on listings, that value is displayed instead of the «id».

Easy to extend and customize

The generated code is «pure» PHP code, you can modify and adapt to your needs.

Responsive design

We used this bootstrap based design: AdminLTE

Installation

git clone https://github.com/jonseg/crud-admin-generator.git admingenerator

curl -sS https://getcomposer.org/installer | php

You need point the document root of your virtual host to /path_to/admingenerator/web

This is an example of VirtualHost:

 DocumentRoot /path_to/admingenerator/web DirectoryIndex index.php Options Indexes FollowSymLinks Order Allow,Deny Allow from all AllowOverride all php_admin_flag engine on php_admin_flag safe_mode off php_admin_value open_basedir none   

Generate CRUD backend

Edit the file /path_to/admingenerator/src/app.php and set your database conection data:

$app->register(new Silex\Provider\DoctrineServiceProvider(), array( 'dbs.options' => array( 'db' => array( 'driver' => 'pdo_mysql', 'dbname' => 'DATABASE_NAME', 'host' => 'localhost', 'user' => 'DATABASE_USER', 'password' => 'DATABASE_PASS', 'charset' => 'utf8', ), ) ));

You need to set the url of the resources folder.
Change this line:

For the url of your project, for example:

$app['asset_path'] = 'http://domain.com/crudadmin/resources';

Now, execute the command that will generate the CRUD backend:

php console generate:admin

This is it! Now access with your favorite web browser.

The command generates one menu section for each database table. Now will be much easier to list, create, edit and delete rows!

Источник

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

This is a simplest PHP program to automatically fetch table details from your mysql database and create all necessary CRUD functions in a php file.

bhaskarvyas001/php_crud_generator

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

This is a simplest PHP program to automatically fetch table details from your mysql database and create all necessary CRUD functions in a php file.

The details of the files are as follows:

#dao_code_generator.php This is the actual code file that needs to be executed to generate a PHP file with crud methods NOTE: please open the file and update the database details and the class name of the PHP file to be generated

define(‘MYSQL_SERVER’, ‘localhost’); define(‘MYSQL_DATABASE_NAME’, ‘kistyle’); define(‘MYSQL_USERNAME’, ‘root’); define(‘MYSQL_PASSWORD’, ‘password’); define(‘CLASS_NAME’, ‘saloonDAO’);

#saloonDAO.php This is the file created as a result of executing the code generator PHP

#queriesHelper.php Just a PHP file with some utility methods to assist in proper formation of the queries and execution

#Controller.php PHP file with database connection details to be used later for executing the generated PHP file

#sql.php Utility PHP file with code to connect to mysql database using PDO

About

This is a simplest PHP program to automatically fetch table details from your mysql database and create all necessary CRUD functions in a php file.

Источник

NEVER BUILD YOUR MySQL CRUD FROM SCRATCH AGAIN

Generate fully customizable PHP MySQL CRUD in LESS THAN 5 MINUTES.

• WHO USE PHPGRID?
• 
• 
• 
• 
• 
• 

STOP WASTING TIME DOING IT ALL BY YOURSELF.

On average, a developer spends nearly 25 hours or more developing just the basic MySQL CRUD code for different applications.

WHAT IS PHPGRID

phpGrid is a PHP CRUD generator and an application component that is designed with one goal in mind —
reduce development time by simplifying any CRUD (Select, Insert, Update, Delete) operations .

Auto-generated MySQL CRUD

Auto-generate SQL statement for CRUD operations on the fly and are completely transparent to the users

Conditional formatting

By applying conditional formatting to a datagrid cell or row, you can quickly identify variances in a range of values with a quick glance.

WYSIWYG, PDF Export, File Upload, & MORE!

A wealth of features including CRUD, WYSIWYG, file upload, autocomplete, composite primary key, and complete export capabilities.

Источник