PHP Scripts - MySQL database Auto Framework - CodeCanyon
MySQL database Auto Framework his title this type of PHPScripts/DatabaseAbstractions This time I will review,made by yougapi, PHPScripts/DatabaseAbstractions is sold at a price of $9 in CodeCanyon. MySQL 5 // database abstraction // database framework // mysql // mysql database //Created | 14 January 11 |
Last Update | 14 January 11 |
Compatible Browsers | IE6, IE7, IE8, Firefox, Safari, Opera, Chrome 4, Chrome 5 |
Software Version | MySQL 5.x, PHP 5.x, PHP 5.0 - 5.2, PHP 5.3, jQuery |
Files Included | PHP |
This is a professionnal grade MySQL database framework that we have developped and improved for years. It enables you to avoid writing and re-writing all the repetitive SQL queries and all the fetch arrays, help protect you against SQL injections, and offer you a very robust, but simple way to interact with your MySQL 5 databases.
Features:
- Fully object oriented (use classes) - Use one class file per database table - Automatically recognize your database tables and fields. - Automatically generate the tables class files. - Prevent SQL injections my escaping bad characters. - All functions are centralized in one single file. - Supports MySQL 5 and uses MySQLi. - Fully documented. - Open only one MySQL connection per page, and close it at the end.
The installation is very simple: 1/ You need to define your database access information (host, name, username and password) 2/ You lanch the script that recognize your database and generate all the classes for you. 3/ You include the frameword with one single include(); 4/ You can then start using your new framework.
How to use: Let’s suppose you have a table called “article”, containing 3 fields: id, title, description. Just instantialize the class called Article ($a1 = new Article()) and call the methods that you need (to select, update, insert, delete and provide custom queries…)
Full documentation provided with the source code.
No comments:
Post a Comment