Building Stock Market Application in PHP & MySQL

Name: Building Stock Market Application in PHP & MySQL
Rating: 3.6 (12 reviews)

Developing Stock Market Application from Real Time Data from API in PHP & MySQL

Created byVivek Vengala

Last updated 2/2020

English

What you'll learn

You will be able to build web applications in PHP
Learn PHP & MySQL with handson project
You will be able to create Stock Market Application

Course content

10 sections • 33 lectures • 4h 53m total length

Introduction3:25
Fetch API stock data and render candlestick charts for daily, weekly, and monthly views. Manage open, high, low, and close in a watch list in a PHP and MySQL app.
How to Access the Code2:55
How to Access the Source Code (Windows)3:11
Source Code Download0:01

5.1 PHP Form Validations8:46
5.2 CSRF Token Protection10:10
5.3 Inserting the Stock Scrip and Name into Database17:31
5.4 Checking Stock Symbol is unique in Database3:00
Learn how to verify stock symbol uniqueness in the database by querying the stocks table, counting results, and returning an error on duplicates before insertion.
5.5 Reading the Data and inserting it in Database17:18
Read daily stock data from an API, parse JSON, and insert open, high, low, close, volume, and date into the stock_value table with PHP and MySQL for charting.

8.1 Get the New Daily Values18:37
Fetch the latest stock values daily, compare against existing records, and insert only new entries into the stock value values table using stock symbol, date, and exchange formatting.
8.2 Add the Weekly Values10:26
8.3 Add the Monthly Values3:41
8.4 Display the Weekly & Monthly Values in Candle Stick Chart7:41
8.5 Display the Weekly & Monthly Values in Individual Stock Details Page4:26

10.1 Planning & Creating Watchlist DB Tables, Adding a New Watchlist11:40
10.2 View the Watchlists4:30
10.3 Adding Stocks to Watchlist & Viewing Stocks in Watchlist14:00
10.4 Removing the Stocks from Watchlist10:41
Remove stocks from the watchlist in a php and mysql app by building delete queries, updating the watchlist, and ensuring correct removal across lists.
10.5 Updating & Deleting the Watchlist9:47

Requirements

Basic Knowledge of HTML, CSS, PHP & MySQL

Description

In this course you are going to build Stock Market Application, and it is best suitable for developers who want to learn with hands-on project. This project covers from basic to advanced concepts on working PHP project.

This course (Stock Market Application) is structured based on the topics. And it is easily understood by any one who has basic knowledge of PHP & MySQL.

Who this course is for:

Who want to learn PHP with handson project.
Who want to develop a web applications in PHP
Anyone Who wants to learn PHP & MySQL with Handson Project
Anyone Who wants to Learn about working with API in PHP

Building Stock Market Application in PHP & MySQL

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 10min

2 Project Setup & Intro to Stock Market API1 lecture • 10min

3 Database Planning & Creation2 lectures • 14min

4 Diving Deep into the Output Response4 lectures • 32min

5 Adding the Stock (Scrip) Values into Database5 lectures • 57min

6. Displaying the Stocks & Calculating Stocks Information3 lectures • 32min

7. CandleStick Charts2 lectures • 24min

8. Getting New Values Daily, Weekly, Monthly5 lectures • 45min

9 Improving the Speed by Caching the Stock Values2 lectures • 20min

10. Stocks Watchlist5 lectures • 51min

Requirements

Description

Who this course is for: