A PHP 5 library that allows you to easily create and run both simple and advanced MySQL queries in an object-oriented fashion, without using any SQL and without sacrificing functionality. Query types supported include:
- Select
- Join
- Insert
- Update
- Delete
- Create Table
- Alter Table
- Rename Table
- Truncate Table
- Drop Table
Additional features:
- Uses prepared statements
- Automatically cleans values to prevent SQL injection
- Object-oriented structure makes it easy to extend with custom functionality
- Code is well-commented and has great documentation:
- http://beakerstudio.com/mysql
- http://beakerstudio.com/mysql/api/packages/Default.html
What people are saying:
“This script is excellent. Simple and amazing for quick and not-so-dirt job.” – internavigare
I’ve just bought it. Playing with it for a while and it’s great, btw, I would love to see the “group by” function as well.
Good luck to your sales – youngguy
That’s great thanks, great script by the way it has been so useful. – dutchboy2382
Requires PHP version 5.1 or higher, with PDO installed.
Updates
- September 24, 2012: Fixed a couple small bugs.
- June 16, 2012: Fixed small method naming error.
- June 12, 2012: Added support for
SUM(), AVG()
, and grouping AND/OR clauses (e.g., (w and x) or (y and z)).
[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 = PHP MySQL Helper Library
[eltd_button size=”huge” type=”” text=”Full Live Demo” custom_class=”” icon_pack=”font_awesome” fa_icon=”fa-laptop” link=”https://codecanyon.net/item/php-mysql-helper-library/2436806″ 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 PHP MySQL Helper Library from the The Developer ( Beaker_Studio ) website. Thank you.
Download = PHP MySQL Helper Library-[Updated].zip