-
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/2020Instructions:
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 statementsNote:
• 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 [email protected].
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:
Screenshot of notes and coins that need to return to customer:
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 10General 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 [email protected]
Problem Statement:
Column Name Data Type Id Numeric Name Text Region Text ClientName Text Units Numeric UnitCost Decimal Date Date
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: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/2018Solution 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 5Instructions:
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 ServerFor any query about the assignment, contact at [email protected].
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:
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!
-
Assignment No. 01
Semester: Fall 2019
CS610: Open Source Web Application Development Total Marks: 10
Due Date: November 14, 2019
Topics Covered: Topics of Weeks 1 to 3Instructions:
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:
• Installing and configuring web server
• Display data of PHP variables on HTML pageNote:
• 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.Guidelines:
Code should be properly indented.
You can use the following tools/software:
o Adobe Dreamweaver , Notepad
o XAMP, WAMP, Vertrigo Server
You will not use any other software to make .php fileFor any query about the assignment, contact at
Assignment Statement:
Suppose you have been hired as a web application developer in a software house. A task is given to you take an already designed HTML page and convert in PHP form. You have to save all the visible data HTML page in PHP variables and show with the help of “echo” command.
Sample Web Page:
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!
-
_______ statement is used to create database named MyDatabase in MySQL.
CREATE DATABASE databasename; -
Assignment No. 03 Semester: Spring 2019
CS310: Open Source Web Application Development
Total Marks: 20
Due Date: July 31, 2019
Topics Covered: Topics of Week 9 to Week 12General 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)
• Retrieve information from table
• Display data from database on HTML/PHP pageTools to use:
XAMP / WAMP / Vertrigo server
For any query about the assignment, contact at [email protected]
Problem Statement:
As a web developer a task is given to you create a simple web application in PHP to show students record on HTML/PHP page. In this task you will create database, table, insert data into table, display table data on HTML/PHP page in the form of HTML table.
Solution Instructions:
• Create database in MySQL.
• Create table “Students” into database. Structure of table is given above.
• Insert sample data into Student table. Sample data is given above.
• Write PHP code to connect with MySQL server.
• Select database and fetch all data from table and show on HTML/PHP page.What you have to submit?
You have to copy/paste following into your solution file then upload solution file from your LMS account.
• Dumb of Students table or database generated through phpmyadmin.
• Code of PHP.
• Screen shot of PHP/HTML page.
Sample Output:Best of Luck!
CS310 Assignment 3 Solution and Discussion
-
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 10General 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 [email protected]
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!
-
-
Solution Idea!
php file
CS301.php<?php $host = "localhost"; $user = "root"; $password = ""; $dbname = "bc12345"; // Create connection $conn = mysqli_connect($host, $user, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "INSERT INTO `sales` (`ID`, `Name`, `Region`, `Client_Name`, `Unit`, `Unit_Cost`, `Date`) VALUES ('5', 'boll point', 'south', 'Jhon', '230', '120.99', '2020-01-12')"; if (mysqli_query($conn, $sql)) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } mysqli_close($conn); ?> <!DOCTYPE html> <html> <head> <title>CS310 Assignment</title> </head> <body> </body> </html> -