Code Lab
Ut elit luctus nec ullamcorper
PDOCrud
CRUD application generator for PHP with Mysql, Pgsql, SQLServer and Sqlite database.
what is PDOCrud ?
Generate insert/update/view forms with grid display of data by writing 2 lines of code using PDOCrud – Best PHP CRUD Builder Application.
Among our clients
About PDOCrud
“PDOCrud script simplifies web app development. Just a few lines of code handle database operations like insert, update, delete, and read. It offers features like pagination and customization. Plus, it manages data submission and validation, making development a breeze.”
Manage Data Directly From Database
Easy to Customize
Support
Manage Data Directly From Database
You can modify and make change in data directly from database without any restrictions.
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.
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.
Trust our experience!
PDOCrud is a PHP CRUD (Create, Read, Update, Delete) application and database management system that offers various features to simplify database operations. Here are four important features typically associated with PDOCrud
Completed projects
Our portfolio speaks better than words!
Atica Agency
Morbi at laoreet mauris dolor amet glavrida ipsum.
Utosia
Lorem ipsum dolor sit amet scelerisque ipsum.
Kyan
Nulla a velit quis ex ornare rhoncus.
Ztos Development
Lorem varius – natoque penatibus ipsum dolor sit amet.
Amara
Nam a fringilla nulla, sit amet pretium libero.
Fossa Group
Donec imperdiet risus justop – praesent viverra scelerisque ipsum id ultrices
Treva
Lorem ipsum nulla for ipsum lorem amet glavrida.
Light AI
Dolor uctus nec ullamcorper malesuada eget consecte turmattis.
Hex Lab
Ut elit tellus pulvinar lorem glavrida ipsum anet dapibus.
Features of PDOCrud
Don’t be busy – be productive!
Add records
Action buttons can be displayed on the top right section of the grid near to the add button.
Update
Modify the chosen database entry with the updated information from the form.
View
Retrieve database records for reading and other processing data efficiently as needed.
Delete
Erase or eliminate the chosen record from the database table when required.
CSV
It exports data in CSV format for convenient and structured file sharing.
Export data into a PDF format for structured document sharing.
Excel
It exports data in a format compatible with Microsoft Excel for convenience.
Search
The main use tool for 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
Modify or remove individual records within the table as necessary.
Sorting Asc and Dsc
Sort result sets in either ascending or descending order .
"Print the document."
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 and service
PDOCrud is compatible with various languages for a diverse user experience.
PDOCrud supports Column Switch operation.
Sort result sets in either ascending or descending order on the needs.
Added new plug-ins for enhanced functionality.
PDOCrud seamlessly integrates with additional plug-ins.
Custom pagination
Enhances user experience by reducing long scrolls for database results.
Configure Records per page
Specify records per page, usually exceeding single-page capacity
Custom Action Buttons
PDOCrud can seamlessly work with custom action buttons for flexibility.
Recaptcha support
PDOCrud fully supports Google Recaptcha integration for security.
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.
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 implementation
Show/hide fields with conditional logic (this works with database only)
Email Form Submitted
Send form data on email – various template customization options
Form Elements: customization.
Almost all type of form elements like textbox, select, radio etc.
Nested Table
Implemented multi-table relationships for enhanced functionality and data management.
JQuery Plugins
Incorporated support for multiple jQuery plugins, such as CKEditor and more.
Image Functions
Added versatile image functions (crop, resize, thumbnail, watermark, flip, etc.).
Related Data
Helps the user to simply relate the data of one table to another table in the forms as lists.
Table Cell Edit
Enables the user to edit a single line of cells as similar to an excel sheet.
JQuery Plugins
Incorporated support for numerous jQuery plugins, including CKEditor.
Pure Bootstrap
Pure Bootstrap simplifies responsive web design and enhance layouts.
Set columns
Users can specify displayed columns instead of all 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.
User Access Management
A comprehensive user-based login and access management system has been integrated into this feature, enhancing security and user control.
Placeholder: Enhanced Use
Activating the placeholder settings empowers users to conveniently display default placeholders for input elements, enhancing user guidance and form clarity.
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.
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.
Enumeration Data Field
Enum field will be automatically converted to a dropdown. User needs to enable enumToSelect = true to make it appear as a dropdown.
Customization Field
Set field will be automatically converted to a multi-select dropdown. Users need to enable setToSelect = true settings to make it appear.
Duplicate Row: Replicate Data.
By enabling the placeholder settings, User can show the default placeholder for input elements.
Add/Edit form Field
Now, users can independently configure form fields for both insert and edit forms, offering enhanced data control.
Check duplicate b/f interest
User can check whether a record with the same value exists or not before inserting data, they can use.
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: Restore Defaults.
Users have the capability to independently configure distinct form fields for both the insert and edit forms, enhancing data management.
Quick table data view
Now users can set the separate form fields for insert and edit forms.
The user can set quickView=true to quickly view the table data.
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 have the option to decide whether they want to load the template’s JavaScript and CSS files by adjusting the settings. and how to use.
On hover
On hover effect is particularly helpful when users have a huge number of columns in grid/table.
Hidden fields
Helps in calculating a field value based on the other field’s value then the user can easily do things.
Ajax Actions
User can now directly perform ajax actions on form elements. By default, the element apply ajax.
Subselect SQL
User can use the subselect query to create columns dynamically. They can get data from other tables.
Dynamic Invoice Generate
PDO crud support invoice generation directly from the database.
Dynamic hidden fields
Helps in calculating a field value based on the other field’s value.
Dynamic JS Action
User can apply simple math functions to calculate fields.
If the plan doesn’t work – change the plan, not the goal.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus velit quis ex ornare rhoncus. Donec imperdiet risus justo, vel malesuada erat fermentum at. Morbi at laoreet mauris!
PDOCrud - Form Examples
Sign Up Form using PDO crud
You can add various field types,edit the label and add hints. This helps to keep your data consistent.
Register to App using PDO Crud
Our forms are easily accessible on any desktop, tablet, smartphone or mobile platform.
Join Us! form using PDOCrud
You can add various field types,edit the label and add hints. This helps to keep your data consistent.
Login/ Signup using PDO Crud
Provide feedback to users about the results of their form submission, whether successful or Error .
PDOCrud Audition Form
Talent hunters can use this audition form to gather participants information for talent audition.
PDOCrud Car Rental Form
A sample form to give you an inspiration if you are in car rental business. To collect data .
Donation form using PDOCrud
Our easy-to-use, drag and drop form builder is the perfect solution for your donation collection needs.
Cruise Booking form by PDO Crud
When doing a cruise booking have your clients fill out this form with essential information.
Event Registration Form using PDOCrud
Easy way to allow users to rate an event and provide feedback.
Feedback Form designed using PDOCrud
This feedback form will be perfect for your visitors to give feedback easily.
Flight Booking form using PDOCrud
Easy for users to reserve flight for their destination using this form.
Hotel Booking form using PDOCrud
An online hotel booking form to track your bookings easily and manage further.
Recruitment, Hiring Form using PDOCrud
To recruit an employee for your company, you can align job application form on your site.
Library Membership form using PDO Crud
Allow people to apply for the membership in your library directly through this form.
PDO Crud Order and Sales form designs.
Say goodbye to boring forms, Create a form that enables customers to order online.
If the plan doesn’t work – change the plan, not the goal.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus velit quis ex ornare rhoncus. Donec imperdiet risus justo, vel malesuada erat fermentum at. Morbi at laoreet mauris!
FAQs
Yes, you can use it to insert multilanguage data. Just make sure your table has appropriate Collation.
Database operations are handeled using PDO with proper parameter binding for all type of database.
Yes, you can modify data using call back functions of php and javascript.
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.
Yes, you can use it. A little bit customization may be needed for some specific frameworks.
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”);
You can hide all label using $config[“hideLable”]=true;
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.
By default, autoincrement columns are not shown in form but You can set $config[“hideAutoIncrement”]=false; to show it.
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).
Yes, it is friendly for mobile devices.
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.
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
Here is example of where condition
http://pdocrud.com/demo/pages/where-condition.php
1. Yes, it can be done in same way
2. Please check following demo http://pdocrud.com/demo/pages/table-operations.php
Yes, you can.
here is an example of showing 2 fields in one row
http://pdocrud.com/demo/allforms/order/order.php
http://pdocrud.com/documentation/#!/grid_column
$pdocrud->colRename(“customer_name”, “client name”);//rename customer_name to client name in grid
You can use formRemoveFields($fields) , where $fields is the array of name of fields to removed.
fieldNotMandatory($fieldName) ; //here you can specify field name
http://pdocrud.com/demo/pages/field-class-attr.php You can define width and height attribute also
$pdocrud->colRename(“first_name”, “client name”); this will rename view lable also.
add css class using folllowing code
$pdocrud->fieldCssClass(“first_name”, array(“class1”, “class2”));// add css classes in your css
.class1{
width :100px;
}
Yes, It can be done using the various action hooks or callback function.
http://pdocrud.com/demo/pages/callback-function-php.php
You can set any attribute like this
$pdocrud->fieldAttributes(“email”, array(“disabled”=>”disabled”));// any attribute name and it’s value.
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
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();
Add records
Action buttons can be displayed on the top right section of the grid near to the add button.
Add records
Action buttons can be displayed on the top right section of the grid near to the add button.