Design and Development of Auction System in PHP and MySQL
The aim of this project is to design, develop and implement an auction system using PHP as the scripting or programming language and MySQL for the storage or database of the system. An auction system is a platform for everyone where users can post an auction item that includes the image, description and other details for other users to place a bid to purchase the item. This document will present and discuss the introduction of the study, objectives of the study and the development tools used for the said project.
Nowadays, computerization plays a big role in the society especially in the world of business and industry. In today’s businesses which process a huge amount of information, it is essential to do the task using computers to make it more accurate and secured.
Auction System is an online application that let the auction admin to list and categorizes items for auction, create starting bids, create guest lists and bidding sheets, associate specific bids with specific items and close the auction for processing results.
The researchers came up with an idea to design, develop and implement an online auction platform that can help the buyer and seller to transact in an electronic and secure manner which is more convenient and efficient compare to the tradition auction system.
Objectives of the Study
The end results of the study/project are to design, develop and implement an auction project based on the requirements and specifications of our client. It is also aim to test, evaluate and put the project in a live server.
Specifically, the study will be able to:
- Provide an efficient and secure manner of transaction between the buyer and seller.
- Provide a back office system for the administrator to fully control the operations of the system.
- To provide a feature that will be able to sort the items by such things as price, proximity to the user.
XAMMP. Cross platform package software containing apache web server, MySQL, tomcat, FileZilla and Mercury. Use to run php, Perl and java programs via local server (quora.com).
Brackets. Modern text editor uses for the web development and understand web design (brackets.io).
Bootstrap. Bootstrap is an open source toolkit for developing with HTML, CSS, and JS. Quickly prototype your ideas or build your entire app with our Sass variables and mixins, responsive grid system, extensive prebuilt components, and powerful plugins built on jQuery (getbootstrap.com).
CSS 3. CSS is the language for describing the presentation of Web pages, including colours, layout, and fonts. It allows one to adapt the presentation to different types of devices, such as large screens, small screens, or printers. CSS is independent of HTML and can be used with any XML-based mark-up language (w3.org).
PHP. Stands for “PHP: Hypertext Preprocessor” is a programming and scripting language to create dynamic interactive website. PHP is also an Open Source is a server side programming language. When a user requests a web page that contains PHP code, the code is processed by the PHP module installed on that web server. The PHP pre-processor then generates HTML output to be displayed on the user’s browser screen. (www.wpbeginner.com)
MySQL. MySQL is a free, open-source database management system (DBMS for short). A DBMS is a system that manages databases and connects them to software. (www.google.com)
Method of Research
The researchers will use the developmental method of research. Developmental research is particularly important in the field of instructional technology. The most common types of developmental research involve situations in which the product-development process is analyse and described, and the final product is evaluated. A second type of developmental research focuses more on the impact of the product on the learner or the organization. A third type of study is oriented toward a general analysis of design development or evaluation processes as a whole or as components (www.eric.ed.gov).
Software Development Life Cycle using Rapid Applications Development
Analysis and Quick Design
During Analysis and Quick Design, the researchers did a personal interview with the respondents and the chosen client where the study was conducted. The respondents were given the chance to suggest how the system will be designed. After conducting the data gathering, the researchers made a prototype of the system.
The researchers will start to build the proposed system. It includes the design; how the system would look like based on user requirements, and the researchers/programmer would like to add personal design to make the system more interactive and user friendly.
The prototype will be presented to the client for demonstration purposes. This phase also help the researchers to have an idea on how to create the system and have an idea on how the proposed system would be beneficial to the clients.
This stage will include the compiling, building, demonstration also refinement of the data gathered by the researchers. The researchers first build a prototype based on the planned design and data tables. After building the prototype it will be demonstrated to the client. The researchers show the function of the system, the flow on how it works, and the functions of the features that are included in the system. The last stage is refinement where in the researchers will refine the system by client’s additional needs. This will include changes in features flow and functions based on the requirements.
This will include the feed backing of the proposed system after it will be implemented and had undergone testing by the client. It will also inform the researchers and the developer if there are any bugs, suggestion and if the system’s functionality will works well.
This will discuss the implementation of the proposed system wherein IT Experts will evaluate the proposed system. This will also discuss if the recommended functions and suggestion are met.
After the testing and suggestions were incorporated in the system, the project will now undergo the live encoding or actual data will now be inserted in the project.
This is the phase where new features and improvements to the project will be added.