|Last Updated||Ratings||Unique User Downloads||Download Rankings|
|2013-09-03 (4 years ago)||Not yet rated by the users||Total: 282||All time: 7,285 This week: 644|
|usetiful 1.0||MIT/X Consortium ...||5.1||PHP 5, Databases, Code Generation|
This class can generate DAO (Data Access Object) classes to access objects in a MySQL database.
usetiful - Php / Mysql Dao Generator ======================================== What Usetiful?<br/> Usetiful is a beatiful useful class generator for Php / Mysql. It allows you to create the classes for Create, Read and Update Mysql records. Why Usetiful?<br/> The main purpose is to avoid writing many lines of code, saving your time. How Usetiful?<br/> it's really easy to use. Download the zip file, extract it to the root where you want. The Steps are the following: - create a simple Php file (see the example below); - include usetiful class (file you have downloaded); - istantiate the object passing all the required variables in the constructor; - enjoy your created classes! ^_^ ================ Example: <?php<br/> include_once 'usetiful.php';<br/> $server = "127.0.0.1"; //where your db is...<br/> $username = "root"; //db username<br/> $password = ""; //db password<br/> $schema = ""; //db name / schema<br/> $project_name = "folder1"; // where you would like to create your project folder <br/> $mp = new Usetiful($server, $username, $password, $schema, $project_name, $table = false);<br/> ?> IMPORTANT: For the correct execution of Usetiful you must have the mysql priviliges to select information_schema and possibly you should have administrator privileges of the webserver (also local) Usetiful creates a folder containing some files (the first 3 are the fundamentals layers): - Class.Actions.php - Class.Business.php - Class.Persistence.php - Class.DaoUtils.php - Class.Email.php - Class.Html.php - Class.Trigger.php - Class.Validation.php - Constants.php It also creates one folder for each mysql table found containing a sample index.php page that shows you how easy it is now to create a select statement (just done). Usetiful - files created. Class.Actions.php: This is the entry point. There are the methods to perform CRUD any calls or other. By instantiating the Action object you'll get what you need. Class.Business.php: Classes accompanied by their respective getters and setters methods already written. Beautiful is not it? Class.DaoUtils.php: Connection to db. At the moment is still used the connection method mysql_connect. Will be replaced in the shortest possible time. Class.Email.php: Send emails based on standard class Mail php. Class.Html.php: A very small html framework that might be useful to build pages quickly. Class.Persistence.php: The class that contains the heart of the application. Contains the CRUD (CRU) and some methods for queries. Class.Trigger.php: A support class that could serve for handling exceptions Class.Validation.php: A class designed for server-side validation of the fields. Not fully implemented yet. Constants.php: A small class of constants.
|Version Control||Unique User Downloads||Download Rankings|
|User Comments (2)|