CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)

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!