v2.1 Updated PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Subscribe to updates

Get notified by email if this item is updated

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

389 832 20
4.7 out of 5 based on 44 customer ratings
(44)

25$ Free Trial Version Coming Soon

PDOCrud is an advance PHP based CRUD application. It supports Mysql, Pgsql and Sqlite database. By writing just 2-3 lines of code only, you can perform insert/update/delete and select operation. You just to need to create object and call for render function for that table and everything will be generated automatically.

Compare

Live Preview Buy item ApiTrade

Version: v2.1
Created: 1 September 2016
Last Update: 7 January 2019
Author: ddeveloper

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Build powerful CRM, web application, forms using PDOCrud super fast

PDOCrud is an advance PHP based CRUD application. It supports Mysql, Pgsql and Sqlite database. You can use PDOCrud to generate both frontend and backend of your application.
By writing just 2-3 lines of code only, you can perform insert/update/delete and select operation. You just to need to create object and call for 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 type of fields and can do various types of customization.

You can build forms directly from database tables in few seconds just by writing 2-3 lines of code. All insert/update/delete/view code is managed by the script.

Demo url

Documentation url

Basic Details

Youtube – How to develop web application in few mins using PDOCrud

Script functionality

Almost in each web application, we need to write many-many lines of codes to perform insert, update, delete and read database
tables operations. PDOCrud script does this work by just writing 2 lines of code. This will do add, edit, update and delete basic operation along with several other operation, 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 line of codes. Many javascript plugins are also added that help to perform many other tasks also. Script has many features to ease the development process. You can build simple web application and backend cms using the script easily.

Code example

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Features

  • 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 commanly 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 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
    1. Very easy syntax and just 2 lines of code for default crud operations
    2. Generate forms directly from database
    3. WordPress Plugin for PDOCrud



      Version 3.6 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. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

      Prices are going to increase after next version release

      Version details

      Version 3.5 – (changes in config file)

    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

    Software Version

    PHP 5.3, PHP 5.4, PHP 5.5, PHP 5.6, PHP 7.x

    Files Included

    JavaScript JS, CSS, HTML, PHP, SQL

    High Resolution

    No

    44 reviews for PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

    1. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    2. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    3. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Great app and great aftersale support. Thanks for your great job!

    4. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      4 out of 5

      :

    5. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    6. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    7. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    8. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      3 out of 5

      :

      Although there are some useful aspects to this library, much feels incomplete. The documentation is sadly lacking: e.g. the API function descriptions don’t describe the function or parameters. There are many examples, but many have basic syntax errors (e.g. More Crud Table Formatting Options). Other examples don’t actually exemplify, eg the JOIN example doesn’t display a joined result. I’m still not sure JOIN is actually supported. Oh and there doesn’t seem to be support for ENUM fields either, so you are forced to copy and maintain ENUM values in two places. I can’t see how to control column order without copying and maintaining column lists in two places. In many cases to get simple things accomplished I had to edit the PHP code or supplied CSS skins. That means an upgrade will wipe out my work. The author will tell you to go write CSS if you want to adjust the formatting, but there is no documentation of the CSS classes used. You’ll have to reverse engineer it all. I’ve seen the color of text change when making API calls, indicating CSS bugs. The price is low, but you get what you pay for. Beware.

    9. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    10. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Perfect support. Very fast.

    11. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      The script too much useful for all and easy to use and will make your life better 🙂

    12. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Code maintained until this year. This is very good support from you. Thanks!

    13. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      1 out of 5

      :

      Just horrible in my opinion. Bought but won’t use it.

    14. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      1 out of 5

      :

      too many bugs and poor support

    15. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    16. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Great Component and a true time saver. Good Support. Best thing I bought since long time!

    17. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    18. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Great product.

    19. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    20. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    21. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Great communication from developer, offered to improve the documentation and tutorial.

    22. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Einfach SUPER

    23. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Easy to work with

    24. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    25. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    26. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    27. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Good

    28. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    29. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    30. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    31. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      4 out of 5

      :

    32. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    33. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    34. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    35. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    36. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      4 out of 5

      :

      author is there always to help

    37. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Goo script

    38. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Awesome work!

    39. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    40. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

    41. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      wonderful

    42. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Have tested twice (including the latest version) on PHP 7.0. Works beautiful.

    43. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Everything from the developer is great.

    44. PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)
      5 out of 5

      :

      Great support and very good product !

    Add a review

    Your email address will not be published. Required fields are marked *

     

    Coming Soon

    Dear users, an information about trial version is unavaible. We are working on solving this problem and soon information will be provided.

    Please visiut us after a few days.