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

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

📚 New Udemy Course

📲 Let’s plan a meeting

💌 Newsletter

🔥 Resources

🔗 Want to learn more?

📋 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

[Epikht]

2 years later, that is still the best Php course on the internet. Thank you Dary

[jake]

Dude you are gem to this world. I didnt have much money to go for paid backend courses nor had the desire to watch 20 or 30+ hours long tutorial. I needed something quick to familiarize myself with the basics before relying on documentations. I needed a tutorial where php and mysql goes hand in hand. Now i am gonna build my first backend project, which is to integrate a login system to a todo app for personalized todo list.😊

[sreshthamehrotra]

I just wanted to learn how to use MySQL with PHP so I got bored in the starting of the video, but after 7 hours I realized it was totally worth it. All the topics were explained really well and with proper examples. Thanks.

[Zen-lzhc]

This is GOLD standard tutorial .
Thank You !

[iam_topg]

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.

[guentherschuch]

Thank you for this awesome tutorial. This is one of the best tutorials I've ever watched. Keep it up!

[amingol]

your training and teaching is Great, one of the best tutorials about PHP and MYSQL, you say directly what we need to learn not any extra and unnecessary explanation

[thelostrider]

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!

[peterosullivan]

Thank you. I have not used php/mysql since 2011. This course was a great refresher. Also thanks for the password hash tip and prepared statement instruction. New info for me!

[khaledalhariri]

You are amazing! Thanks so much for this course. Subscribed and I'm surprised you only have 3k subs!

[emmanuelcode]

I loved the way you carefully explained everything. A very solid tutorial. Bless up man🙏✌️

[Ginfio]

BEST PHP TUTORIAL SO FAR.
Thank you so much. I watched the whole thing.

[rosssessoms]

Best PHP course I have come across. Straightforward and clear. Great job!!

[mj-lcdb]

After 3 years i was able to connect to a DB!!! TY man

[Taronites]

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!

[ArisAris-fsip]

Thank you for the tutorial!! I decided to switch from node js and express js to php, which is not only more popular (php) but 100 times more simple as you showed us!

[alstudiowebdev]

I don't think I have enjoyed a 7+ hour course as much as I did with this one. Thank you so much for taking the time to create and post this video on YouTube. Something you did that REALLY stuck out was, when starting the Login portion of the Register/Login form, you said "I could copy & paste from the Register page, but I would rather walk you through it again". You also mentioned several times during this tutorial that "It may seem difficult, but it really isn't". You can easily tell that you are saying this as a means of comforting the viewer, because let's be honest... a lot of this IS quite intimidating at first glance, but your approach to it all is.. comforting! You truly care about the quality of education for your students and understand the importance of repetition. Thank you again, Dary.

[Mayafurie]

Agree to others, this is the best tutorial I ever saw. It's absolutely worth it to get up a little bit earlier, just to watch one or two episodes of your tutorial :-). Wish you the best for this channel!

[polsiles]

Very good tutorial, highly detailed and incredibly well explained. Would definitely recommend to anyone who is starting with PHP! Thank you for it!!

[kabilanmahathevan]

Finally finished the 7 hours in 2 days. Greatest PHP tutorial than any paid courses.