CRUD application generator for PHP with Mysql, Pgsql, SQLServer and Sqlite database.

Generate insert/update/view forms with grid display of data by writing 2 lines of code using PDOCrud - Best PHP CRUD Builder Application.

PDOCrud - is an advance PHP based CRUD(Create, Read, Update and Delete)

PDOCrud supports Mysql, Pgsql & Sqlite database and easily manage data with user-friendly features.

Almost in every web application, User need to write many lines of codes to perform insert, update, delete and read database tables operations. PDOCrud script perform this work by just writing 2-3 lines of code. It offers add, edit, update and delete basic operation along with several other operation, like pagination, records per page, search etc. Apart from these, User can customize the table and form data in many ways as per requirement by writing simple line of codes. Many javascript plugins are also added that help to perform many other tasks. PDO Crud Script has many features to ease the development process. You can build simple web application and backend cms using the script easily. You don’t need to write data submission code (Insert/Update/Delete/Export), script handles that part too. By default, script also put validations as per the field type and manages the data submission using ajax.

Manage data directly from the Database

PDOCrud is a simple yet powerful Create Read Update Delete (CRUD) generator application.

PDOCrud is advance PDO Database management system that creates fields based on the field type and field name as defined in the database table directly by writing only 2-3 lines of codes. The application offers you many ways to work with your data, You can use it as plain php library or with your favorite framework and cms.

View Demo Buy PDO Crud

Support

Apart from insert/update, You can export data directly to pdf, csv, xml, excel etc. You can show form in popup, multi step form, different layouts of forms and many more features using this free php crud generator.

Multilanguage support

PDOCrud supporting multiple languages.

Security

Secure your reputation and protect your user’s data PDOCrud Provides Captcha support

Add plugins easily

Apart from normal way of applying any javascript plugin, there is special feature in PDOCrud, using which you can easily integrate plugins.

Easy to CUSTOMIZE

PDOCrud also provides various methods of customization By default, PDOCrud comes with bootstrap framework but you can use any template you want.

PDOCrud is very easy to use even for the non-programmers. Content management has become simple and flexible which saves a lot of time and it take minutes to implement this application. You can easily change field types, add captcha, google map, hide/show label, various settings using config file.

PDOCrud - Features

Add records

Creating or inserting new record to database.

Update

Update selected record in the database.

View

Read or retrieving database records.

Delete

Delete or removing selected record from table.

CSV

It export data in CSV Format.

PDF

It export data in PDF Format.

Excel

It export data in Excel Format.

The main use for the tool for some users is with the Search mode, for finding data.

Delete selected elements

Delete or removing single or multiple selected record from table.

Inlile edit and delete

Edit or Delete Inlile record from table.

Sorting asc and desc

Sort result sets in either ascending or descending order on the basis of column,

It provide visitors to your site to be able to do print the current page data.

Captcha & Google map support

PDOCrud supports google map and captcha for security.

Multilanguage support

PDOCrud can work with multiple language

Column Switch operation

PDOCrud supports Column Switch operation.

Added Plug - Ins.

PDOCrud can work with other added Plug-Ins.

Pagination

This feature for the user on seeing database result, it reduces the burden with long scrolls upside down and provides page results within the single scope of user’s display.

Records per page

you can specify Number of records to show per page, generally results in a number of rows which don't fit in a single page (30 rows by default)

Custom Action Buttons

PDOCrud can work with Custom Action Buttons.

Recaptcha support

PDOCrud supports Recaptcha.

Format Table Columns

Added more options to format table columns (Sum, divide, merge etc)

Advance Filter Options

To use the Advanced Filter, you need to enter the criteria in search box.

Bulk Data Update in Table

Added crud table bulk data update operation to change values directly in crud table.

Import data support

Added option to import bulk data from csv, xml and excel file.

One Page Template

Added one page template to show Form and Crud Table on single page.

Conditional logic

Show/hide fields with conditional logic (this works with database fields only)

Email Form Submitted

Send form data on email - various template customization options

Form Elements

Almost all type of form elements like textbox, select, radio, checkbox, datepicker, timepicker, slider etc are supported.

Nested Table

Added multi table relation.

JQuery Plugins

Added support for various jQuery plugins like ckeditor.

One page template

Added one page template to show Form and Crud Table on single page.

Image Functions

Added various image functions (crop, resize, thumbnail, watermark, flip)

Related Data

Helps the user to simply relate the data of one table to another table and display it in the forms as lists.

Table Cell Edit

Enables the user to edit a single line of cells as similar to an excel sheet.

Pure Bootstrap

Set search columns

user can set which search columns need to be shown instead of showing all the columns in the search box.

Autosuggestion Search

Autosuggestion can be added in the search box which automatically displays the saved data according to the search made by the user.

Top action buttons

Action buttons can be displayed on the top right section of the grid near to the add button. It will be useful if you want to perform some operation on a complete grid.

User Access Management

A complete user-based login and access management is added in this feature.

Placeholder

By enabling the placeholder settings, User can show the default placeholder for input elements.

Date Range Reports

Users can directly add month-wise, day-wise, year-wise (calendar as well day duration wise) report buttons to create the table data based on the date range.

Map Static field to DB

Many times the user wishes to insert some static fixed value in the database field along with the other field during a database insert operation.

Enum Field

Enum field will be automatically converted to a dropdown. User needs to enable enumToSelect = true to make it appear as a dropdown.

Set Field

Set field will be automatically converted to a multi-select dropdown. Users need to enable setToSelect = true settings to make it appear as a dropdown.

Clone Row

By enabling the placeholder settings, User can show the default placeholder for input elements.

Add/Edit form Field

Now users can set the separate form fields for insert and edit forms.

Check duplicate b/f interest

User can check whether a record with the same value exists or not before inserting data, They can use checkDuplicateRecord() function to obtain it.

Search column data type

The function of setting search column data type to date/DateTime/time etc to make search more friendly.

Reset form fields

Users can set the separate form fields for insert and edit forms.

Quick table data view

The user can set quickView=true to quickly view the table data just below the table on click of row.

Password Encryption

This function permits the user to define the encryption method to be used for password type fields prior to data insertion or selection.

Template JS/CSS File

Users can choose whether they need to load the template js and CSS files or not using the settings.

On hover

On hover effect is particularly helpful when users have a huge number of columns in grid/table.

Dynamic hidden fields

Helps in calculating a field value based on the other field's value then the user can easily do using the formFieldValue() function.

Ajax Actions

User can now directly perform ajax actions on form elements. By default, the element on which user apply ajax, it's value will be passed directly.

Subselect SQL

User can use the subselect query to create columns dynamically. They can get data from other tables using the query.

Dynamic Invoice

PDO crud support invoice generation directly from the database.

Dynamic JS Action

User can apply simple math functions to calculate fields using javascript.

PDOCrud -Form Examples

You can add various field types,edit the label and add hints. This helps to keep your data consistent.

Demo Form Buy PDO Crud

Our forms are easily accessible on any desktop, tablet, smartphone or mobile platform of your choice.

Demo Form Buy PDO Crud

Join Us! form using PDOCrud

You can add various field types,edit the label and add hints. This helps to keep your data consistent.

Demo Form Buy PDO Crud

Provide feedback to users about the results of their form submission, whether successful or Error .

Demo Form Buy PDO Crud

PDOCrud Audition Form

Talent hunters can use this audition form to gather participants information for talent audition.

Demo Form Buy PDO Crud

PDOCrud Car Rental Form

A sample form to give you an inspiration if you are in car rental business.

Demo Form Buy PDO Crud

Donation form using PDOCrud

Our easy-to-use, drag and drop form builder is the perfect solution for your online donation collection needs.

Demo Form Buy PDO Crud

Cruise Booking form using PDO Crud

When doing a cruise booking have your clients fill out this form with essential information.

Demo Form Buy PDO Crud

Event Registration Form using PDOCrud

Easy way to allow users to rate an event and provide feedback.

Demo Form Buy PDO Crud

PDOCrud Feedback Form

This feedback form will be perfect for your visitors to give feedback easily.

Demo Form Buy PDO Crud

Flight Booking form using PDOCrud

Easy for users to reserve flight for their destination using this form.

Demo Form Buy PDO Crud

PDO Crud Gym Membership Form

Invite membership requests for your Gym club.

Demo Form Buy PDO Crud

Hotel Booking form using PDOCrud

An online hotel booking form to track your bookings easily and manage further reservations more accurate.

Demo Form Buy PDO Crud

PDO Crud Job Application Form

To recruit an employee for your company, you can align job application form on your site.

Demo Form Buy PDO Crud

Library Membership form using PDO Crud

Allow people to apply for the membership in your library directly through this form.

Demo Form Buy PDO Crud

PDO Crud Order Form

Say goodbye to boring forms, Create a form that enables customers to order online.

Demo Form Buy PDO Crud

Get this script NOW!

Get this script

F.A.Q.

1.Does script provide Multilanguage support?

Yes, you can use it to insert multilanguage data. Just make sure your table has appropriate Collation.

2. How are database operations handled ? Using mysql, mysqli or PDO?

Database operations are handeled using PDO with proper parameter binding for all type of database.

3. Is it possible to do modification in data before submission?

Yes, you can modify data using call back functions of php and javascript.

4. How to use rtl?

RTL support is given by adding external css. For bootstrap template, you can add bootsrap-rtl css (placed in the bootstrap folder) and it will change layout to rtl.

5. Can we use this script in any framework?

Yes, you can use it. A little bit customization may be needed for some specific frameworks.

6. How script determine type of field? Can we change it?

Script automatically creates form fields on the basis of the field type and field name as defined in the database table.
Yes, you can change it using $PDOCrud->fieldTypes("field_name", "field_type");

7. How do I hide all labels?

You can hide all label using $config["hideLable"]=true;

8. Can I remove required form validation or add validation on specific fields only?

Yes, you can easily $config["required"]=false; to remove required for all fields and you can easily set specific field validations. You can add php and js validation both. Please check documentation for more details.

9. I want to show auto-increment column of table in form also?

By default, autoincrement columns are not shown in form but You can set $config["hideAutoIncrement"]=false; to show it.

10. Is it possible to have “master/detail” tables?

Yes this is possible. please check the http://pdocrud.com/demo/pages/join.php Here I have shown that there are 2 table (master table is user and detail table is user_meta).

11. Is it friendly for mobile devices?

Yes, it is friendly for mobile devices.

12. How can I add a custom action button? Ex. i want to add a button with custom url and sending the current row id as parameter query string… (ex onclick go to page… http://customedtipage.php?id=currentRowId ).

http://pdocrud.com/demo/pages/col-data-type.php Regarding the action button, it doesn’t allow any custom action button. It will be available in future versions.

13. How can the SQL statement can be applied and does it allow view, update, delete operation?

SQL statement can be anything so view, delete, and update options is not possible for sql statement. You can perform view/edit/delete on a table.
$pdocrud->dbTable(“orders”)->render();
to generate view/delete/update

14. I would like only certain rows in a database in the table (view, delete, edit).
How can I achieve this with the software?

Here is example of where condition
http://pdocrud.com/demo/pages/where-condition.php

15. Is it possible to set multiple filters to a table ?

1. Yes, it can be done in same way
2. Please check following demo http://pdocrud.com/demo/pages/table-operations.php

16. can I display the state_name and country_name in row?

Yes, you can.
here is an example of showing 2 fields in one row
http://pdocrud.com/demo/allforms/order/order.php

17. How can I change the heading of the columns in the table ?

http://pdocrud.com/documentation/#!/grid_column
$pdocrud->colRename("customer_name", "client name");//rename customer_name to client name in grid

18. How I can hide individual input fields in the form?

You can use formRemoveFields($fields) , where $fields is the array of name of fields to removed.

19. How can I disable the validation of a single field in the form ?

fieldNotMandatory($fieldName) ; //here you can specify field name

20. How can change the width of an input field in the form ?

http://pdocrud.com/demo/pages/field-class-attr.php You can define width and height attribute also

21. How can I change the labels in the “view” view ?

$pdocrud->colRename("first_name", "client name"); this will rename view lable also.

22. How can I add css class of an input field in the form? Or How can I change the width in a pull-down?

add css class using folllowing code
$pdocrud->fieldCssClass("first_name", array("class1", "class2"));// add css classes in your css
.class1{
width :100px;
}

23. How can a value be modified while saving to the database?

Yes, It can be done using the various action hooks or callback function.
http://pdocrud.com/demo/pages/callback-function-php.php

24. How can the box be disabled in the form ?

You can set any attribute like this
$pdocrud->fieldAttributes("email", array("disabled"=>"disabled"));// any attribute name and it's value.

25. How can I arrange input fields which are arranged horizontally left-aligned?

Please check various demo forms for code example. You need to group fields for performing this function.
http://pdocrud.com/demo/pages/group-fields.php

26. it will allow to display form with table only? incase i want to display some popup form?

Yes, you can display form on button click also. 1st parameter is button text, 2nd parameter is modal header
$pdocrud->formDisplayInPopup("Open Product Details popup","Product Details");//display form in popup
echo $pdocrud->dbTable("producttable")->render();