PHP & MySQL Tutorial In 2020 | Learn PHP From Scratch | Full Tutorial

This video will show you how you the concept procedural PHP and MySQL.

📚 New Udemy Course
If you're looking to level up your Laravel skills, my new course "Udemy Migirations, Seeders, Factories, Query Builder, Eloquent & Relationships" is the perfect opportunity. Learn the essential tools and techniques for building robust and scalable web applications with Laravel: udemy.com/course/mastering-laravel-10-query-bui…

📲 Let’s plan a meeting
Plan a (paid) 1-hour meeting on Calendly to do portfolio reviews, code reviews resume reviews or a coaching session for Laravel. Please read the description before booking: calendly.com/codewithdary

💌 Newsletter
Sign up for my free weekly email newsletter: newsletter.codewithdary.com

🔥 Resources
- PHP Hosting (10% DISCOUNT): hostinger.com/codewithdary
- TikTok: tiktok.com/@codewithdary
- Instagram: instagram.com/codewithdary/
- Twitter: twitter.com/codewithdary
- Blog: blog.codewithdary.com/
- Newsletter: newsletter.codewithdary.com/
- Patreon: patreon.com/user?u=30307830
- GitHub: github.com/codewithdary/php-for-beginners

🔗 Want to learn more?
- Courses: youtube.com/channel/UCkzGZ6ECGCBh0WK9bVUprtw/pl…

📋 Table of Content
0:00 introduction
04:26 Installing XAMPP
10:29 Installing a free code editor
16:49 PHP code in HTML
19:23 PHPINFO
22:49 The echo statement
26:28 The print statement
28:04 Comments in PHP
31:46 Line break
36:19 Variables & data types
42:37 Variables in echo/print
47:46 Data Types
52:01 Arrays
59:48 Associative Arrays
01:04:32 Multidmensional arrays
01:10:42 Exercises data type
01:28:12 Arithmetic operators
01:32:10 Assignment operators
01:36:17 Comparison operators
01:42:52 Increment & decrement operators
01:46:10 Logical operators
01:51:51 Conditional statements
01:58:57 Switch statement
02:02:55 While loop
02:05:41 Do while loop
02:09:27 For loop
02:16:50 Foreach loop
02:21:14 Introduction to functions
02:24:46 Creating our first function
02:28:43 Functions with arguments/parameters
02:33:27 Functions with return value
02:40:20 Global and local scope
02:42:39 Constants
02:48:01 How to include documents
02:57:15 How to require documents
02:59:57 Exercises functions
03:14:40 Introduction to built-in functions
03:17:22 Math built-in functions
03:20:17 String built-in functions
03:27:13 Array built-in functions
03:35:10 Date and time functions
03:45:57 Random number generator
03:48:29 Exercises built-in functions
04:00:14 Superglobals
04:05:15 Superglobal Post
04:09:36 Superglobal Get
04:13:02 Superglobal Session
04:17:35 Superglobal cookies
04:24:12 Superglobal Files
04:30:50 How to create a upload system
04:47:56 Create & write files
04:56:51 Read from a file
05:01:23 Script for a contact form
05:16:05 Introduction to databases
05:21:48 Creating a MySQL databas
05:25:35 Creating a MySQL table
05:35:07 Inserting data using MySQL
05:42:45 Selecting data using MySQL
05:48:14 Updating data using MySQL X
05:51:28 Deleting data using MySQL
05:53:55 Ordering data using MySQL
05:57:52 Creating a complete login & register system

#php #course #phpdevelopment #mysql