PDO Crud Advanced PHP CRUD application Form Builder Database Management

Description

Build powerful CRM web application forms using PDOCrud super fast New version released with PHP 8 support PDOCrud is an advanced PHP-based CRUD application It supports Mysql Pgsql and Sqlite databases You can use PDOCrud to generate both the frontend and backend of your application By writing just 2-3 lines of code only you can perform insert update delete and select operations You just need to create an object and call for the render function for that table and everything will be generated automatically Form fields will be generated based on the data type You can remove fields change the type of fields and do various types of customization Demo url Documentation url Basic Details Youtube How to develop web application in few mins using PDOCrud Demo of various functions Quick installation and configuaration Quickly Build backend admin application using PDO CRUD tutorial User login and role-based access management tutorial Version 6 1 is out now with PHP 8 compatibility and many new features Check out now You can build forms directly from database tables in a few seconds just by writing 2-3 lines of code All insert update delete view code is managed by the script Script functionality Almost in each web application we need to write many lines of code to perform insert update delete and read database tables operations PDOCrud script does this work by just writing 2 lines of code This will add edit update and delete basic operations along with several other operations like pagination records per page search etc Apart from these you can customize the table and form data in many ways as per requirement by writing simple lines of code Many javascript plugins are also added that help to perform many other tasks The script has many features to ease the development process You can build simple web applications and backend cms using the script easily Code example Features Very easy syntax and just 2 lines of code for default crud operations Generate forms directly from database User access management Nested table and Nested table in tabs support Supports left join operation Auto generation of insert update forms directly from database tables Change label name hide label Remove fields Show particular fields Change field type change display order of fields easily Many commonly used plugins integrated Popup form Multistep form Export form data in pdf xml csv and excel Callback functions for PHP and Javascript Ajax based submission Addition of static fields like terms condition confirm password PHP and JS Validations Various settings and customization Field encryption for frontend Field addon field description and tooltips Different type of template support by default works with bootstrap Enqueue js and css Add new plugins easily Many different types of fields available Multilanguage support Data binding of field from another table array Load dependent data on change of some field like on change of country load states Normal horizontal and inline form type available Add css class and various data attributes Support for rtl by adding external css Recaptcha and PHP based Captcha support Google map support Column switch option Add new action buttons Perform raw database related operations Add filter where condition easily Print and export in csv excel pdf Search for all fields and particular field Multiple delete option Fast loading using ajax Best practices and easy to customized Login Select form validations Various image functions crop resize thumbnail watermark flip Import bulk data from csv xml and excel file One-page template to show Form and Crud Table on single page Advanced filter option Send form data on email various template customization options Generate graphs chart directly from the database beta Supports sql server 2012 or higher Generate portfolio format directly from database Added formula function to modify fields before insert update Export database Single table cell editing similar to spreadsheet WordPress Plugin for PDOCrud Version 5 2 is under progress Please drop me email with your features you need Thanks everyone for your awesome support Your great review and feedback made us to add more and more features Prices are going to increase after next version release Version details Version 5 1 Added PHP 8 support Added new feature to apply where condition in the buttons Fixed a bug Version 4 8 Added new plugin emojionarea demo https pdocrud com demo pages plugin-emojionearea Added new functional documentation Fixed a bug related to the related data Version 4 7 1 Added new plugin with the feature of show hide password icon demo https pdocrud com demo pages plugin-password 2 Added new features of enable and disable in field condition logic Fixed a bug related to the one page Fixed a bug related to the field condition logic Version 4 6 1 Fixed a bug related to relation Version 4 5 Changes in config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Calculate invoice feature demo https pdocrud com demo pages dynamic-invoice Added javascript based dynamic field calculation feature demo https pdocrud com demo pages dynamic-js-actions Added option to get tcpdf object Added related data feature for view also Added percentage option in tableColAddition Version 4 4 Changes in config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Added bootstrap 4 css classes in bootstrap 4 template Added Subquery option to generate dynamic columns demo https pdocrud com demo pages subselect-sql Added option to get tcpdf object Added new field type jquery spinner as field type spinner Version 4 3 Changes in config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Ajax based calculation of field demo http pdocrud com demo pages ajax-actions Calculate field value from other fields dynamically demo http pdocrud com demo pages calculate-field-based-on-another-field-dynamically Added feature to completely hide the field with formFieldValue demo https pdocrud com demo pages set-field-value Added whereby and order by in related data function demo https pdocrud com demo pages related-data Added option to set the field having default database value as not required demo https pdocrud com demo pages field-not-required Added tableheading and operation text in view operation Added option on search textbox Version 4 2 Changes in config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Added new way to perform complex where condition demo http pdocrud com demo pages where-condition Added where condition and order by in fieldDataBinding function demo http pdocrud com demo pages field-data-binding Auto set of key field in multi table relation nested table demo http pdocrud com demo pages multi-table-relation Version 4 1 Changes in config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade BugFixed Fixed a small bug related to email with insert data and related data Version 4 0 Changes in template file config file and js file so make sure to clear your cache Added Related data feature If your main table contains the fields related to other table You can get dropdown list and data directly from other table demo http pdocrud com demo pages related-data fielddatabinding You can now pass valid select query to generate the data of fields directly by running queries demo http pdocrud com demo pages field-data-binding fielddatabinding You can now combine two or more columns in the display value demo http pdocrud com demo pages field-data-binding Added option to auto convert SET data type of mysql in multi select field demo http pdocrud com demo pages SET-Column-type Change in setSkin function now you can apply multiple skins together by passing it as an array Added image display option in the edit form for file upload control On hover effect of grid rows demo http pdocrud com demo pages on-hover BugFixed Fixed bug related to select form Version 3 8 Changes in template file config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade BugFixed Fixed bug related to multiselect and attribute Version 3 7 Changes in template file config file and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Added option to select whether to load the template js and css files or not demo http pdocrud com demo pages loading-template-js-css Added single table cell edit feature similar to excel cell editing demo http pdocrud com demo pages table-cell-editing Added plugin summernote wysisyg editor demo http pdocrud com demo pages plugin-summernote BugFixed Fixed bug related to select form Version 3 6 Changes in template files language file config and js file so make sure to clear your cache Please take complete backup before upgrade Make sure to clear cache after upgrade Added Google Chart feature with various chart types demo http pdocrud com demo pages google-chart CRUD Bulk update now supports more html elements i e select textarea etc fields demo http pdocrud com demo pages crud-table-bulk-update Added Autosuggest feature for search box demo http pdocrud com demo pages autosuggestion Added reset form option in config to reset the form fields after submission similar to insert and new demo http pdocrud com demo pages reset-form Added quick view of data on table grid row click demo http pdocrud com demo pages quick-table-view Added field types range and rateit and added column type rateit demo http pdocrud com demo pages plugin-rateit Added option to set encryption method for input type password demo http pdocrud com demo pages password-encryption Added settings for placeholder to show by default for input type text if set true demo http pdocrud com demo pages placeholder Added function to set records per page list demo http pdocrud com demo pages large-table-data Option to hide show Save and back button and back button in settings page Design Improvements Added plugin bootstrap tags input demo http pdocrud com demo pages plugin-bootstrap-tag-input Added plugin bootstrap password strength demo http pdocrud com demo pages plugin-pwstrength Added plugin vertical timeline demo http pdocrud com demo pages plugin-vertical-timeline Added plugin rate it demo http pdocrud com demo pages plugin-rateit Added plugin input mask demo http pdocrud com demo pages plugin-input-mask BugFixed Fixed bug related to inner join Version 3 5 changes in config file BugFixed Fixed bug related to the set search columns demo http pdocrud com demo pages set-search-cols Version 3 4 changes in config file Please take complete backup before upgrade Make sure to clear cache after upgrade Added export database function demo http pdocrud com demo pages export-db Added btn switch to trigger demo demo http pdocrud com demo pages btn-switch-with-trigger BugFixed Fixed lost password bug Version 3 3 changes in config file Please take complete backup before upgrade Make sure to clear cache after upgrade Added new function editFormFields to allow separate form fields for edit and insert form demo http pdocrud com demo pages form-fields Added function to check duplicate record before insert demo http pdocrud com demo pages check-duplicate-before-insert Added bootstrap4 template please note that our admin theme has bootstrap3 so it won t work with admin theme Increased size of maxSize parameter BugFixed Fixed multi table relation auto insert of key Version 3 2 changes in config file Please take complete backup before upgrade Make sure to clear cache after upgrade Added much awaited feature complete user access management functionality to manage user logins easily demo http pdocrud com demo pages user-login-management Added clone row option to insert rows faster demo http pdocrud com demo pages clone-rows Added Max and min date allowed to choose in date picker by setting value in config file Added many callback functions BugFixed Enqueue Button Action multiple url action fixed Version 3 1 changes in config file Please take complete backup before upgrade Added option to map database field to static field demo http pdocrud com demo pages field-database-mapping Added Enum field to auto convert in select field demo http pdocrud com demo pages enum-field Added subtraction and multiplication to add new table column dynamically based on two columns value http pdocrud com demo pages table-col-add-col Improved inner join function BugFixed Fixed warning message for count due to changes in php version 7 2 Version details Version 3 0 changes in config file Please take complete backup before upgrade Major change You need to enter purchase code in config file You can find details about where to find purchase code here https help market envato com hc en-us articles 202822600-Where-Is-My-Purchase-Code- If any one has having issue in entering the purchase details please contact us via email immediately using profile page Added pure bootstrap template that can be customized further as per requirement demo http pdocrud com demo pages template-selection Added option to add action buttons on top along with add button demo http pdocrud com demo pages action-button-top Added year wise month wise day wise report buttons to generate the table data based on the date range demo http pdocrud com demo pages date-range-report You can pass array of columns in order by dbOrderBy function demo http pdocrud com demo pages order-by Reorder column display order demo http pdocrud com demo pages column-reorder code contribution by user patrick Bug Resolved One page template page issue of multiple buttons resolved Bug Resolved Search for all coumns using where condition was ignoring where condition It is resolved Version 2 6 please check readme text file for more details Improved overall view section Added tabs and multi table relation in view forms Added sidebar option in edit view forms similar to profile page design in many admin themes Improved filters now you can also set like operator similar to search Option to hide form buttons Added option to change lable Column heading of export print Fixed Excel export not working properly due to issue of old excel library now working properly after updating the library Version 2 5 Added View Form formmatting options similar to tableColFormatting Added option to upload multiple files Added new file control to select and edit files Edit form contains file url also Added formula function to modify fields before insert update Earier this can be done by using callback functions Added null value of date support Added french translations provided by user wazkero Improved validation Fixed Resolved bug for pgsql Version 2 4 changes in config and language file so please make sure to update it Added direct function for forgot password Added Trigger insert update delete operation in other table based on the main table operation Added Left side action buttons display Added jQuery data table plugin to display sql render data more efficiently Added date range time range datetime range search by setting search column type i e now you can pass from and to dates in search Changes in sql render function removed pagination records per page totalrecords display in default display Added more callback events in insert and update after_insert and after_update Fixed Removed double slashes from the url addition Fixed small bug of sql render function for print export Version 2 3 changes in config file so please make sure to update it Added a new portfolio section to auto generate portfolio like format directly from database Added Tags type field fieldtype tags Improved login management further by adding redirection only after successful login etc Added button for delete and edit in view also option to hide show all these buttons Added extra option to specify the columns for the view form also Fixed small bug related to table column formatting Fixed small bug related to search Version 2 2 Added sql server support 2012 Added graphs charts using direct code and plugin both Added function to set file upload download folder instead of config Added more plugins Fixed small bug of inline edit position when checkbox column and id column is hidden Fixed small bug related to sqlite Version 2 1 Add more options to format table columns fixed small bug related to responsive design fixed bug related to sqlite Version 2 0 Added nested table and nested table in tabs feature Added plugin ckeditor Version 1 9 Added crud table bulk data update operation to change values directly in crud table Added option to import bulk data from csv xml and excel file Added function csvToArray excelToArray and xmlToArray to get these files data in array format Added sumPerPage sumTotal functions Added new form elements e g slider range picker etc currently it works one element per page Added search operator to search using like etc with default operation Added one page template to show Form and Crud Table on single page Added various image functions crop resize thumbnail watermark flip Version 1 8 Advanced filter option is added Added Option to specify col data from another table s column or array Added option to Open insert edit form directly in popup on button click direct popup form was already there Added new column action url function to redirect to another page with primary key Added more options to format table columns date string number formatting Added more parameter options for jQuery date picker Bug fix Fixed a sqlite related bug in PDOModel part Version 1 7 Redirect to another url after form submission Show hide fields with conditional logic this works with database fields only Version 1 6 Added more plugins Image upload path will be added in the saved image url Send form data on email various template customization options Version 1 5 Recaptcha support Option to add hidden fields to save against specific columns Added option to add custom action buttons fixed bug of select action hook data Version 1 4 Added column switch operation Added option to show left join data in view also Many demo forms added More plugins added fixed bug related to join operation Version 1 3 Added option of url in column formatting PDOModel class support is added Fixed bug related to pagination Added more examples Version 1 2 Added extra skins Added french language translations Added some more js plugins Version 1 1 Initial release Min requirement for the script PHP Version 5 3 and above Must have write access for download folder Credits Tcpdf phpExcel PHPMailer