Creating a Sales Chart for Sold Apparels

Getting Started. In this tutorial, we will be using XAMPP as our local web server to run our PHP scripts and MySQL database server.

Search https://cdnjs.com/libraries/Chart.js/  for use in css links and scripts.

Open your XAMMPโ€™s Control Panel and start the Apache and MySQL.

Create a folder in C://xampp/htdocs/salesreport

Creating Our Database and Table

Open your phpMyAdmin i.e . # and create a new database named salesdb .

Create a table named saleschart with 10 columns to indicate the types of apparel namely:  formal_dress, ladies_high_waist_pants, ladies_polo_shirt, knitted_blouse, formal_blouse, ladies_slacks, candy_pants, leggings, rash_guard, jogging_pants.  Insert the data on number of sold apparels.

Create Our Database Connection

Open a text editor software like Sublime Text 3, Notepad ++ or a preferred one. Create a new PHP file named db.php   using these codes and saved in C://xampp/htdocs/salesreport

Create index.php

Create and save another PHP file named index.php and write the following scripts: