Chris Pollett >
Students > [Bio] [Intro to jQuery and YUI - PDF] |
CS297 ProposalWeb-based IDE to create Model and Controller Components for MVC-based Web Applications on CakePHPSugiharto Widjaja (sugi@widjaja-online.com) Advisor: Dr. Chris Pollett Description: The goal of this project is to develop a Web-based IDE that allows users to create Model and Controller components in a MVC-based Web applications in CakePHP. The IDE will allow users to use drag and drop to create database tables that they can use for their Web applications and they need not know any SQL queries. When the user created a model in the GUI online tool, the table should be created in the database. In addition, a simple php model file should be automatically created. The IDE should also allow users to build queries to perform various SQL operations (such as: select, insert, update, and delete). It should also create a php controller file that includes all the queries that the users have built. This project will be built by utilizing CakePHP framework and jQuery. By using this IDE, users can build dynamic database-based Web applications without having to know any SQL queries. Schedule:
Deliverables: The full project will be done when CS298 is completed. The following will be done by the end of CS297: 1. Write a simple PHP application in CakePHP that utilizes the jQuery drag-and-drop feature. 2. Write a Web application to create DB tables with their attributes. The application will utilize the drag-drop- feature from jQuery. 3. Write a simple Web application that demonstrates the usage of QBE. This application will use static tables. 4. Write a Web application that allows users to create DB tables with their attributes, link them to crete QBE, and construct SQL queries. (Integration of deliverable 2 and 3) 5. CS 297 report due. References: CakePHP Manual. Retrieved December 7th 2009 from CakePHP Website: http://book.cakephp.org/ YUI 3 - Yahoo! User Interface Library. Retrieved December 7th 2009 from Yahoo! Developer Network: http://developer.yahoo.com/yui/3/ [2002] Database Systems: The Complete Book. Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom. Prentice Hall. 2002 [2005] Database System Concepts. Avi Silberschatz, Henry F. Korth, and S. Sudarshan. McGraw-Hill. 2005 |