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 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!

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>