PHP & MySQL Database Course

In this course, we will learn PHP as a programming language for servers and MySQL database for storing data. PHP is used to build APIs to perform CRUD functions with the server. The famous CMS (Content Management System) Wordpress is written in PHP and in this course you will also learn how to set up XAMPP for Wordpress Development. If you want to learn Laravel or Codeigniter, you should know php because those frameworks are also written in PHP.

Course Outline:

PHP 8.1

  • Programming Basics
    • Variables, Functions, Loops, Arrays, 
    • Arithmetic Operations, Conditionals
    • String & Array Operations, 
  • $_GET and $_POST
  • Sessions & Cookies
  • Connection with MySQL
  • Insert, Show, Update & Delete Data
  • Create User Login/Signup
  • Admin Panel/Dashboard
  • Uploading Files using Form
  • Working with JSON / Associative Array
  • Form Validation
  • Pagination For Data
  • Encrypt & Decrypt Data
  • Build Password Generator
  • SEO Optimization
  • Payment Gateway (Stripe Integration)
  • Composer Concept
  • OOP Concept
  • PDO Concept
  • RestFull APIs
  • MySQL Injection Protection
  • Shopping Cart
  • Tracking Order Status
  • Error Handling

MYSQL

  • Relational Database
  • phpMyAdmin
  • Structure Query Language
  • Database & Table Basics
  • Select, Insert, Search, Delete, Update Operations
  • Primary / Foreign Key
  • Tables Relationship
  • Joins (Inner, Self, Left, Right, Cross)