Build Powerful CRMs, Web Apps, Forms Super Fast with PDOCrud - New Version Released with PHP 8 Support

URL demo
Documentation URL
basic details
Youtube - How to Develop a Web Application in Minutes Using PDOCrud
Demonstration of various functions
Quick installation and configuration
Quickly build a backend management application with PDO CRUD tutorials
User Login and Role-Based Access Management Tutorial

Version 5.1 is now available with PHP 8 compatibility and many new features. View now

With just 2-3 lines of code, you can build forms directly from database tables in seconds. All insert/update/delete/view code is managed by scripts.

script function

In almost every web application, we need to write many lines of code to perform operations to insert, update, delete and read database tables.The PDOCrud script does the job with just 2 lines of code.This will perform basic operations of add, edit, update and delete as well as some other operations like pagination, records per page, search, etc.In addition to this, you can customize your tables and form data in as many ways as you want by writing simple lines of code.A number of javascript plugins have also been added which also help with many other tasks. Scripts have many features that simplify the development process.You can easily build simple web applications and backend cms using scripts.

code example

Features

1. Very simple syntax and default crud operations in just 2 lines of code
2. Generate forms directly from the database
3. User access management
4. Nested tables and nested table support in tabs
5. Support left join operation
6. Automatically generate insert/update forms directly from database tables
7. Change the label name, hide the label
8. Remove fields, show specific fields, change field types, easily change the order in which fields are displayed
9. Integrate many common plugins
10. popup form
11. multi-step form
12. Export form data in pdf, xml, csv and excel formats
13. Callbacks for PHP and Javascript
14. Ajax-based submission
15. Add static fields like terms and conditions, confirm password
16. PHP and JS validation
17. Various settings and customizations
18. Front-end field encryption
19. Field plugins, field descriptions and tooltips
20. Different types of template support, used by default with bootstrap
21. Queue js and css
22. Easily add new plugins
23. Many different types of fields are available
24. Multilingual support
25. Data binding of fields from another table/array
26. Load data that depends on some field changes, such as country change, load status
27. Provides normal, horizontal and inline table types
28. Add css classes and various data properties
29. Support rtl by adding external css
30. Captcha and PHP-based captcha support
31. Google Maps support
32. Column toggle options
33. Add new action button
34. Perform raw database related operations
35. Easily add filter(where) conditions
36. Print and export in csv, excel, pdf format
37. Search all fields and specific fields
38. Multiple delete options
39. Fast loading with ajax
40. Best Practices and Ease of Customization
41. Login (select) form validation
42. Various image functions (trim, resize, thumbnail, watermark, flip)
43. Import bulk data from csv, xml and excel files
44. One page template showing form and Crud table on single page
45. Advanced filter options
46. Email form data - various template customization options
47. Generate graphs/diagrams directly from the database (beta)
48. Support sql server (2012 or later)
49. Generate portfolio format directly from database
50. Add formula functionality to modify fields before insert/update
51. export database
52. Spreadsheet-like editing of individual table cells

Wordpress plugin for PDOCrud

Version 5.2 is in development. Please email me with the functionality you need. Thank you all for your great support. Your good reviews and feedback allow us to add more and more features.

The price will increase after the next version is released

Version details

Version 5.1

• Added PHP 8 support
• Added new functionality to apply where conditions in buttons
• fixed a bug

Version 4.8

• Added new plugin emojionarea (demohttps://pdocrud.com/demo/pages/plugin-emojionearea)
• Added new feature documentation
• Fixed bugs related to related data

• 1. A new plugin that adds the function of showing/hiding the password icon (demohttps://pdocrud.com/demo/pages/plugin-password)
• 2. Added "enable" and "disable" functions to the field conditional logic
• Fixed bugs related to single page
• Fixed a bug related to field conditional logic

Version 4.6

• 1. Fix relationship-related bugs

Version 4.5 - (changes in config files and js files, so make sure to clear cache)

• Calculate Invoice function (demohttps://pdocrud.com/demo/pages/dynamic-invoice)
• Added javascript-based dynamic field calculation function (demohttps://pdocrud.com/demo/pages/dynamic-js-actions)
• Added option to get tcpdf object
• Also added related data feature for viewing
• Added "percentage" option to tableColAddition()

Version 4.4 - (changes in config files and js files, so make sure to clear cache)

• Added bootstrap 4 css class to bootstrap 4 template
• Added subquery option to generate dynamic columns (demohttps://pdocrud.com/demo/pages/subselect-sql)
• Added option to get tcpdf object
• Added new field type, jquery spinner if field type = "spinner"

Version 4.3 - (changes in config files and js files, so make sure to clear cache)

• Ajax-based field calculation (demohttp://pdocrud.com/demo/pages/ajax-actions )
• Dynamically calculate field values ​​for other fields (demohttp://pdocrud.com/demo/pages/calculate-field-based-on-another-field-dynamically )
• Added ability to completely hide fields using formFieldValue (demohttps://pdocrud.com/demo/pages/set-field-value)
• Added where and order by to the related data function. (demohttps://pdocrud.com/demo/pages/related-data )
• Added option to set fields with default database values ​​to "not required" (demohttps://pdocrud.com/demo/pages/field-not-required)
• Added header and action text to the View action
• Added option to search textbox

Version 4.2 - (changes in config files and js files, so make sure to clear cache)

• Added new methods to perform complex where conditions (demohttp://pdocrud.com/demo/pages/where-condition ).
• Add a where condition and order by in the fieldDataBinding function. (demohttp://pdocrud.com/demo/pages/field-data-binding )
• Automatically set key fields in multi-table relationships (nested tables). (demohttp://pdocrud.com/demo/pages/multi-table-relation )

Version 4.1 - (changes in config files and js files, so make sure to clear cache)

• BugFixed: Fixed a small bug related to email with insert data and related data.

Version 4.0 - (changes in template files, config files and js files, so make sure to clear cache)

• Add related data feature - if your main table contains fields related to other tables, you can get dropdowns and data directly from other tables (demohttp://pdocrud.com/demo/pages/related-data )
• fielddatabinding() - You can now pass a valid select query to generate field data directly by running the query. (demohttp://pdocrud.com/demo/pages/field-data-binding )
• fielddatabinding() - You can now combine two or more columns in the displayed value. (demohttp://pdocrud.com/demo/pages/field-data-binding )
• Added option to automatically convert mysql's "SET" datatype in multiselect fields (demohttp://pdocrud.com/demo/pages/SET-Column-type )
• Changes to the setSkin function, now you can apply multiple skins together by passing them as an array
• Add image display option in edit form for file upload control
• About the hover effect of grid rows (demohttp://pdocrud.com/demo/pages/on-hover )
BugFixed: Fixed bug related to select form

Version 3.8 - (changes in template files, config files and js files, so make sure to clear cache)

• BugFixed: Fixed bug related to multiselect and attribute

Version 3.7 - (changes in template files, config files and js files, so make sure to clear cache)

• Added option to choose whether to load template js and css files (demohttp://pdocrud.com/demo/pages/loading-template-js-css )
• Added single table cell editing functionality similar to excel cell editing (demohttp://pdocrud.com/demo/pages/table-cell-editing )
• Added plugin summernote wisyyg editor (demohttp://pdocrud.com/demo/pages/plugin-summernote )
BugFixed: Fixed bug related to select form

Version 3.6 - (changes in template files, language files, config and js files, so make sure to clear cache)

• Added Google Charts functionality for various chart types (demohttp://pdocrud.com/demo/pages/google-chart )
• CRUD batch update now supports more html elements, i.e. fields like select, textarea (demohttp://pdocrud.com/demo/pages/crud-table-bulk-update )
• Added autosuggest functionality to the search box (demohttp://pdocrud.com/demo/pages/autosuggestion )
• Add reset form option to config to reset form fields after submit, similar to "insert and new" (demohttp://pdocrud.com/demo/pages/reset-form )
• Added quick view of table/grid row click data (demohttp://pdocrud.com/demo/pages/quick-table-view )
• Add field types "range" and "rateit" and add column type "rateit" (demohttp://pdocrud.com/demo/pages/plugin-rateit )
• Added option to set encryption method for input type = 'password' (demohttp://pdocrud.com/demo/pages/password-encryption )
• Added setting for placeholders, if set to true, it will display input type='text' by default (demohttp://pdocrud.com/demo/pages/placeholder )
• Added ability to set record per page list (demohttp://pdocrud.com/demo/pages/large-table-data )
• Option to hide/show "Save and Return button" and "Back" button in settings page
• Design improvements
• Added plugin bootstrap label input (demohttp://pdocrud.com/demo/pages/plugin-bootstrap-tag-input )
• Added plugin Bootstrap Password Strength (demohttp://pdocrud.com/demo/pages/plugin-pwstrength )
• Add plugin vertical timeline (demohttp://pdocrud.com/demo/pages/plugin-vertical-timeline )
• add plugin to rate it (demohttp://pdocrud.com/demo/pages/plugin-rateit )
• Added plug-in input mask (demohttp://pdocrud.com/demo/pages/plugin-input-mask )
• BugFixed: Fixed bug related to inner join

Version 3.5 - (changes in configuration files)

• BugFixed: Fixed bug related to the set search columns (demo http://pdocrud.com/demo/pages/set-search-cols)

Version 3.4 - (changes in configuration files)

• Added output database function (demohttp://pdocrud.com/demo/pages/export-db )
• Add btn switch to trigger demo (demohttp://pdocrud.com/demo/pages/btn-switch-with-trigger )
BugFixed: Fixed lost password bug

Version 3.3 - (changes in configuration files)

• Added new function editFormFields to allow editing and insertion of individual form fields of a form (demohttp://pdocrud.com/demo/pages/form-fields)
• Add the ability to check for duplicate records before inserting (demohttp://pdocrud.com/demo/pages/check-duplicate-before-insert)
• Added bootstrap4 template - note that our admin theme has bootstrap3, so it won't work with admin themes.
• ನಿಯತಾಂಕದ ಗಾತ್ರವನ್ನು ಹೆಚ್ಚಿಸಿ
• BugFixed: Fixed multi table relation auto insert of key

Version 3.2 - (changes in configuration files)

• Added long-awaited feature - full user access management to easily manage user logins (demohttp://pdocrud.com/demo/pages/user-login-management)
• Added clone row option to insert rows faster (demohttp://pdocrud.com/demo/pages/clone-rows)
• Add - max. and minutes. Allow date selection in date picker by setting value in config file
• Many callback features added
• BugFixed: Enqueue Button Action multiple url action fixed.

Version 3.1 - (changes in configuration file)

• Added option to map database fields to static fields (demohttp://pdocrud.com/demo/pages/field-database-mapping)
• Add enum field to automatically convert in select field (demohttp://pdocrud.com/demo/pages/enum-field)
• Add subtraction and multiplication to dynamically add new table columns based on two column values ​​(http://pdocrud.com/demo/pages/table-col-add-col)
• Improved inner join functionality
• BugFixed: Fixed warning message for count due to changes in php version 7.2

Version details

Version 3.0 - (changes in configuration files)

• Breaking change - you need to enter a purchase code in your profile. You can find details on where to find purchase codes herehttps://help.market.envato.com/hc/en-us/articles/202822600-Where-Is-My-Purchase-Code-If anyone is having trouble entering purchase details, please email us using the profile page today.
• Pure Bootstrap templates have been added, which can be further customized as needed. (demohttp://pdocrud.com/demo/pages/template-selection )
• Added option to add action buttons at the top (as well as add buttons). (demohttp://pdocrud.com/demo/pages/action-button-top )
• Added yearly, monthly, daily report buttons to generate tabular data based on date ranges (demohttp://pdocrud.com/demo/pages/date-range-report )
• You can pass an array of columns in order by (dbOrderBy function) (demohttp://pdocrud.com/demo/pages/order-by)
• Rearrange column display order (demohttp://pdocrud.com/demo/pages/column-reorder)- Code contributions by user patrick.
• Fixed bug: Fixed multiple button one-page template page issue.
• Bug resolved: Searching all columns with where condition ignores where condition. solved.

Version 2.6 - Please see the README. text file for more details

• Improved overall view section
• Added tabs and multi-table relationships in view forms
• Added sidebar option in edit/view form, similar to profile page design in many admin themes
• Improved filters - now you can also set similar operators like search.
• Option to hide shape buttons
• Added option to change export/print labels (column headers)
• FIXED: Excel export not working due to issues with old excel library, now works fine after updating library

Version 2.5

• Added View Form formatting options similar to tableColFormatting
• Added option to upload multiple files
• Added new file controls to select and edit files. The edit form also contains the file url.
• Added formula functionality to modify fields before insert/update. This can be done by using a callback function.
• Added null value for date support.
• Added French translation - contributed by user "wazkero"
• Improved validation
• Fix: Fixed bug with pgsql

Version 2.4 (configuration and language files changed, so make sure to update it)

• Added direct function for forgotten password
• On the basis of the main table operation, triggering insert/update/delete operations in other tables is added
• Added left action button display.
• Add jQuery data table plugin to display sql rendering data more efficiently
• Added date range/time range/date time range search by setting search column type, i.e. now you can pass from date and to date in your search
• Changes to sql rendering functionality - removed pagination/records per page/total records displayed in default display
• Added more callback events on insert and update (after_insert and after_update)
• Fixed: Removed double slashes from url addition
• Fixed: Minor bug in sql rendering function for print/export

Version 2.3 (config file changes, so make sure to update it)

• Added a new Portfolio section to automatically generate portfolios in a similar format directly from the database
• Added label type field (fieldtype=label)
• Further improved login management by adding redirects only after successful login etc.
• Added delete and edit buttons to the view, with option to hide/show all of them
• Added extra options to specify the columns of the view form.
• Fixed minor bugs related to table column formatting.
• Fixed minor bugs related to search.

Version 2.2

• Added sql server support (>= 2012)
• Add graphs/charts using direct code and plugins
• Added ability to set file upload/download folder instead of configuration
• More plugins added
• Fix the small bug of inline editing position when the checkbox column and id column are hidden
• Fixed minor bugs related to sqlite

Version 2.1

• Add more options to format table columns
• Fixed minor bugs related to responsive design
• Fixed bugs related to sqlite

Version 2.0

• Added Nested Tables and Nested Tables to the Tabs feature
• Add plugin ckeditor

Version 1.9

• Add crud table batch data update operation to change values ​​directly in crud table
• Added option to import bulk data from csv, xml and excel files
• Added functions csvToArray(), excelToArray() and xmlToArray() to get the array format of these file data
• Add sumPerPage and sumTotal functions
• Added new form elements such as sliders, range selectors, etc. Currently it works one element per page
• Added search operators to search using 'like', '>', '>=', '<', '=<', etc, defaults to the '=' action.
• Added a page template to display the form and Crud table on a single page.
• Several image features added (trim, resize, thumbnail, watermark, flip)

Version 1.8

• Added advanced filter options
• Added option to specify col data from another table's column or array
• Added open insert option to edit form directly in button click popup (direct popup form already exists)
• Added new column action url functionality to redirect to another page with primary key
• Added more options to format table columns (date, string, number format)
• Added more parameter options for jQuery datepickers
• Bugfixes - Fixed sqlite related bug in PDOModel section

Version 1.7

• Redirect to another url after submitting the form
• Show/hide fields using conditional logic (only for database fields)

Version 1.6

• More plugins added
• The image upload path will be added to the saved image url
• Email form data - various template customization options

Version 1.5

• Captcha support
• Option to add hidden fields to save specific columns
• Added option to add custom action buttons
• Fixed bug with selecting action hook data

Version 1.4

• Added column switching operation
• Added option to show left join data in view
• Added many demo forms
• Added more plugins
• Fixed a bug related to the join operation

Version 1.3

• Added url option to column format
• Added PDOModel class support
• Fixed bugs related to pagination
• More examples added

Version 1.2

• Added extra sheets
• Added French translation
• Added more js plugins

Version 1.1

• initial release

Credits:

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management) [Free Download]
PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management) [Nulled]
PHP Scripts » Database Abstractions