• Cyberian's Gold

    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.


    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!

  • Cyberian's Gold

    Solution Idea!
    php file

    $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);
    <!DOCTYPE html>
    <title>CS310 Assignment</title>
  • Cyberian's Gold

Insaf Sehat Card Live Cricket Streaming
Quiz 100% Result Quiz 100% Result
| |