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.”

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

Rapid Application Development (RAD)

PDOCrud is designed to help developers quickly create web applications with CRUD functionality. It provides a user-friendly interface for generating database-driven applications, reducing the time and effort required for development.

Customizable Templates

Users can customize the look and feel of their applications using templates. This allows for branding and tailoring the application's appearance to match specific design requirements or corporate branding.

Data Export and Import

PDOCrud supports data export to various formats, such as CSV, Excel, PDF, and JSON, making it easy to share or analyze data. Additionally, it often includes the ability to import data from external sources, simplifying the process of populating the database.

Advanced Filtering and Searching

The system typically offers advanced filtering and searching capabilities, allowing users to search and filter data based on specific criteria. This helps users find the information they need quickly and efficiently.

Want to know how we can help your business?

Call us:

+001 234 56 78

Completed projects

Our portfolio speaks better than words!

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.

PDF

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.

PDO Crud Gym Membership Form

Invite membership requests for your Gym club.

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.

 

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

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

 

$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;
}

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.