DOWNLOAD PDO Crud – Advanced PHP CRUD application (Database Management System)
Build powerful CRM, web application using PDOCrud super fast
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. 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.
Version 2.0 is released with most awaited feature of nested table and nested table in tabs
Details
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
Features
- Very easy syntax and just 2 lines of code for default crud operations
- Generate forms directly from database
- Multiple Skin support
- 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
Version 2.1 is under progress. Please drop me email with your features you need. Version 2.0 submitted for review with major feature => nested table feature and few more other features . Thanks everyone for your awesome support. Your great review and feedback made us to add more and more features.
Version details
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
0 nhận xét:
Post a Comment