CS310 Assignment 3 Solution and Discussion

zareen

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!

zareen

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>

zareen