Course description
The course aimed at providing a hands-on programming experience and to equip students with concepts and skills to develop a database-backed, dynamic and feature-rich Web site. The course covers the use of programming language with PHP and the concepts of a database with MySQL. Students will learn the techniques of gathering data from users through Web forms, storing data in a database on the server, retrieving data from database, formatting and displaying the data on the browser. Solutions for practical online services such as session management and user authentication are also discussed.
Course learning Outcome
On successful completion of this module, the student will be able to :
- Understand database application,
- Develop database-backed dynamic Web site,
- Demonstrate JavaScript programming skills for designing dynamic pages,
- Develop server-side scripts using PHP,
- Install and configure a web server on Windows platforms,
- Manage user’s privileges and roles for databases.
- Understand the difference between client and server-side processing.
- Understand fundamental concepts and principles of web programming and relational database systems.
- Select appropriate techniques to solve a given interaction problem in data-driven web applications.
- Analyse and evaluate the extent to which a data-driven web application meets the criteria defined for its current use and future development.
- Ability to design a website and publish it on a hosted server;
- Ability to develop websites using web content management system
- Ability to use start-of-the-art web development techniques
- Ability to Specify, design, construct and test data-driven web applications.
- Ability to select and employ suitable techniques and tools for the design, creation, and documentation of web authoring systems with database components, with particular emphasis on understanding the whole process involved in the effective development of data, has driven web applications.
- Work effectively as part of a team in the planning, development, testing and debugging of a web application.
Course content
- Introduction
- Server side web authoring
- General Syntactic Characteristics, Primitives, Operations and Expressions
- Control Statements Strings, and Advanced Data and Arrays
- Functions & Pattern Matching
- Handling Forms (CGI), submit button, transfer of data, return of results
- CGI scripting using languages similar to Perl, PHP, and ASP.
- Executing CGI scripts from stand-alone and networked clients,
- Files
- PHP
- The PHP Scripting Language;
Manipulation in PHP; Introduction to Object-Oriented Programming with PHP ;
- Validation with PHP and JavaScript;
- Sessions; Authentication and Security;
- Errors, Debugging, and Deployment;
- Reporting.
- Relational Databases and Structured Query Language (SQL)
- Relational database concepts
- Design web database
- Structure query language (SQL) Mysql
- Architectures for Database Access
- Database Integration with Web Application
- Web Programming Project
- Use web programming knowledge to design websites (Practical assignment I and II)
Course reading Materials
Compulsory Reading Materials
- Web Database Applications with PHP and MySQL, 2nd Edition, by Hugh E. Williams, David Lane, Publisher: O'Reilly & Associates, 2nd edition, Published (2004), ISBN 0596005431
- PHP and MySQL Web Development 3rd Edition, by Luke Welling, Laura Thomson, Publisher: Sams, Paperback, 3rd Bk&CD edition, Published September 2004, ISBN 0672326728
- HTML for the World Wide Web with XHTML and CSS: Visual QuickStart Guide, by Elizabeth Castro, Publisher: Peachpit Press, 5th edition, Published 2002, ISBN 0321130073
Optional reading materials
- JavaFX: Developing Rich Internet Applications by Jim Clarke Jim Connors, Eric J. Bruno Publisher: Publication Date: June 11, 2009, ISBN: 013701287X
- Ajax, Rich Internet Applications and Web Development for Programmers by P Deitel, H Deitel; ISBN: 0131587382
- Mobile Web Development: Building mobile websites, SMS and MMS messaging, mobile payments, and automated voice call systems with XHTML MP, WCSS, and mobile AJAX; by Nirav Mehta; Publisher: Packt; Publishing (February 6, 2008); ISBN-10: 1847193439