WEB DESIGNING USING PHP AND MYSQL (3361603)

 WEB DESIGNING USING PHP AND MYSQL (3361603)

CONTINUOUS EVALUATION  AND SUBJECT PREPARATION

-------------------------------------------------------------------------------- 

Assignment 1

1. What Is Open Source?

2. Explain Following Terms: (A) PHP  (B) Apache (C) MySQL

3. Explain Relationship between Apache, PHP And MySQL in AMP Module.

4. Explain PHP structure and syntax.

5. Explain how to create the PHP pages.

6. Write rules of PHP syntax.

7. Explain how to Integrate HTML with PHP.

8. Explain Constant with example.

9. Explain Variable with example. Write rules for naming variables.

10. Explain static variable and global variable with example.

11. Explain conditional Structure with example.

12. Explain Looping structure with example.

13. Explain various Operators in PHP.

14. Explain Array in PHP.

15. Explain User defined function in PHP.

Assignment 2

1. Explain various variable functions with syntax and example.

2. Explain various string handling functions with syntax and example.

3. Explain various date time functions with syntax and example.

4. Explain various array manipulation functions with syntax and example.

5. Explain various mathematical functions with syntax and example.

6. Explain various file handling functions with syntax and example.

Assignment 3

1. What is HTML form? Explain various attributes with example.

2. Explain FORM elements and INPUT elements with example.

3. Explain the GET Method with an example.

4. Explain POST Method with example.

5. Differentiate between GET and POST methods.

Assignment 4

1. What is Cookie? Explain attributes of Cookie.

2. What is Session? Explain attributes of Session.

3. Explain URL method of passing variables between pages giving example.

4. Explain Cookie method of passing variables between pages giving example.

5. Explain Session method of passing variables between pages giving example.

6. What is error? Explain different categories of PHP Errors.

7. What is exception handling?

8. Explain try… catch giving example.

Assignment 5

1. What is MySQL? Why use MySQL as compared to other RDBMS?

2. Explain features of MySQL.

3. Explain Types of MySQL tables and storage engines.

4. Explain various MySQL data types.

5. How to connect to MySQL using PHP script?

6. How to create a database in MySQL using PHP script?

7. How to select a particular database in MySQL using PHP script?

8. How to delete database in MySQL using PHP script?

9. How to create a table in MySQL database using PHP script?

10. How to insert records in table in MySQL database using PHP script?

11. How to update records in table in MySQL database using PHP script?

12. How to delete records in table in MySQL database using PHP script?

13. How to display all records in a table in MySQL database using PHP script?