Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Pro Blog
  • Users
  • Groups
  • Unsolved
  • Solved
Collapse
Secnto AI
  1. Secnto AI
  2. Categories
  3. Virtual University
  4. CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
  5. CS310 Assignment No. 03
 Solution and Discussion
CS310 GDB 1 Solution and Discussion
zareenZ
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!
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Assignment 1 Solution and Discussion
M
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
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Assignment 3 Solution and Discussion
zareenZ
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!
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Assignment 2 Solution and Discussion
zareenZ
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 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Assignment 1 Solution and Discussion
zareenZ
Topic thumbnail image
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Quiz 2 Solution and Discussion
zaasmiZ
Topic thumbnail image
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
CS310 Assignment No. 03
 Solution and Discussion
zaasmiZ
Topic thumbnail image
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)

CS310 Assignment No. 03
 Solution and Discussion

Scheduled Pinned Locked Moved Unsolved CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)
cs310assignment 03solutionmysql
2 Posts 2 Posters 743 Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • zaasmiZ Offline
    zaasmiZ Offline
    zaasmi
    Cyberian's Gold
    wrote on last edited by
    #1

    bce75d10-6086-479b-83eb-44dbc3c2201f-image.png
    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 12

    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)
    • Retrieve information from table
    • Display data from database on HTML/PHP page

    Tools to use:

    • XAMP / WAMP / Vertrigo server

      For any query about the assignment, contact at cs310@vu.edu.pk

    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.
    2ba6efea-04e7-42c8-a0d6-dc7afa38dd9b-image.png

    daed304a-9e36-419c-b860-1b3165ea752b-image.png
    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!

    Discussion is right way to get Solution of the every assignment, Quiz and GDB.
    We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
    Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
    [NOTE: Don't copy or replicating idea solutions.]
    VU Handouts
    Quiz Copy Solution
    Mid and Final Past Papers
    Live Chat

    1 Reply Last reply
    0
    • M Offline
      M Offline
      moaaz
      Cyberian's Gold
      wrote on last edited by
      #2

      Ideas Solution
      384b637f-d1b2-48b8-ade7-64dcae490f6f-image.png

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      %(red)[NOTE: Don't copy or replicating idea solutions.]

      How to Get Earning from Cyberian

      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      For instructions on how to use this Cyberian discussion board

      1 Reply Last reply
      0

      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      How to Build a $1,000/Month PAK VS BAN Live Live Cricket Streaming
      File Sharing
      Earn with File Sharing

      1

      Online

      3.0k

      Users

      2.8k

      Topics

      8.2k

      Posts
      solution
      1235
      discussion
      1195
      fall 2019
      813
      assignment 1
      428
      assignment 2
      294
      spring 2020
      265
      gdb 1
      238
      assignment 3
      79
      • PM. IMRAN KHAN
        undefined
        4
        1
        4.0k

      • Are the vaccines halal or not?
        undefined
        4
        1
        3.8k

      • All Subjects MidTerm and Final Term Solved Paper Links Attached Please check moaaz past papers
        zaasmiZ
        zaasmi
        3
        26
        75.1k

      • CS614 GDB Solution and Discussion
        M
        moaaz
        3
        3
        8.1k

      • How can I receive Reputation earning from Cyberian? 100% Discount on Fee
        Y
        ygytyh
        3
        28
        23.9k
      | |
      Copyright © 2010-26 RUP Technologies LLC. USA | Contributors | Privacy | Terms
      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Pro Blog
      • Users
      • Groups
      • Unsolved
      • Solved