Wawasan Open University is Malaysia’s first private not-for-profit tertiary institution dedicated to adult learners.

It is funded by the Wawasan Education Foundation, a tax-exempt entity established by the Malaysian People’s Movement Party (Gerakan) and supported by the Yeap Chor Ee Charitable and Endowment Trusts, other charities, corporations, members of the public and occasional grants from the Government of Malaysia.

The course material development of the university is funded by Yeap Chor Ee Charitable and Endowment Trusts.

Wawasan Open University’s Introduction to Web Development and PHP Course Overview

Welcome to TCC 242/05 Web Database Application.

This is a course that emphasises both theory and application. It introduces the concepts, methods and software that will help you create web database applications.

A web database application is a database-driven web application that enables websites such as online shopping, Internet banking or social networking sites to be created. In this course, you will learn how to build web database applications that incorporate authentication and security, and that adhere to industry standards with respect to database-driven websites.

This course module has five study units. Each unit takes three to four weeks to complete. The course is structured so that each unit builds on previous ones.

In Unit 1, you will be introduced to the fundamentals of web application development, web servers and the syntax of the PHP scripting language. PHP is a powerful server-side scripting language that allows you to build dynamic websites. You will also be shown how to install Apache web server, PHP and MySQL on your computer.

Unit 2 will focus on the basics of PHP. Here, you will learn PHP data types, customised functions and control structures.

Unit 3 will discuss the intermediate-level features of PHP such as strings, arrays and files.

The discussion of database integration begins in Unit 4. You will learn how PHP interacts with MySQL and MySQL library functions.

The final unit of this course will cover the principles of using sessions and cookies for saving state information on a web page.

The material in this module is presented in a simple, step-by-step format, and it includes many examples and web programming exercises. Each unit has specific objectives, activities and self-tests. The activities and self-tests allow you to check your progress and improve your understanding of what you have learnt. The practice exercises at the end of each unit allow you to practise the skills that you have learned so that you can develop proficiency in real-world problem solving.

By the end of this course, you should be able to:

  1. Install and configure Apache web server, PHP and MySQL.
  2. Create a web database application incorporating functions and control
    structures using PHP.
  3. Manipulate strings using PHP.
  4. Handle web form submissions.
  5. Work with database records and manage user accounts.
  6. Use PHP to manipulate database records.
  7. Use hidden forms, query strings, cookies and sessions to save state
    information.
Wawasan-IntroWebDatabaseApplication