MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to accept a string and then display each word of string in reverse
order by using a self-processing form. [8 Marks]
Q2. Write a PHP script to read a flat file “[Link]”, calculate the percentage and display the data
from file in tabular format. [Link] file contains rollno, name, marks of OS, WT, DS,
Python. [14 Marks]
Q3. Viva [3 Marks]
-1-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create HTML to accept ausername. On submit buttonclick,store theusername in the session.
Create another HTML containing a button as “Get User”. On click of it display
username from t h e session.
[8 Marks]
Q2. Design the Item table in PostgreSQL Item (id, name, price, rating).
Write a PHP script to display the details of Item table in tabular format. [14 Marks]
Q3. Viva [3 Marks]
-2-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Design HTML to accept a number from the user. Write a PHP script to display Fibonacci
Series. (Use the concept of self-processing page.) [8 Marks]
Q2. Write a menu driven program to perform various file operations. Accept filename from
user.
a) Display type of file.
b) Display last modification time of file.
c) Display the size of file. [14 Marks]
Q3. Viva [3 Marks]
-3-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create JSON Object and JSON schema for a Book with the following attributes:
Book (bookno, b_name, pub_name, b_price) [8 Marks]
Q2. Write AJAX program to read a text file and display the contents of the file when the user
clicks on the “Display” button. [14 Marks]
Q3. Viva [3 Marks]
-4-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Design HTML page to accept the temperature in Celsius from the user. Display
temperature in Fahrenheit using a PHP script. Also, validate the user input.
[8 Marks]
Q2. Write a PHP script to read two file names from the user and append the content of first file
into second file. [14 Marks]
Q3. Viva [3 Marks]
-5-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create JSON Object for Person.
Person (firstname, lastname, age, address)
For address create nested structure:
Address (streetaddress, city, state, postalcode) [8 Marks]
Q2. Create Emp table in PostgreSQL as (Eid, Ename, Salary). Write a PHP script to accept
salary from user. Get the details of Employees from database whose salary is greater than
accepted salary. [14 Marks]
Q3. Viva [3 Marks]
-6-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a program using CodeIgniter create a CSS file and apply the styling as <h1>. This
page is blue in color and also apply background color to blue. [8 Marks]
Q2. Design HTML page to accept username, age, email-id. On “Submit” display details by using
self-processing page and sticky forms in a PHP script. [14 Marks]
Q3. Viva [3 Marks]
-7-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create JSON Object for Route.
Route (route_no, source, destination, no_of_stations)
Decode the JSON Route object in PHP program. Display the details of the Route.
[8 Marks]
Q2. Write a PHP script to create XML file named “[Link]”.
<Item>
<ItemName>......................................................</ItemName>
<ItemPrice>.........................................................</ItemPrice>
<Quantity>............................................................</Quantity>
</Item>
Store the details of 5 Items of different Types.
Link “ Item. xml” file to the CSS style sheet and get a well formatted output as given below:
i. ItemName :
color : red;
font-family : copperplate Gothic Light;
font size : 16pt;
font :bold;
ii. ItemPrice and Quantity
color: yellow;
font-family: Arial;
font-size:12 pt;
font:bold; [14 Marks]
Q3. Viva [3 Marks]
-8-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a program using CodeIgniter create a CSS file and apply the styling as <h1>. This
page is green in color and also apply background color to yellow. [8 Marks]
Q2. Write PHP script to keep track of number of times user has visited the page. For the first time
display “Welcome, You have visited for first time” message. For next requests display number
of times user has visited the page. [Use Cookies] [14 Marks]
Q3. Viva [3 Marks]
-9-
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to generate an XML file in the following format in PHP.
<?xml version="1.0" encoding="UTF-8"?>
<BookInfo>
<book>
<bookno>1</bookno>
<bookname>JAVA</bookname>
<authorname> Balguru Swami</authorname>
<price>250</price>
<year>2006</year>
</book>
<book>
<bookno>2</bookno>
<bookname>C</bookname>
<authorname> Deni Ritchie </authorname>
<price>500</price>
<year>1971</year>
</book>
</BookInfo> [8 Marks]
Q2. Write a PHP script to accept a string and then display each word of string in reverse
order by using self-processing form. [14 Marks]
Q3. Viva [3 Marks]
- 10 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to accept a filename from user. Display the last access time of the file.
[8 Marks]
Q2. Design the Movie table in PostgreSQL. Movie (id, mname, release_year, rating)
Write PHP script to display name of the highest rating Movie. [14 Marks]
Q3. Viva [3 Marks]
- 11 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Design HTML to accept a number from the user. Write PHP script to display factorial of a
number by using self-processing page. [8 Marks]
Q2. Design the following tables in PostgreSQL database:
Property (pno, description, area)
Owner (oname, address, phone)
An owner can have one or more properties, but a property belongs to exactly one owner.
Write PHP script to accept owner name from the user display all properties which are
owned by that owner. [14 Marks]
Q3. Viva [3 Marks]
- 12 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create JSON Object and JSON schema for a Department with the following attributes:
Dept (dno, dname, dlocation) [8 Marks]
Q2. Write a PHP script to accept username and password. If in the first three chances,
username and password entered is correct then display second form with “Welcome
message” otherwise display error message. [Use Session] [14 Marks]
Q3. Viva [3 Marks]
- 13 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script which allows user to upload a file to the server from local drive.
Display size and type of the selected file. [8 Marks]
Q2. Write PHP script to display last access time of the page on revising the page. For the first time
display “Welcome, You have visited for first time” message. For next requests display last
access time of the page. [Use Cookies] [14 Marks]
Q3. Viva [3 Marks]
- 14 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a program using CodeIgniter create a CSS file and apply the styling as <h1>. This
page is blue in color and also apply background color to blue. [8 Marks]
Q2. Create the following tables PostgreSQL.
Doctor (doc_no, dname, address, city, area)
Hospital (hosp_no, hname, hcity) Doctor-Hospital related with many-one relationship.
Create a RDB in 3NF for above and solve the following.
Write a PHP script to print the Doctor visiting to the Hospital in tabular format. Accept
hospital name from user. [14 Marks]
Q3. Viva [3 Marks]
- 15 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to create XML file named “[Link]”.
<Product>
<ProductName>......................................................</ProductName>
<ProductPrice>.........................................................</ProductPrice>
<Quantity>............................................................</Quantity>
</Product>
Store the details of five Products of different types.
Link “ Product. xml” file to the CSS style sheet and get well formatted output as given below:
ProductName :
color : red;
font-family : copperplate Gothic Light; font-size : 16pt;
font :bold;. [8 Marks]
Q2. Create following tables in PostgreSQL.
Emp (eno, ename, edesignation, esalary)
Dept (dno, dname, dlocation)
There exists a one-to-many relationship between Dept and Emp.
Design HTML to accept department name from the user. Write a PHP script which will
display count of the employees working in that department. [14 Marks]
Q3. Viva [3 Marks]
- 16 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Create JSON Object for Pizza.
Pizza (Pizzaname String, base String, Toppings Array containing list of items, spicy
Boolean, veg Boolean)
Create Array of Object for storing details of three Pizzas. [8 Marks]
Q2. Write an AJAX program that displays a button labelled “Get Details.” When the button is
clicked, it should retrieve and display teacher information from a PostgreSQL table named
“Teacher,” which contains the fields Tno, Name, Subject, and Research Area.
[14 Marks]
Q3. Viva [3 Marks]
- 17 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a HTML to accept username. Set the username into Cookie for 1 hour. [8 Marks]
Q2. Write a PHP script which allows user to upload a file to the server. Design HTML which
allows user to select file from local drive. [14 Marks]
Q3. Viva [3 Marks]
- 18 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to read the contents of file using fread() function and perform
following operations:
a) Display last modification time of file.
b) Display the size of file. [8 Marks]
Q2. Create Route table (route_no, source, destination, no_of_stations) in database. Write
PHP program to accept route_no from user and display the route details from the
database.
[14 Marks]
Q3. Viva [3 Marks]
- 19 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Design HTML to accept a number from the user. Write PHP script to check whether given
number is perfect or not by using the self-processing page. [8 Marks]
Q2. Design an HTML page that contains a button labeled “Display Details”. When the button
is clicked, it should use AJAX to retrieve students’ table from the database and display the
roll number, name, and age of students. [14 Marks]
Q3. Viva [3 Marks]
- 20 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write PHP script to accept a filename from user. Check whether file exist or not. If it exists
then its size and last modified time. [8 Marks]
Q2. Write PHP script to apply color setting for the page and text. Accept background and text color
from the 1st page. Display selected colors on the 2nd page the and for 3rd page apply selected
background and text color. [Use Cookie]. [14 Marks]
Q3. Viva [3 Marks]
- 21 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script which allows user to upload a file and display the size and last
modified time of the selected file. [8 Marks]
Q2. Create the following tables PostgreSQL:
Doctor (doc_no, dname, address ,city ,area)
Hospital (hosp_no, hname, hcity)
Doctor-Hospital related with many-one relationship.
Create a RDB in 3NF for above and solve the following.
Write a PHP script to print the number of Doctors visiting to the Hospital in tabular
format. Accept Hospital name from user. [14 Marks]
Q3. Viva [3 Marks]
- 22 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
[Link] a PHP script to generate an XML file in the following format in PHP:
<NovelInfo>
<novel>
<novelno>1</novelno>
<novelname> Jane Eyre </novelname>
<authorname> Charlotte Bronte</authorname>
<price>250</price>
<year>2006</year>
</novel>
<novel>
<novelno>2</novelno>
<novelname> Frankenstein </novelname>
<authorname> Mary Shelley </authorname>
<price>500</price>
<year>1971</year>
</novel>
</NovelInfo> [8 Marks]
Q2. Create Route table (route_no, source, destination, no_of_stations) in database. Write PHP
script to accept “source” from user and display the route details from the database.
[14 Marks]
Q3. Viva [3 Marks]
- 23 -
MES, ABASAHEB GARWARE COLLEGE (AUTONOMOUS)
Department of Computer Science
Practical Examination
[Link]. (Computer Science) Sem -VI
CS-354-MJP: Computer Science Laboratory based on Web Technology – II
Duration: 3Hrs. Max Marks: 25
Q1. Write a PHP script to display detailed server information. The program should use a
appropriate PHP functions to retrieve and display information about the web server,
including server name, server software, server protocol, host name, and client details.
[8 Marks]
Q2. Write a PHP script to read two file names from user and copy content of first file into
second file and display the file details on the next page. [14 Marks]
Q3. Viva [3 Marks]
- 24 -