Php MySQL

Assignment 2

Weight: 20% of your final grade

Due: after completing Unit 4 and 5

Instructions and General Requirements

This assignment has two parts. In the first part you are required to complete a small web application development project. For the second part, you will design and implement a web application for e-learning using the web technologies you have learned so far, including HTML5, CSS3, Ajax, XML, databases for the Web, and server-side scripting with PHP for the Web. The general requirements for the assignment are as follows:

• As for the first assignment, write all of your HTML, PHP, and SQL documents using a plain text editor such as Notepad++ or TextEdit.
• Plan carefully, and pay attention to both the functionality and the visual design of all your web pages.
• For this assignment, you don’t have to validate your web documents, but you still need to test all your web applications on your personal web server to ensure that they work.
• Use the same external style sheet in all your pages to ensure your assignment site has a consistent look and feel.
• Please refer to Assignment 1 for file organization and setup of the tma2.htm main page (10 marks). As for Assignment 1, the main page should include the following:
• assignment number, course number and name, your name and student ID number
• documentation required for each part of the assignment, including hyperlinks to the web applications you design for each part
• your interpretation of the assignment question and requirements
• a note on the design and implementation of the web application
• a guide for users (the tutor who is marking the assignment) to set up and run the web application

All the web applications and notes you develop for each part of the assignment must be accessible from the tma2.htm page.

Submit your assignment as a zip file called TMA2.zip.

   Important: All work submitted must be original, and no codes or packages from a third party should be used unless it is explicitly allowed in the assignment instructions. See the Athabasca University policy on intellectual honesty.

Part 1

(30 marks)

Develop a web application that provides an online bookmarking service using MySQL and PHP.

• Create two tables: the table user for user account management and another table to store information about URLs that the users want to bookmark when they surf the Web.
• (5 marks) There should be a well-designed interface for the system
• (10 marks) The system should have modules for user registration and login, so the system is protected.
• (10 marks) Once a user has logged in, s/he should be able to view a list of bookmarks in his or her account. S/he should be able to select one or more of the bookmarks to modify or delete, and also add new bookmarks.
• (5 marks) Once the user clicks a URL in the bookmark list, a new browsing window should open for the user to browse the web pages identified by the corresponding URL.

Save Part 1 files in the directory TMA2/part1.

Part 2

(70 marks)

For this part, you need to design and implement an e-learning system using the web technologies you have just learned including MySQL and PHP. In addition to what you have read for developing the online tutorial in the previous assignment, you may need to do more research about e-learning technology, including learning objects, educational markup languages, etc. The requirements are as follows:

• Database design (10 marks). At the back end there should be databases for storing learning objects including texts, images, questions and answers, problems and solutions, quizzes, etc.
• Markup language (10 marks). In the database there should be some pieces of hypertext in an educational markup language. Take a look at existing educational markup languages EML (Educational Modeling Language), etc., and then make a simple markup language of your own, which should have at least ten tags directly related to education. The hypertext in an educational markup language can represent a teaching session, a unit, a course, a quiz, an exercise, an assignment or project, or describe what learning objects (also stored in databases) are used and how they are related (the simplest relationship is sequential). See lml for an example of an educational markup language.

  This practice will help you understand the essence of markup languages and how to devise your own markup language for a specific purpose and use it. This will also prepare you to study XML in a later unit.

Present your educational markup language by showing all the tags and explanation of their intended purpose with examples, and the design of the tables in an assignment report.

• Parser (20 marks). On the server side, write some PHP scripts to parse the pieces of hypertext taken from database into HTML documents that can be rendered by web browsers. Don’t be afraid of writing a parser for this purpose! It can be as simple as using some PHP regular expression functions to do pattern matching and string replacement.
• Interface (10 marks). At the front end, the client side, provide the learners with a friendly interface so that your online course content can be easily navigated.
• Quiz (10 marks). Present at least one online quiz.
• Content (10 marks). Put enough content from both Unit 4 and 5 of the course into the database that your system can be tested.

Test both parts of the assignment on your own server before you submit them. Make the websites developed for the assignment accessible for your tutor for assessment. For your personal protection you should not put your name and student ID on an unprotected web site, and after your tutor has assessed your work, you must remove all the assignment documents from the site.

Submit all the SQL scripts and database files as well as the assignment report all together with the files for the e-learning system for your assignment to be assessed.

Save Part 2 files in the directory TMA2/part2.