Practical Tasks

Tasks instructions: Please give the solutions to the following tasks.

None of the following are conceptual/knowledge "question and answer" type of written tasks. They all have practical part that requires the solution coding samples. The solution coding can be from your project, your class exercises, or from an example solutions in your reference books or other tutorial resources related based on which you have practiced in preparation of doing your project.

Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for all the following.

Note: Important, please do not mistake the following tasks as "question and answer". None of them are questions; they all have practical part, which requires the evidences (either screenshots or code example.)

1. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:
(4 Marks)

The implementation of MySQL database insert and update inside PHP coding.

2. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:

The implementation of MySQL database select (with "ordered by" sorting feature) and MySQL delete.

3. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:

Simple PHP overloading.

4. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:

Why do we need PHP exception handling in PHP coding? Please list 5 exception handling methods. Give one example of basic use of exception.

5. In object-oriented programming I, we have explained how to set up a PHP class to represent and store the components of the structure of a webpage to meet the requirement of the project. Suppose the values of these components are to be stored in a MySQL tale, please propose the structure of such a table.

The description of this task must be demonstrated in the context of the understanding of the difference between small sized and medium-sized application programming, or sequential and object oriented programming, ie, the concept of object-oriented programming and language (PHP) that support it.

6. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:

A PHP class being intertied multiple inherited. (Hint: new objects created for index.php and about_us.php for instance).

7. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following:

Database connection routine in PHP coding.

8. Please explain the advantage of using MySQL transaction and its integrity? Please give an example.

9. Usethe following example, explain the process and techniques related to the use of a graphical user interface (GUI), to accommodate the interaction between an operator inside the client's company and the database where the information of the webpage is represented.

Please giving one example of interface building using PFBC (PHP Form Builder Class)? (You can refer to the examples from: https://code.google.com/p/php-form-builder-class/)

10. Please provide and name and web address of two stand-alone PHP debugger (or Debugging Tools)? Giving one example of the logic and coding error identification; one example of detection and correction of error.

11. Please give an example of testing with SimpleTest? (Please refer to the examples from: www.simpletest.org)

12. During testing of your PHP project, you might be using either of the flowing:

- Smoke Testing
- Functionality Testing
- System Testing
- Retesting
- Regression Testing
- Performance Testing
- Please give an example of Smoke testing or Regression testing procedure

13. Usethe following example, outline and explain the techniques to document applications/programming.

Please give an example of the use of API and phpDocumentor in PHP project?

Note: The following assessment task should not be considered as question and answer tasks. You are required to provide evidence that you not only understand the relevant knowledge, but also evidence that you can process the relevant required procedures.