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



Patreon Support – https://www.patreon.com/user?u=30307830
Instagram – https://www.instagram.com/codewithdary/
Email – info@darynazar.com
▬▬▬

Donations through Crypto
BTC – 1J3iaooom6vM2ywAnKFEU4wtMMippgMT4P
ETH – 0x4d55450aa1310b509efe16ddb4c639b7b7a1ca93
▬▬▬

Source code
https://drive.google.com/drive/folders/1asny74Bh80EbWWWS1ivsTIXjHWHS_S29?usp=sharing
▬▬▬

➤ GEAR
Rode NT1KT – https://amzn.to/2UgLshZ
Blue Compass Boom Arm – https://amzn.to/3jrIeEf
Laptop stand – https://amzn.to/36PmAVk
Laptop I use (Mac) – https://amzn.to/35hRLIt
Apple Magic Keyboard – https://amzn.to/2YQp9ls
Apple Trackpad 2 – https://amzn.to/3pWbA01
Laptop I use (Unbuntu) – https://amzn.to/3eVsJSH
External monitor – https://amzn.to/32yd1YT
Logitech Mouse – https://amzn.to/3pgzxit
External hard drive – https://amzn.to/36t3piX
HEADPHONE – https://amzn.to/3pdq2AN
▬▬▬

➤ COURSES
PHP – https://www.youtube.com/playlist?list=PLFHz2csJcgk_fFEWydZJLiXpc9nB1qfpi
OOP PHP – https://www.youtube.com/playlist?list=PLFHz2csJcgk-7hgKrjUa_IP5YCLE4vJhV
JavaScript – https://www.youtube.com/playlist?list=PLFHz2csJcgk_05eXbkFNlJbA6fksXohDW
HTML/CSS – https://www.youtube.com/playlist?list=PLFHz2csJcgk_JGjaA9GsSftkBZWF743Im
▬▬▬

➤ BREAKDOWN BY CHAPTERS
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
▬▬▬

➤ Disclaimers
I am a participant in the Amazon Services LCC Associates Program, which allows me to advertise items which means that I will earn fees by linking to Amazon.com.

41 thoughts on “PHP & MySQL Tutorial | Learn PHP From Scratch | Full Tutorial

  1. TIMESTAMP

    INTRODUCTION TO PHP
    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

    VARIABLES & DATA TYPES
    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 types

    OPERATORS
    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

    CONTROL STRUCTURES
    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

    FUNCTIONS
    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

    BUILT-IN 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

    SUPERGLOBALS
    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

    DATABASES
    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

    CREATING A SCRIPT
    05:57:52 – Creating a complete login & register system

  2. Hi, I have a question for many years I have been designing websites testing them localhost. Contrary to the common belief that you are supposed to use Xampp or Mamp I have always managed to use just Mysql and IIS. I never have or had any problem so I would like to know why I should make it more complicated than necessary, besides I tried using Xampp and worked for a while only, was very frustrating, also Apache server is not that easy to use I think. Like to know what you think thanks a lot. This is an awsome tutorial.

  3. Dary, you're such a great guy…

    Keep it up.

    You're one of the best and most thorough teachers I've ever come across…

    Please continue with more content…

    I love you.

  4. Hi! First of all I have to say, great course! You're an amazing teacher!
    But I have one question. What params would I put if I'm using "MyRemoteSql" as my myPhpAdmin (because I'm using repl.it as xampp doesn't work for me – so I am not running any servers). So for my host, user params etc, what would be the default values (for myRemoteSql)?
    Thanks in advance!

  5. I just finished this entire course and MAN. I had some typos in my code to iron out at the end, but what a sense of accomplishment completing this course. Now I can fully understand what PHP is all about. Thank you for sharing this video with the world. This is probably the only video I can fully appreciate. Now if only I can get VS Code to debug internally, I will be good to go!
    PS. We never see your footer content from out here. You put your <footer> tags outside of </body> so the page never sees the content to render to the browser! Was this an oversite?

  6. I have a question. Is PHP still relevant these days? Because it's such an old language. There must be a newer alternative that is the industry standard, or am I wrong? What do Google, Amazon, etc. use?

  7. Dear Sir, I have University project and have only 18 days left for submission Plz tell me if it's complete PHP tutorial or not? I have already wasted my precious time on some YT tutuorials that didn't help a lot. Your tutorail seems plain simple and easy

  8. This is probably the most underrated channel about PHP out there… So much good contect with actually good explanation!!! Other (big) youtubers I see don't go in so much depth or don't teach in the right way. He even cared to do prepared statments and regular expression to validate the user (which is awesome); Database; etc… all the stuff! Didn't watch full video since most of the stuff isn't new to me but one small thing I thing it missed is: if the user inserts an valid username (either in register or login) the input username should stay in the unsername field so that the user doesn't have to write it again.

    I will for sure watch the OOP and Lavarel tutorial, keep going with the good content, teaching PHP the right way!

  9. Hey Dary. Thank You for the course. I am in a dilemma regarding PHP. I have 3 weeks to learn one of the PHP Frameworks/Librarys. I dont know much about them so I am choosing between Laravel and Symfony which are famous. I am well known to PHP but still not a professional. I will be using it for CMS, E-commerce and other Web apps. Thank You

  10. Thanks for this tutorial, you are my hero and has helped me in my learning route to become proficient. Please do you have more courses that could help me further in my php journey? Also do you have Udemy courses so I can support your efforts?

  11. This helped A LOT ! I have an university project and it's my last year – I really hope that i will pass. Btw, i have no idea about programming. Thank you for sharing this!

  12. Thus far the best, most pleasant, most reliable and brilliantly useful tutorial on PHP and MySQL, honestly. I've looked around for quite some time and this here is the only one that does right and feels right. Congrats and Thanks!

  13. I call it, PHP will become more and more niche in the foreseeable future…Most programmers cringe to the idea of using PHP but whether you like it or not is still on high demand like wordpress…

Leave a Reply

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