Learn PHP MySQL and PDO and Build a Complete Project
This course includes:
- 9.5 hours of on-demand video
- 2 articles
- 3 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
4.4
(556 ratings)
89,152 students
Created by Web Coding
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 into 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 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 a developer
Course content
27 sections • 80 lectures • 9h 14m total lengthCollapse all sections
Introduction1 lecture • 2min
- IntroductionPreview01:32
Installation for The Course3 lectures • 13min
- NOTE00:05
- Installing Xampp09:46
- Installing Sublime03:09
———————-PHP Basics————————1 lecture • 7min
- Into to The CoursePreview07:20
PHP Basics: Basic Syntax and First Steps7 lectures • 46min
- Basic SyntaxPreview12:07
- Echo03:56
- Print and Differences between Echo and Print08:24
- Variables06:35
- Constants06:25
- Comments04:50
- Single vs Double Quotes03:52
PHP Basics: Data Types5 lectures • 13min
- Integers04:48
- Floats01:21
- Booleans01:40
- Strings02:43
- Nulls02:18
PHP Basics: Operations4 lectures • 20min
- Arithmetical Operators04:30
- Assignment Operators05:59
- Comparison Operators05:46
- Increment and Decrement Operators04:03
PHP Basics: Statements2 lectures • 15min
- If Elseif Else08:44
- Switch06:26
PHP Basics: Loops2 lectures • 15min
- While09:09
- For06:09
PHP Basics: Arrays3 lectures • 19min
- Arrays and Indexed Arrays05:42
- Associative Arrays05:50
- Multidimensional Arrays07:43
PHP Basics: Functions2 lectures • 13min
- Functions07:09
- Functions with Arguments05:50
PHP Basics: Super Globals5 lectures • 47min
- Intro to Super Globals04:13
- Post11:07
- Get14:25
- Sessions pt. 109:00
- Sessions pt. 208:11
PHP Basics: Date and Time2 lectures • 13min
- Date03:51
- Time09:03
———————-MySQL Basics————————1 lecture • 10min
- Intro10:08
MySQL Basics: First Steps7 lectures • 36min
- Creating and Dropping Databases07:05
- Creating Tables08:29
- Dropping Tables02:36
- Inserting into Tables04:51
- Updating and Deleting06:14
- Data Types04:10
- Operators02:16
MySQL Basics: Constraints3 lectures • 23min
- Primary Keys07:07
- Foreign Keys08:23
- Functions07:03
MySQL Basics: Clauses3 lectures • 26min
- Select and Where11:56
- Order by04:28
- Group by09:28
MySQL Basics: Alters1 lecture • 3min
- Alters02:58
MySQL Basics: Joins3 lectures • 27min
- Aliases02:59
- Inner Joins11:33
- Left and Right Joins12:07
———————-PDO Basics————————1 lecture • 5min
- Intro to The Course04:48
PDO: Connecting to The Database2 lectures • 15min
- Connecting to DB with PDOPreview07:27
- Catching ErrorsPreview07:45
PDO: The Many Ways of Fetching Data with PDO5 lectures • 32min
- Getting Data with Query and Fetch pt.106:23
- Getting Data with Query and Foreach03:57
- Getting Data with Query and Fetch pt.207:25
- Getting Data with FetchColumn05:14
- Getting Data with FetchAll09:12
PDO: Prepared Statements and Performing Crud Operations2 lectures • 19min
- Prepared Statements10:06
- Update and Delete09:01
PDO: More Crucial Parts of PHP PDO4 lectures • 26min
- Getting RowCount06:20
- Getting LastInsertId03:15
- Transactions13:20
- Closing the Connection02:50
———————-The First Project————————1 lecture • 1min
- Intro00:05
First Project: Complete PHP PDO Todolist4 lectures • 30min
- Setting Up07:19
- Inserting into DB08:04
- Pulling the Data08:00
- Deleting the Data06:24
New Lectures: Update 20221 lecture • 16min
- Updating the Data16:25
Second Project: Building a Registration and Login System5 lectures • 1hr 4min
- Intro to the Project01:13
- Config File08:58
- Register Page19:22
- Logging Users in20:21
- Logging in and Checking for Sessions13:55
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 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 be 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