PHP for Beginners: The Complete PHP MySQL PDO Course

Learn PHP MySQL and PDO and Build a Complete Project


Apply Coupon Code: FULLSTACK99

What you’ll learn

  • You will be able to learn the most common PHP concepts
  • You will be able to write clean well-maintained code
  • You will dive deeper in the web development process
  • You will be able to build and maintain your database
  • You will understand the concepts of the most popular database management system
  • You will be a simple yet great app with all of what you learned
  • You will grasp the basics of on the most important PHP database technologies
  • You will dive into PDO and learn some complex techniques
  • You will build your CV and unlock your potential as developer

This course includes:

  • 9.5 hours on-demand video
  • 2 articles
  • 5 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Course content

27 sections • 81 lectures • 9h 15m total lengthCollapse all sections

Introduction

  • Introduction

Installation for The Course

  • NOTE
  • Installing Xampp
  • Installing Sublime

———————-PHP Basics————————

  • Into to The Course

PHP Basics: Basic Syntax and First Steps

  • Basic Syntax
  • Echo
  • Print and Differences between Echo and Print
  • Variables
  • Constants
  • Comments
  • Single vs Double Quotes

PHP Basics: Data Types

  • Integers
  • Floats
  • Booleans
  • Strings
  • Nulls

PHP Basics: Operations

  • Arithmetical Operators
  • Assignment Operators
  • Comparison Operators
  • Increment and Decrement Operators

PHP Basics: Statements

  • If Elseif Else
  • Switch

PHP Basics: Loops

  • While
  • For

PHP Basics: Arrays

  • Arrays and Indexed Arrays
  • Associative Arrays
  • Multidimensional Arrays

PHP Basics: Functions

  • Functions
  • Functions with Arguments

PHP Basics: Super Globals

  • Intro to Super Globals
  • Post
  • Get
  • Sessions pt. 1
  • Sessions pt. 2

PHP Basics: Date and Time

  • Date
  • Time

———————-MySQL Basics————————

  • Intro

MySQL Basics: First Steps

  • Creating and Dropping Databases
  • Creating Tables
  • Dropping Tables
  • Inserting into Tables
  • Updating and Deleting
  • Data Types
  • Operators

MySQL Basics: Constraints

  • Primary Keys
  • Foreign Keys
  • Functions

MySQL Basics: Clauses

  • Select and Where
  • Order by
  • Group by

MySQL Basics: Alters

  • Alters

MySQL Basics: Joins

  • Aliases
  • Inner Joins
  • Left and Right Joins

———————-PDO Basics————————

  • Intro to The Course

PDO: Connecting to The Database

  • Connecting to DB with PDO
  • Catching Errors

PDO: The Many Ways of Fetching Data with PDO

  • Getting Data with Query and Fetch pt.1
  • Getting Data with Query and Foreach
  • Getting Data with Query and Fetch pt.2
  • Getting Data with FetchColumn
  • Getting Data with FetchAll

PDO: Prepared Statements and Performing Crud Operations

  • Prepared Statements
  • Update and Delete

PDO: More Crucial Parts of PHP PDO

  • Getting RowCount
  • Getting LastInsertId
  • Transactions
  • Closing the Connection

———————-The First Project————————

  • Intro

First Project: Complete PHP PDO Todolist

  • Setting Up
  • Inserting into DB
  • Pulling the Data
  • Deleting the Data

New Lectures: Update 2022

  • Updating the Data

Second Project: Building a Registration and Login System

  • Intro to the Project
  • Config File
  • Register Page
  • Logging Users in
  • Logging in and Checking for Sessions
  • Sources Code for the Project

Requirements

  • Just PC
  • Active internet connection

Description

Welcome to my full stack PHP, MySQL, and PDO course where you will learn everything you need to know about one of the most three hot technologies right now. This course is organized systematically from the programming language (PHP) to The most well-known database (MySQL) to the best PHP tool to connect to this database which is (PDO) to give the most interesting, fun, informative, and worthy opportunity for learning web development the right way. Throughout the course, you will be introduced to major parts of these tools that should get you your dream web development job by building your CV.

The course also is going to updated constantly in order to bring some more practical knowledge and projects. So what are waiting for? This is the best way to sharpen your skills and be a great developer. The course is also planned and sectioned out really well so if you have some experience with some technology you can move easily to your targeted tool. you can see in the curriculum that I flagged the tools with these tech names. if you are interested in this course, don’t hesitate and just get going with it   

I hope to see you inside 🙂

Who this course is for:

  • Anyone who is interested in learning PHP
  • Anyone who is interested in learning MySQL
  • Anyone who is interested in learning PDO

Show less


🎫 After adding the course into Cart at Checkout page, Apply Coupon Code➛.              FULLSTACK99            Note:- After applying coupon, if it says ”This coupon has exceeded its maximum possible redemptions…”, then it means you’re Late, and first 500 coupons already redeemed.


Latest Free Coupons

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Today's 30+ Free Courses

X