Dear Students!
Graded Discussion Board (GDB) will be launched on Monday, July 27, 2020 and it will close on Tuesday, July 28, 2020.
GDB Scenario:
Suppose, as a PHP developer, you are assigned a task to develop a Shopping Store Application. The application should fulfill the following requirements.
· Application should be able to track the type of products users are visiting. By looking at each user’s interest, the application should suggest some related products to each user in current and future visits of store.
· Application should have an option to add products into the cart and wish list but only for registered users.
From cookies and PHP session or blend of both, which technique you will prefer to use for the development of required Shopping Store Application? Discuss it with precise and detailed comments.
Instructions:
· Your answer should not exceed 5 – 6 lines of text in justification of your selected technique.
· A concise, coherent and to the point answer is preferred over lengthy comment having irrelevant details.
· Answers, posted on regular lesson’s MDB or sent through email will NOT be considered in any case.
Please note GDB does not have any grace day. We are giving you about a full week to prepare your comments and 48 hours to just post them. GDB comments will not be accepted through email in any case.
Best of Luck!
Re: CS310 Assignment 1 Solution and Discussion
Assignment No. 1
Semester: Spring 2020
CS310 – Open Source Web Application Development
Total Marks: 20
Due Date: 01/06/2020
Instructions:
Please read the following instructions carefully before submitting the assignment. It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file is corrupted.
Assignment is copied (partial or full) from any source (websites, forums, students, etc)
Objective:
The objectives of this assignment are:
• Installation and configuration of web server
• Use of echo
• Use of if-else statements
Note:
• This assignment is a Graded Assignment.
• The assignment submitted through email will not be accepted.
• This assignment is covering all topics of weeks 1 to 3.
Assignment Submission Instructions
You have to submit only .php file on the assignments interface of CS310 from your LMS account. Assignment submitted in any other format will not be accepted and will be scaled with zero marks.
For any query about the assignment, contact at cs310@vu.edu.pk.
Assignment
In D-Mart the sale’s person is facing a problem of give change which is time consuming in rush hours.
You are required to develop a web application using PHP and HTML which will make it easy for sale’ s person to find the currency notes and coins to give back to customer as change.
Solution Guidelines:
A template file in PHP format is attached with this assignment file. Use this template file for the form to input cash received and bill amount. Screenshot is also given below.
Your application will deduct bill amount from cash received and display how many currency notes/coins of what value cashier should give back to customer. See second screenshot given below.
It is not compulsory to show stylish list of currency notes and coins as showing in sample output. But if you want to show in similar way then you can use template file. All necessary requirements of fancy design are already set. You just need to create list items for each note and coin. One list item is already created for you in template file.
Sample screenshot of showing different notes and coins is showing in sample screen shot which depends on how much amount we need to return.
Sample Screenshots:
Screenshot of given template:
[image: TWqmVYW.png]
Screenshot of notes and coins that need to return to customer:
[image: thCJWGE.png]
Best of Luck!
Syllabus of assignment is all topics of week 1 to 3
Assignment No. 03
Semester: Fall 2019
CS310: Open Source Web Application Development Total Marks: 20
Due Date: January 15, 2020
Topics Covered: Topics of Week 6 to 10
General Instructions:
Please read the following instructions carefully before submitting assignment. It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file is corrupt.
Assignment is copied (partial or full) from any source (websites, forums, students, etc.)
Note: You have to upload your assignment solution only in .doc or .docx format only. File submitted other than Microsoft Word format will get zero marks.
Objective:
The objective of this assignment is to provide hands on experience of:
• Installing and configuring MySQL
• Database and table creation
• Inserting data into database (tables)
Tools to use:
XAMP / WAMP / Vertrigo server
For any query about the assignment, contact at cs310@vu.edu.pk
Problem Statement:
Suppose you are working as a web developer in a financial institute. A task is given to you is take the data of sale and save into a table into a database.
Table Structure:
Column Name
Data Type
Id
Numeric
Name
Text
Region
Text
ClientName
Text
Units
Numeric
UnitCost
Decimal
Date
Date
Sample Data:
ID
Name
Region
ClientName
Units
UnitCost
Date
1
Pencil
East
Jones
95
1.99
01/06/2018
2
Binder
Central
Kivell
50
19.99
1/23/2018
3
Pencil
Central
Jardine
36
4.99
02/09/2018
4
Pen
Central
Gill
27
19.99
2/26/2018
5
Pencil
West
Sorvino
56
2.99
3/15/2018
6
Binder
East
Jones
60
4.99
04/01/2018
7
Pencil
Central
Andrews
75
1.99
4/18/2018
8
Pencil
Central
Jardine
90
4.99
05/05/2018
9
Pencil
West
Thompson
32
1.99
5/22/2018
10
Binder
East
Jones
60
8.99
06/08/2018
Solution Instructions:
To solve this assignment, you need to perform following steps with the help of PHP code.
• Connect to MySQL server.
• Create a database, the name of database should be your VU-ID.
• Create table “Sales” into database. Structure of table is given above.
• Insert sample data into “Sales” table. Sample data is given above.
• Take screen shot of data base from MySQL and paste into solution file.
What you have to submit?
You have to copy/paste following into your solution file then upload solution file from your LMS account.
• PHP code which will create database, table and save sample database into table.
• Screen shot of “Sales” table from MySql using phpMyAdmin tool.
Best of Luck!
Assignment No. 02
Semester: Fall 2019
CS310: Open Source Web Application Development Total Marks: 15
Due Date: December 02, 2019
Topics Covered: Topics of Weeks 1 to 5
Instructions:
Please read the following instructions carefully before submitting assignment. It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file is corrupt.
Assignment is copied (partial or full) from any source (websites, forums, students, etc)
Note: You have to upload .php file which will have code of PHP. Assignment in any other format (extension) will not be accepted and will be awarded with zero marks.
Objective:
The objectives of this assignment are:
• Understanding the use of if-else statements
Note:
• This assignment is a Graded Assignment.
• The assignment submitted through email will not be accepted.
• This assignment is covering all topics of weeks 1 to 5.
Guidelines:
Code should be properly indented.
You can use the following tools/software:
o Adobe Dreamweaver, Notepad
o XAMP, WAMP, Vertrigo Server
For any query about the assignment, contact at cs310@vu.edu.pk.
Assignment Statement:
Suppose, you joined NGCP (Natural Gas Company Pakistan) as a developer. The first task is given to you is create a web-based application in PHP to generate the bill of customer.
User of your application will give customer id as customer_id and number of units as units through URL. Your application will read customer id and units from URL and generate the bill according to table given below.
Number of Units Rate per Unit
First 50 units 0.50/unit
Next 100 units 0.75/unit
Next 100 units 1.00/unit
units above 250 1.50/unit
Additional taxes on Cost of Gas is 18%.
Late payment surcharge 5% payable bill.
The code to reach customer_id and units from URL is already given PHP file attached with assignment. You need work on provided file and complete and missing requirements.
Sample Web Page:
[image: R1qXcyf.png]
Submission Instructions:
You have to submit single PHP file which will have all the code provided by us and PHP code you will write.
BEST OF LUCK!
CS310 Quiz 2 Solution and Discussion
Unsolved
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
10
Posts
1
Posters
2.3k
Views
1
Watching
-
_______ statement is used to create database named MyDatabase in MySQL.
CREATE DATABASE databasename;
-
If we want to show all the session variable values for a user session then following code will be used.
print_r($_SESSION);
-
Which of the following PHP syntax is used to remove all HTML tags from a string? CS310
-
How will we retrieve the value of session variable set in the following PHP code?
$_SESSION[“color”] = “green”;
-
_______ statement is used to add a new record to a MySQL table
-
Which of the following PHP syntax is used to remove all illegal characters from a URL?
-
In PHP, in order to access MySQL database you will use:
-
Which of the following PHP function is used to validate and sanitize the data?
-
Use …… to add table in the database
-
What SQL clause is used to restrict the rows returned by a query?
PAK VS BAN Live
File Sharing
