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

Basic Examples

PDOCrud is a PHP crud application with many features and 100's of demo's examples. To simplify it and to make it easily understandable specially the core features, we have added this page. This page basically describes most useful features of PDOCrud with demo page urls. Please note that we have separate demo and documentation with many examples of different features available in PDOCrud. We have covered each feature with an example code in demo pages.


Here is list of some of the major functions of PDOCrud


Version 3.7 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 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)

Version 3.3 – (changes in config file)


Please take complete backup before upgrade.(Make sure to clear cache after upgrade)

Version 3.2 – (changes in config file)


Please take complete backup before upgrade.(Make sure to clear cache after upgrade)

Version 3.1 – (changes in config file)


Please take complete backup before upgrade.

Version details

Version 3.0 – (changes in config file)


Please take complete backup before upgrade.

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