Manipulate with your data using simple methods
Powerful actions in simple Active Record style. No any SQL writing. Fast and low-memory usage, compact and cleaner resulting code
Features
- Simple insert, update and delete
- Batch inserts and updates
- Where conditions and fulltext search
- Sorting and grouping
- Joins of multiple tables
- Foreign keys updating
- Checking the uniqueness of records
- Concatenation and group concatenation
- Min, max, sum and total
- Increments and decrements
- You do not need to remember about tildes and quotes
System Requirements
- PHP5
- MySQL5
- MySQLi extention
Changelog
v.1.0.6
- Concat() fixed.
v.1.0.5
- Insert() fixed.
v.1.0.4
- Minor fixes in where() method.
- Added new methods open_sub() and close_sub() – creating sub-conditions between where() parts.
v.1.0.3
- ‘Like’ methods fixed.
- Added order_by() method (alias of sort_by()).
v.1.0.2
- New methods get_list() and get_single().
- Added ‘alias’ parameter in join methods.
- Random fixed. Other minor bugs fixed.
v.1.0.1
- get_one() and fields() methods fixed.
- Added new method distinct().
Suggestions and comments are welcome.
Documentation
[eltd_button size=”huge-full-width” type=”outline” text=”Download & Demo Links” custom_class=”#” icon_pack=”font_awesome” fa_icon=”” link=”” target=”_blank” color=”” hover_color=”” background_color=”” hover_background_color=”” border_color=”” hover_border_color=”” font_size=”” font_weight=”” margin=””]
Demo = Simple Database Abstraction for PHP and MySQL
[eltd_button size=”huge” type=”” text=”Full Live Demo” custom_class=”” icon_pack=”font_awesome” fa_icon=”fa-laptop” link=”https://codecanyon.net/item/simple-database-abstraction-for-php-and-mysql/3703887″ target=”_blank” color=”” hover_color=”” background_color=”” hover_background_color=”” border_color=”” hover_border_color=”” font_size=”” font_weight=”” margin=””]
Kindly Note: We update new contents like WordPress Themes, Plugins, PHP Scripts everyday. But remember that you should never use this items in a commercial website. All the contents posted here for development & testing purpose only. We’re not responsible for any damage, use at your own RISK! We highly recommend to buy Simple Database Abstraction for PHP and MySQL from the The Developer ( f0ska ) website. Thank you.
Download = Simple Database Abstraction for PHP and MySQL-[Updated].zip
