xCRUD is a simple-usage but powerfull Create-Read-Update-Delete (CRUD) generator application for PHP and MySQL. The application offers you many ways to work with your data and scaffolding, while remaining very easy to use even for non-programmers. Content management becomes simple and flexible, hours of saved time, minutes to implement. You can use it as plain php library or with your favorite framework and cms.
Documentation
Features:
System Requirements
- PHP 5
- MySQL 5
- mysqli extension
- mbstring extension
- native PHP sessions (or Memcache(d) + mcrypt)
Documentation
Changelog:
v.1.6.26- $can_minimize option fixed.
- Timestamp -> time type change fixed.
- column_width() style fixed.
- Validation language bug fixed.
- Search collation conflict fixed.
- Not null fields is required (can be disabled from config).
- Tree view in relation list fixed.
- Some search issues resolved.
- *Fixed encoding issue.
- FK-relation() fixed.
- Relation details view fixed.
- Date ranges fixed.
- Google map rendering fixed.
- Modal js error fixed.
- Ordering and prefix conflict fixed.
- Alert() fixed.
- SSL incorrect urls fixed.
- Ordering by related field fixed.
- Printout enumeration fixed.
- New method create_field(), allows to create custom field in form and not in the database.
- Disabled and readonly will be checked in server-side.
- Additional parameter for join() disable creating new rows and deleting from joined table.
- Added url parameter for uploads. Now url to a file or image can be real.
- Additional magic_quotes conditions.
- Timestamp in integer field fixed.
- Prefix in search fixed.
- Column_tooltip() fixed.
- Few small fixes.
- Condition() method fixed.
- Set exception can prevent remove action.
- Grid name uses for csv file name.
- Upload readonly bug fixed.
- Fk_relation() view fixed.
- Nested table can be related to field from joined table.
- Cropper stretch bug fixed.
- More changes in bootstrap theme.
- Csv export fixed (columns ordering).
- Dates fixed.
- $postdata object removed methods as_date(), as_datetime(), as_time(). Now dates are allways return correctly in mysql format.
- Date and time empty values fixed.
- Deleteing fixed.
- Validation on return fixed.
- Fk_relation() label concatenation fixed.
- Added new javascript events: xcrudbeforevalidate, xcrudaftervalidate.
- Visual fixes and changes in bootstrap theme.
- Added new method unset_list().
- Remote_image link fixed.
- Href and src attributes fixed.
- Corrections in column_pattern().
- Query() fixed (Group by and total rows issue. Column pattern).
- Default search field fixed.
- Int and Float fields fixed.
- Column_pattern can be used correctly with relation().
- Google maps loading fixed (in tabs).
- JqueryUI window centering fixed.
- Editor auto loading can be turned off from configuration.
- Extended XSS filter options available in configuration file.
- Optgroup is available in dropdowns.
- BLOB file upload fixed.
- Where() method fixed.
- Added filename parameter for file type.
- Duplicate_button() fixed.
- Data and pass_var() bug fixed.
- Date range fixed.
- Price default fixed.
- Duplicate button fixed.
- Search date ranges fixed.
- BIGINT type casting fixed.
- Added point parameter in price type.
- Additional XSS auto-filtering.
- Grid rendering fixed. New render parameters in configuration file.
- New method set_attr().
- Join() bug (on edit) fixed.
- Negative timestamp issue fixed.
- Search dropdowns fixed.
- Search inputs value escaping fixed.
- Added error message when xcruds scripts loaded twice.
- Hidden fields in custom templates fixed.
- Highlight_row() classname fixed.
- Google map via https fixed.
- Completed before_update, after_update and after_resize callbacks.
- Load_css() and load_js() methods improved. Now paths works propertly with $manual_load.
- New WordPress plugin! Now plugin automatically includes xcruds styles and scripts in wp_head() and wp_footer().
- Password bug (no encryption) fixed.
- DATE/TIME MANIPULATIONS (CALLBACKS AND PASS_VAR()) SWITCHED BACK TO MYSQL FORMAT!!!
- Postdata items got new methods as_date(), as_time() and as_datetime(). THis will help you to receive dates from $postdata object.
- Printout(short tag) fixed.
- Fixed some typos in documentation.
- Many-to-many relation are available now. See fk_relation() method.
- Subselect() label fixed.
- Dependent dropdowns (multi) fixed.
- Editor loading fixed.
- Bit field casting fixed.
- Image removing fixed.
- Dependency fixed.
- Columns reverse fixed.
- Default_tab() fixed.
- Column_pattern() fixed.
- String 0 bug fixed.
- Password type bug fuxed.
- Checkbox fixed.
- Fixed some internal bugs.
- RTL rendering, can be enabled in configuration file.
- Now you can use xCRUD as simple datagrid with custom sql query. See more in documentation.
- Condition() method fixed.
- Read-only, if primary not exist.
- Column_callback() and column_pattern() in detail view.
- Default_tab() method and $default_tab option added.
- Nested table will be displayed in tab if you use tabs.
- Some fixes in result html.
- Added prefix support for table names.
- Unique checking bug fixed.
- Joomla 3.2 integration plugin.
- Automatic url detection fixed.
- Map fixed.
- Minor changes in js events.
- New method set_exception() is available in callback functions.
- Validation now is checks data on server side too.
- $postdata variable is object now in callbacks. Check your custom functions.
- JS alerts replaced with message bars.
- Unset_edit() condition fixed.
- Links_label() fixed.
- Changes in upload sheme.
- Classname parameter in sum() method fixed.
- Added codegniter integration examples.
- Urgent bugfix: image uploads.
- Printout return fixed.
- Some improvement of compatibility with frameworks.
- Nested table CKEditor bug fixed.
- Column callback csv fixed.
- Release of new xCRUD 1.6. From this moment v.1.5 is deprecated.
Tags: php ajax crud datagrid, crud php mysql, php crud application, php crud grid, simple php crud, crud php script, php crud class, mysql datagrid, php data grid, php grid generator, php content management, php database manager, data management php, scaffolding php, php crud generator, php datagrid mysql, jquery grid php, crud builder, form builder
