Advanced Web Programming — DU B.Sc. (Hons) Computer Science Previous Year Question Papers

(iv) Delete a record from the table Library where Book_Id = 1234. (v) Close the connection of the database. Use the following information: Host Name: localhost, Database Name: College, Username: Ust_script, Password: pwd21. Table: Library Book id Book litte Author Pubication ISN Computer Science 4. Parts of a question must be answered together. 1. (a) Give the different types of comments in PHP with their syntax. (3) (b) What is the difference between == and === in PHP? Explain with example. (3) (c) What is a for each loop in PHP, and how is it used? (3) (d) What is JSON? Which function is used to convert JSON object into associative array? Give example. (3) (e) Explain the difference between static and dynamic webpage. Where does PHP fall in this context? (3) (f) Give the output of the following code. (3) (ii) To return the name of the server host. (iii) To return the request method used to access the page. (iv) To return the path of the current script. (v) To print the value of global variable "num". 7. (a) Write a PHP script that creates a new database College (if it doesn't already exist) and then creates a user's table Library within it. The users table should contain columns for Book_id, Book_title, Author, Publication and ISBN. (5) (b) Write a PHP script to :- (10) (i) Insert a new record into a Library table using MySQL. (ii) Update author name to "Rajeev" where (iii) Display Book Id, Book title, Author, Publication and ISBN of all books. (iv) Delete a record from the table Library where Book_Id = 1234. (V) Close the connection of the database. Use the following information: Host Name: localhost, Database Name: College, Username: Ust_script, Password: pwd21. Table: Library Book jid Book titte Author Publication ISBN Computer Science 4. Parts of a question must be answered together. 1. (a) Give the different types of comments in PHP with their syntax. (3) (b) What is the difference between == and === in PHP? Explain with example. (3) (c) What is a for each loop in PHP, and how is it used? (3) (d) What is JSON? Which function is used to convert JSON object into associative array? Give example. (3) (e) Explain the difference between static and dynamic webpage. Where does PHP fall in this context? (3) (f) Give the output of the following code. (3) (ii) To return the name of the server host. (iii) To return the request method used to access the page. (iv) To return the path of the current script. (v) To print the value of global variable "num". 7. (a) Write a PHP script that creates a new database College (if it doesn't already exist) and then creates a user's table Library within it. The users table should contain columns for Book_id, Book_title, Author, Publication and ISBN. (5) (b) Write a PHP script to :- (10) (i) Insert a new record into a Library table using MySQL. (ii) Update author name to "Rajeev" where (iii) Display Book Id, Book title, Author, Publication and ISBN of all books. (iv) To convert string stri to uppercase and lowercase.