PHP Stock Apps Featuring PDO, Flat Files and MySQL (Ep. 1)
Channel: Christian Hur
Date: 04/07/2020

⭕ Overview
In this video series, we'll build a simple PHP application that will read a flat file (text file) with some stocks data, parse the file and insert each record into a MySQL database using the PDO library, and query the database to display the data to the view.

⭕ Chapters
  0:00 - 0️⃣  Introduction
  1:56 - 1️⃣ CSV file overview
  3:38 - 3️⃣ Creating a database
  5:16 - 4️⃣ Creating project files
  7:50 - 5️⃣ Creating the header and footer
10:22 - 6️⃣ Creating the CSS rules
18:52 - 7️⃣ Creating the StockFunction class
20:20 - 8️⃣ Creating the landing page

⭕ About me
I am a Web Instructor, and I’ve authored a textbook and some complete sets of video training courses for https://www.linkedin.com/learning (formerly Lynda.com) and https://www.packtpub.com.

⭕ Visit my site: https://christianhur.com
⭕ My complete online training courses:
      ☑️ The DOM in JavaScript, jQuery, AngularJS, and React : https://www.linkedin.com/learning/the-dom-in-javascript-jquery-angularjs-and-react
      ☑️ Building JSF Web Applications with Java EE 7:  https://www.linkedin.com/learning/building-jsf-web-applications-with-java-ee-7
      ☑️ Troubleshooting Vue.js:  https://www.packtpub.com/application-development/troubleshooting-vuejs-video
      ☑️ Angular 7 New Features:  https://www.packtpub.com/web-development/angular-7-new-features-video
      ☑️ Full-Stack Web Development with Flask: https://www.packtpub.com/web-development/full-stack-web-development-flask-video
      ☑️ Full-Stack Web Development with Django & Angular 8: https://www.packtpub.com/web-development/full-stack-web-development-with-django-and-angular-8-video
      ☑️ Angular 9 New Features:  https://www.packtpub.com/web-development/angular-9-new-features-video

⭕ Check out my book:
Developing Business Applications for the Web: With HTML, CSS, JSP, PHP, ASP.NET, and JavaScript is available on Amazon and MC Press. 
      ☑️ Link:  https://www.mc-store.com/collections/christian-hur/products/developing-business-applications-for-the-web-with-html-css-jsp-php-asp-net-and-javascript