Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Open Source Business Solutions: A Case Study and Application of SQL & PHP

Open Source Business Solutions: A Case Study and Application of SQL & PHP
View Free PDF
Author(s): Dan Clark (Western Michigan University, USA)and Alan I. Rea Jr. (Western Michigan University, USA)
Copyright: 2003
Pages: 1
Source title: Information Technology & Organizations: Trends, Issues, Challenges & Solutions
Source Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59140-066-0.ch303
ISBN13: 9781616921248
EISBN13: 9781466665330


PHP (PHP: Hypertext Preprocessor) is a powerful scripting language that is designed to allow web developers to quickly and easily create dynamic web sites. PHP is among the most widely used scripting languages on the web. It is often used to create web-based database front-ends to simplify database administration. Many business problems can be addresses effectively and efficiently using open source solutions based on PHP and SQL. The three characteristics of PHP that make it a highly desirable choice for many web developers follow: 1) It is a free, open-source project 2) It is a server-based scripting language 3) PHP’s relative ease of use When PHP is combined with HTML (Hypertext Markup Language) and an SQL (Structured Query Language) based database, the possibilities are nearly endless for professional web developers. One popular application based on PHP and SQL is trouble-ticket software for help desk or problem tracking. The final paper will focus on the benefits, problems and requirements for successfully implementing a PHP driven front-end to an SQL database; specifically a database designed to track help desk trouble tickets. This paper will allow us to better understand the challenges and opportunities facing a business when implementing an open source system.

Body Bottom