CS310 Assignment 3 Solution and Discussion


  • 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.

    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!


  • Cyberian's Gold

    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>
    

  • Cyberian's Gold



Quiz 100% Result Quiz 100% Result
| |