Table of Contents 0:00:45 Intro 0:01:35 Variables 0:01:55 Data Types 0:03:56 Inline PHP 0:04:16 Echo 0:04:52 Forms 0:07:00 Checking for Values 0:07:32 Get Array 0:08:52 How Many Values Passed 0:09:14 Math Operators 0:12:07 Math Functions 0:13:33 Random Values 0:15:13 If / Elseif / Else 0:18:22 Switch 0:20:35 Range 0:21:32 Ternary Operator 0:22:26 Identical Operator 0:23:20 Printf 0:24:20 String Functions 0:29:13 Array Functions 0:30:04 Foreach 0:32:55 Multidimensional Array 0:36:50 While 0:37:40 For 0:38:02 Continue 0:38:34 Break 0:39:10 Do While 0:39:58 Functions 0:42:36 Variable Number of Parameters 0:43:37 Return Multiple Values 0:44:44 Map 0:45:30 Print_R 0:45:45 Reduce 0:47:08 Filter 0:48:20 Dates 0:50:38 Include Other Files 0:51:24 Exception Handling 0:53:18 Filter_Input 0:59:21 HTMLSpecialChars 0:59:59 Strip_Tags 1:00:44 Setup PHPMyAdmin 1:01:10 Create Database 1:01:24 Create Table 1:04:01 Insert Data 1:04:50 Display Data 1:07:35 Alter Table 1:09:08 Rename Table 1:09:36 Create DB User 1:11:00 Connect to Database 1:12:19 PDOStatement Objects 1:15:00 Pull Data From DB 1:24:41 Validate Data with Regex 1:32:24 Insert Data into DB 1:42:10 Update Data in DB 1:47:47 Delete Data in DB 1:49:48 Cookies 1:52:50 Object Oriented PHP 1:53:15 Class 1:55:49 Static 1:56:30 Object Functions 1:57:10 Constructor 1:58:10 Destructor 1:58:35 Getters / Setters 2:01:42 Final 2:02:06 ToString 2:03:25 Static Methods 2:06:53 Inheritance 2:07:20 Overriding Methods 2:10:16 Interfaces 2:13:18 Polymorphism 2:15:11 InstanceOf
I'm waiting for your TCL tutorial. It's a great language for niche purposes like Networking protocols, Sandboxing, Emulation, Shell scripting, etc. I hope you make it soon.
this is simply amazing. I have been waiting for this for ages and now I can enjoy the whole PHP language and a whole a lot more in one video. I have a lot to do so let's get into it. Thanks Derek for the awesome tutorial
I started watching your videos 6 years ago from working in a call centre. I'm now in my 3rd web developer job and I've been promoted to senior backend developer. You sir have truly changed my working life. Thank you! Keep up the great videos!
That is amazing! Congratulations on all that you accomplished and your hard work! I wish you all the best and I''m honored to know that I played a small part in your success.
I swear to God you are somehow connected to my phone's microphone. Years ago I was having problems getting into C# and your video on that subject popped up a day later. This very morning I was like "I should check PHP, let me see what's on TH-cam", and there you go, again. Keep listening to my mic I guess. You are a gift man. Respect and thank you for everything you do for us lucky to find you.
`isset($_GET)` will always be true, it's always defined and always an array. Using `isset() && !empty()` is redundant, just use `!empty()` because it also checks for `isset()`. In fact, I would suggest avoiding `isset()` for NULL checks on existing variables as it makes it seem like the variable might not be defined when it clearly is.
This video is a treasure trove of PHP knowledge. Thank you to Derek Banas. Re: INSERT INTO student VALUES query @ 1:04:33, I ran into some technical difficulties at that point. When I ran the query, PHPMyAdmin said the primary key cannot have a value of NULL. The culprit was that the student_id column did not have AUTO_INCREMENT enabled in the table structure. If you look closely @ 1:03:31, you will see that Derek Banas has checked the box to the right of the pull down menu where he sets student_id as the primary key. That box falls under the A_I column. Every one following along, remember to check that A_I box for student_id. If you already created the table without checking the A_I box, then follow this process: 1. Highlight the "students" database in the left pane 2. In the main window, look for the "student" table under the table list 3. Click the "Structure" link in the row for that table. You should see a list of all 13 columns in the student table. "student_id" at the bottom is the one to modify. 4. Click the "Change" link in the student_id row, check the box under A_I, then click the "Save" button. This should resolve the "primary key can't be NULL" error.
No matter how much I know, how many tutorials I've seen, There's is always something, some topics in your videos which I haven't heard of or knew earlier. Thanks for all the tutorials and sharing the knowledge with us, you are awesome!!!
This has been an exciting journey throughout your tutorial. I really enjoyed it. Without any doubt, I can say that this is one of the best tutorial on youtube about PHP. Thanks for sharing your knowledge with all of us.
Still here, not talking to yourself. Thanks for all the great work that you do. It is very much appreciated. Your devotion to education is exceptional. Thanks!
TheNetNinja and Derek are probably the best dev educators on the internet. I have seen many but many just don't have the art of teaching despite knowing their subjects really well and many are imposters using other's content. Really great to see you guys working so hard with your unique useful content free of cost. brilliant
Excellent, I am an old school web programmer, C#, VB, ASP.NET, HTML, CSS Jquery, NEVER PHP. Had a job interview with PHP that I talked my way into, watched this video all weekend, GOT THE JOB!
This person can teach anything in a proper manner that too in a very efficient manner. Unbelievably concise and accurate videos, as a developer I would like to thank you for this PHP tutorial as this helped me understand my client's project source code despite not being a PHP dev.
Derek! Derek! - It's me again (Andres). Even though I been programming since the 80s I still enjoy watching videos especially yours because I always catch something that I have forgotten, or something new. I got into your videos since the 90s and all your videos rivals the pay stuff, especially the free courses 2 or 3 hours courses that explains that they will show you how to create a full site and when you reach the end of the free course you have to pay for the rest of the stuff. I get it that you have to make a living, but you should tell all customers the truth from the beginning. Anyway, have a great day and keep up the GOOD WORK!
Thank you for the wonderful compliment :) I agree it is a shame that many people feel they must scam people. Doing things like that would lay to heavy on my conscious, which is why I don't do that. That is probably why I'm not rich, but that's ok.
Hey, it's me again - Andres and I want to say that I enjoy your courses since early 2000. Even though it's not everything about PHP and you missed the filesystem stuff, you did a great job. I will definitely go through it again, maybe several times. Also more details for the OOP part. I would pay for a full membership creation course. Anyway, you did a great job.
I agree the OOP section could be more robust and separate from the SQL so it's clear which is which. Pretty good video regardless though. Much better than others I have seen.
I would love to see a video on how OOP PHP works with a database ... basically the next step in this tuturial series by logic of the build up... tnx a lot for making these, they help a lot, and i really like your short and to the point way of presenting everything.
I set a schedule every day and stick to it. If I get distracted I normally do something physical which gets me back on track. My day is normally wake up early and eat a lot of fruit while watching educational videos or reading a book. Start working and if I'm distracted lift dumbbells for 5 minutes. Work some more. Get distracted -> run for 30 minutes. Get back to work. Eat a lunch with a ton of vegetables while watching educational videos or reading. I do this all day and into the night until I take a break for kids and wife.
@@derekbanas Would you like to do video tutorial about improving or healing yourself of lack of concentration? How to clear mind, be focused and remember/understand something while reading?
Derek! Derek! It's me again, Andres - I always followed you and your site "NewThinkTank". I need you to create another set of videos this time using the new PHP7 stuff like "Vector, Deque, Map, Set, Stack, Queue, PriorityQueue". We need it bad! I am always prompting your stuff. You Are The MAN!
So precise and slow that I watched it at 2X and understood most of the course without any problem. I'll do it again to memorize the information better. Thank you very much, this course is gold.
1:33:30 We are here Derek! Thanks for the great tutorial, I feel like you are really getting in the important parts of PHP very fast, and showing some applicable stuff here!
The more tutorials you uploaded => the more people understand programming => the bigger the competition will be in the job market! LOL! But thank you very much! Your generosity is overwhelming!
I am very appreciative of your professionalism in your presentation! This is by far one of the most thorough videos on PHP code I have ever watched! Thank you for your work!
@Derek Banas I made it to the part about data validation and database query in add_student.php @ 1:33:21 Can confirm that you were not talking only to yourself. I had some difficulty in previous sections from 'Create DB User' through 'Pull Data From DB'. tut3.php eventually loaded as expected after I resolved 3 SQLSTATE errors, and 1 HTTP error (all caused by my mistakes). Pause and rewind are my friends, as is stack overflow. The code you published on the linked website, and diff have also been indispensible in tracking down my mistakes (BTW, in add_student.php, line 17 there's a typo in the comment). @ 1:40:39 I incorrectly assumed that you were loading add_student.php on your browser. I wracked my brain to explain why my page still said "Database Error" until I noticed that my submit button said "Update Student" while your's said "Add Student" because I was supposed to be loading tut3.php. Live, and learn. I struggle along, surmising that the fraction of the content I retain and the learning experience will be worth the time I put in. I am grateful for your hard work and knowledge.
Thank you for taking the time to write a detailed message. I'm sorry if I caused any struggle while working through the video. I'll try to improve as always, but I'm happy you found it useful :)
I haven't checked out all the comments, but I know some jerk is going to 'yell' at Derek for saying only MFmf for sex is allowed. But I just want to say......... Thank You! to Derek for this well put together tutorial.
Thank you for the compliment :) I might be completely wrong about this, but I thought sex was purely biological, while gender is considered fluid because it is based on gender roles. I definitely don't mean to insult anyone. I know next to nothing about current culture. I don't even recognize any musical bands, most popular actors, etc. I spend most of my time with family activities, work, studying and exercising.
Nice content! I just got done with my college's final exam, been planning on jogging every day, and doing some other fun stuff, starting by watching this video! Oh, and congratz on crossing the 1 million subscribers mark! I just realized that.
I wanted to learn php so I looked up a video with this one guy who took 30 minutes before he started writing code and then took 10 minutes to talk about what a variable is. That's when I thought "I need me a Derek video!". Glad there's a recent version and with SQL! Best way to learn a new language. Just one question, when you write the tags in your html, does that code inside live on the client or the server?
Hey Derek! I know that this isn't related to the video, but could you make more videos about doing crochet? That would be much appreciated. Thanks in advance. :)
@@derekbanas thanks! Please do. I'm a CS student yet I wanted to dive into the world of artistry again. Been doing drawing and 3D modeling lately and I thought that exploring other mediums would be nice. :) I bet more people would start to appreciate them if you'll post more about them. :)
Made 1:33! These are amazing! If you could do one showing how to connect mysql to a C# script in unity it would be amazing! Using AWS instead of local host.
Mr Derek thank you for your quality videos! I would like you to upload a video on OOP Design Patterns for scalability, maintainability etc. Keep up the excellent work! Thanks in advance!
Hi Derek. I love your videos and I'm finishing a bootcamp on Ruby on Rails and bootstrap. Could you get back to it? There are a lot of new stuff and it is always good to get new insights from you. Thank you.
Hi Derek, thank you very much for the good tutorials, they help a lot. Can you please explain what is the best way to make an multi language site with php? How to store the translations etc. I hope you see my comment and show us an example! Best regards.
Happy you liked it :) After this learn SQL : th-cam.com/video/XqIk2PwP0To/w-d-xo.html and JavaScript : th-cam.com/video/IyDVvGmzTlo/w-d-xo.html and you'll be able to do anything
Hello again... so, there is an error in both your tut3.php and your add_student.php file. The error doesn't show up in the tutorial because of the fact that you renamed your table to student"s". In tut3.php it's line 7, where you've written: $query_students = 'SELECT * FROM students ORDER BY student_id'; but it should actually be student without the S. Similarly in add_student.php in line 62 and in line 94. Other than that, truly fantastic and thank you so much for taking the time!!
Hey derek. Ive been subbed for a while, and watched your videos for longer. I dont know how much money you make off these or if you have a job outside of youtube, but I really appreciate the hard work you do and the pursuit of sharing knowledge.
Thank you for the nice message :) Yes I have a real job. Education channels don't make much money, but none of us make these videos because we want to be rich. Making an impact on society worldwide is the goal!
Thank you very much :) It might seem weird, but my goal was never to get a lot of subscribers. What makes me the happiest is just the nice comments I receive about ways I've helped people. I'm grateful to have received 1M subscribers, but knowing that I've helped makes me happy every day.
Thanks for your contribution. However, as a beginner, I believe it would be a bit difficult and fast to learn everything without some reinforcement exercise. It would be better if you could add some tasks or exercise to practice.
Wouldn’t it be dreamy if next video was about Laravel framework to understand the CRUD functionality? that was more fun than going to the dentist! It’s probably nothing but a fantasy....
Didn't expect to see one of these, well done. I'd be interested in seeing a new Android Studios tutorial with Kotlin. I just watched your Kotlin tutorial but it's a little rough when trying to do your Android video with Java. I feel like I'm forgetting Kotlin while doing the Android tutorial, lol.
thank you so much for this one video tutorial. this is for those who khow other programming languages like C/C++, java ,C#. but for beginners it's impossible to understand.
Table of Contents
0:00:45 Intro
0:01:35 Variables
0:01:55 Data Types
0:03:56 Inline PHP
0:04:16 Echo
0:04:52 Forms
0:07:00 Checking for Values
0:07:32 Get Array
0:08:52 How Many Values Passed
0:09:14 Math Operators
0:12:07 Math Functions
0:13:33 Random Values
0:15:13 If / Elseif / Else
0:18:22 Switch
0:20:35 Range
0:21:32 Ternary Operator
0:22:26 Identical Operator
0:23:20 Printf
0:24:20 String Functions
0:29:13 Array Functions
0:30:04 Foreach
0:32:55 Multidimensional Array
0:36:50 While
0:37:40 For
0:38:02 Continue
0:38:34 Break
0:39:10 Do While
0:39:58 Functions
0:42:36 Variable Number of Parameters
0:43:37 Return Multiple Values
0:44:44 Map
0:45:30 Print_R
0:45:45 Reduce
0:47:08 Filter
0:48:20 Dates
0:50:38 Include Other Files
0:51:24 Exception Handling
0:53:18 Filter_Input
0:59:21 HTMLSpecialChars
0:59:59 Strip_Tags
1:00:44 Setup PHPMyAdmin
1:01:10 Create Database
1:01:24 Create Table
1:04:01 Insert Data
1:04:50 Display Data
1:07:35 Alter Table
1:09:08 Rename Table
1:09:36 Create DB User
1:11:00 Connect to Database
1:12:19 PDOStatement Objects
1:15:00 Pull Data From DB
1:24:41 Validate Data with Regex
1:32:24 Insert Data into DB
1:42:10 Update Data in DB
1:47:47 Delete Data in DB
1:49:48 Cookies
1:52:50 Object Oriented PHP
1:53:15 Class
1:55:49 Static
1:56:30 Object Functions
1:57:10 Constructor
1:58:10 Destructor
1:58:35 Getters / Setters
2:01:42 Final
2:02:06 ToString
2:03:25 Static Methods
2:06:53 Inheritance
2:07:20 Overriding Methods
2:10:16 Interfaces
2:13:18 Polymorphism
2:15:11 InstanceOf
thanks bro
Happy to help :)
That's funny :) I figured what is 2 weeks
I'm waiting for your TCL tutorial. It's a great language for niche purposes like Networking protocols, Sandboxing, Emulation, Shell scripting, etc.
I hope you make it soon.
what a super reference - thanks
this is simply amazing. I have been waiting for this for ages and now I can enjoy the whole PHP language and a whole a lot more in one video. I have a lot to do so let's get into it.
Thanks Derek for the awesome tutorial
That's funny :) It is nice to see a familiar name
I started watching your videos 6 years ago from working in a call centre. I'm now in my 3rd web developer job and I've been promoted to senior backend developer.
You sir have truly changed my working life. Thank you! Keep up the great videos!
That is amazing! Congratulations on all that you accomplished and your hard work! I wish you all the best and I''m honored to know that I played a small part in your success.
I swear to God you are somehow connected to my phone's microphone. Years ago I was having problems getting into C# and your video on that subject popped up a day later. This very morning I was like "I should check PHP, let me see what's on TH-cam", and there you go, again. Keep listening to my mic I guess.
You are a gift man. Respect and thank you for everything you do for us lucky to find you.
😂😂
Thank you for the nice message :) It is very nice to know I've been of help. I promise I'm not listening to anyones phones.
youtube's algo 'listening' to you :) it knows Derek's vids have great reputation, so its that combo (with your search)
`isset($_GET)` will always be true, it's always defined and always an array.
Using `isset() && !empty()` is redundant, just use `!empty()` because it also checks for `isset()`. In fact, I would suggest avoiding `isset()` for NULL checks on existing variables as it makes it seem like the variable might not be defined when it clearly is.
I don't use either as well. I always validate with filter input and regex
This video is a treasure trove of PHP knowledge. Thank you to Derek Banas.
Re: INSERT INTO student VALUES query @ 1:04:33, I ran into some technical difficulties at that point. When I ran the query, PHPMyAdmin said the primary key cannot have a value of NULL. The culprit was that the student_id column did not have AUTO_INCREMENT enabled in the table structure. If you look closely @ 1:03:31, you will see that Derek Banas has checked the box to the right of the pull down menu where he sets student_id as the primary key. That box falls under the A_I column. Every one following along, remember to check that A_I box for student_id.
If you already created the table without checking the A_I box, then follow this process:
1. Highlight the "students" database in the left pane
2. In the main window, look for the "student" table under the table list
3. Click the "Structure" link in the row for that table. You should see a list of all 13 columns in the student table. "student_id" at the bottom is the one to modify.
4. Click the "Change" link in the student_id row, check the box under A_I, then click the "Save" button.
This should resolve the "primary key can't be NULL" error.
No matter how much I know, how many tutorials I've seen, There's is always something, some topics in your videos which I haven't heard of or knew earlier.
Thanks for all the tutorials and sharing the knowledge with us, you are awesome!!!
Thank you for taking the time to write such a nice message :) I greatly appreciate it!
This has been an exciting journey throughout your tutorial. I really enjoyed it. Without any doubt, I can say that this is one of the best tutorial on youtube about PHP. Thanks for sharing your knowledge with all of us.
Thank you for the nice compliment :) I'm happy you enjoyed it
Still here, not talking to yourself. Thanks for all the great work that you do. It is very much appreciated. Your devotion to education is exceptional. Thanks!
Thank you for taking the time to tell me :) I appreciate it
TheNetNinja and Derek are probably the best dev educators on the internet. I have seen many but many just don't have the art of teaching despite knowing their subjects really well and many are imposters using other's content.
Really great to see you guys working so hard with your unique useful content free of cost. brilliant
Excellent, I am an old school web programmer, C#, VB, ASP.NET, HTML, CSS Jquery, NEVER PHP. Had a job interview with PHP that I talked my way into, watched this video all weekend, GOT THE JOB!
AWESOME! Congratulations on your new job!!!
This person can teach anything in a proper manner that too in a very efficient manner. Unbelievably concise and accurate videos, as a developer I would like to thank you for this PHP tutorial as this helped me understand my client's project source code despite not being a PHP dev.
So it is good to learn this channels?
I was thinking about learning this channel or the net ninja channel
Thank you for the nice compliment :)
Derek! Derek! - It's me again (Andres). Even though I been programming since the 80s I still enjoy watching videos especially yours because I always catch something that I have forgotten, or something new. I got into your videos since the 90s and all your videos rivals the pay stuff, especially the free courses 2 or 3 hours courses that explains that they will show you how to create a full site and when you reach the end of the free course you have to pay for the rest of the stuff. I get it that you have to make a living, but you should tell all customers the truth from the beginning. Anyway, have a great day and keep up the GOOD WORK!
Thank you for the wonderful compliment :) I agree it is a shame that many people feel they must scam people. Doing things like that would lay to heavy on my conscious, which is why I don't do that. That is probably why I'm not rich, but that's ok.
Just finished your entire tutorial. I needed to learn PHP fast for a new project. Your video was just what I needed. Thanks for making it!
I’m happy to hear I helped :) Thank you for taking the time to tell me
Hey, it's me again - Andres and I want to say that I enjoy your courses since early 2000. Even though it's not everything about PHP and you missed the filesystem stuff, you did a great job. I will definitely go through it again, maybe several times. Also more details for the OOP part. I would pay for a full membership creation course. Anyway, you did a great job.
Thank you very much :)
I agree the OOP section could be more robust and separate from the SQL so it's clear which is which. Pretty good video regardless though. Much better than others I have seen.
Not many modern/ up to date PHP tutorials. would like to see some more advanced stuff. Thanks for sharing!
Derek, thank you so much for all your tutorials. I'm gonna succeed my IT exam mainly because of you. I'm so grateful man !!
Thank you :) Happy I could help
I would love to see a video on how OOP PHP works with a database ... basically the next step in this tuturial series by logic of the build up... tnx a lot for making these, they help a lot, and i really like your short and to the point way of presenting everything.
Thank you :) I'll see what I can do
Congratulations on your 1 million followers! Thanks for your videos, buddy!
Thank you very much :) I find it hard to believe I actually did it
I'm preparing for an interview on a php position and I am watching every second of your video. So i'm still here, you're not talking to yourself :)
Thank you for taking the time to tell me and for watching the whole video! I greatly appreciate it!!!
Dudeee, same here...
Derek banas how you even maintain your motivation and how can I improve my focus for hours, thank you for your hard work 😎
I set a schedule every day and stick to it. If I get distracted I normally do something physical which gets me back on track. My day is normally wake up early and eat a lot of fruit while watching educational videos or reading a book. Start working and if I'm distracted lift dumbbells for 5 minutes. Work some more. Get distracted -> run for 30 minutes. Get back to work. Eat a lunch with a ton of vegetables while watching educational videos or reading. I do this all day and into the night until I take a break for kids and wife.
@@derekbanas Would you like to do video tutorial about improving or healing yourself of lack of concentration? How to clear mind, be focused and remember/understand something while reading?
@@AnonymousDeveloper1 he just told you. a video would be redundant
@@akizaizayoi4763 How often and how many planks should I do?
Just installed my new Raspberry Pi with apache and php yesterday and recognized I need a refresher. Now this php tutorial... Thank You Derek!!!
That's great :) Happy I could help
Your one video gives every concept clear. Been following your videos from 5 years.
Thank you very much for the support
Derek! Derek! It's me again, Andres - I always followed you and your site "NewThinkTank". I need you to create another set of videos this time using the new PHP7 stuff like "Vector, Deque, Map, Set, Stack, Queue, PriorityQueue". We need it bad! I am always prompting your stuff. You Are The MAN!
Thank you for all the support. I appreciate it! I'll see what I can do about fitting in your request
@@derekbanas Hey I understand that you are busy, so you don't have to rush.
God bless you! I was searching for this kind of tutorial
Happy to be of help :)
Watched the entire video, Derek. Thanks for all your hard work! Learned a lot, greatly appreciate it.
Thanks for this great tutorial, Derek Banas.
I needed this for a refreshing my PHP skills.
So precise and slow that I watched it at 2X and understood most of the course without any problem. I'll do it again to memorize the information better.
Thank you very much, this course is gold.
Thank you very much :)
After watching your Java tutorial and having to learn PHP next, I was so glad to click on a video that greeted me with "WELL HELLO INTERNET"
I have not watched this video yet but I'm sure this is gonna be by far the best php video I have watched on TH-cam
1:33:30 We are here Derek! Thanks for the great tutorial, I feel like you are really getting in the important parts of PHP very fast, and showing some applicable stuff here!
Leaving you a comment just to say a big thank you for this helpful PHP video!
Gosh! Derek Banas, you my man, are such a legend!
Thank you I'm very happy to be of help :)
I am big viewer since my 3rd year computer science engineering.
thanks drek.
Thank you for the support :)
Derek you are a genius. I’d love to see your process of reading from the documentation and resuming the info. Wow
Thank you :) I'm definitely not smart. I just constantly try to improve.
Very nice of you to demonstrate your fluency of PHP. But I think you should have explained how does PHP works what is _POS , _GET ext....
The best PHP tutorial actually
Thank you for the compliment :) I try to do my best
I was just preparing for my web programming exam at University. Thank you Mr. Derek Banas!
Happy I could help :) Best of luck on your exams
The more tutorials you uploaded => the more people understand programming => the bigger the competition will be in the job market! LOL!
But thank you very much! Your generosity is overwhelming!
It is my pleasure to help others :) I always considered my goal in life was to make the future better for future generations.
I am very appreciative of your professionalism in your presentation! This is by far one of the most thorough videos on PHP code I have ever watched! Thank you for your work!
Thank you for taking the time to tell me you found it useful :)
@Derek Banas
I made it to the part about data validation and database query in add_student.php @ 1:33:21 Can confirm that you were not talking only to yourself.
I had some difficulty in previous sections from 'Create DB User' through 'Pull Data From DB'. tut3.php eventually loaded as expected after I resolved 3 SQLSTATE errors, and 1 HTTP error (all caused by my mistakes). Pause and rewind are my friends, as is stack overflow. The code you published on the linked website, and diff have also been indispensible in tracking down my mistakes (BTW, in add_student.php, line 17 there's a typo in the comment).
@ 1:40:39 I incorrectly assumed that you were loading add_student.php on your browser. I wracked my brain to explain why my page still said "Database Error" until I noticed that my submit button said "Update Student" while your's said "Add Student" because I was supposed to be loading tut3.php. Live, and learn.
I struggle along, surmising that the fraction of the content I retain and the learning experience will be worth the time I put in. I am grateful for your hard work and knowledge.
Thank you for taking the time to write a detailed message. I'm sorry if I caused any struggle while working through the video. I'll try to improve as always, but I'm happy you found it useful :)
Thanks for this amazing tutorial, Derek. There are definitely things I can take away from this and refactor some PHP that I've been working on.
That's great :) I'm happy I could help
Awesome you're like 9 months younger than me. 🙏😍
I haven't checked out all the comments, but I know some jerk is going to 'yell' at Derek for saying only MFmf for sex is allowed. But I just want to say......... Thank You! to Derek for this well put together tutorial.
Thank you for the compliment :) I might be completely wrong about this, but I thought sex was purely biological, while gender is considered fluid because it is based on gender roles. I definitely don't mean to insult anyone. I know next to nothing about current culture. I don't even recognize any musical bands, most popular actors, etc. I spend most of my time with family activities, work, studying and exercising.
Thanks Derek, that was a great tutorial, had a lot of fun
Dude.. its great to see you making tutorials for php!! Because it is an very useful language for web dev :)
Happy I could help :)
I'm grateful to see this all about php in one video
Thankyou very much for this video as i was looking for a video regarding PHP... Thankyou you're a life saver.
I'm happy I could help :)
"If you made it this far into the tutorial please leave a comment and tell me"... Lmaoooo, These tutorials are soo good, of course we're still here!
Thank you for taking the time to tell me :)
Nice content! I just got done with my college's final exam, been planning on jogging every day, and doing some other fun stuff, starting by watching this video!
Oh, and congratz on crossing the 1 million subscribers mark! I just realized that.
Thank you 😁 I'm there with you. I plan on running a lot. The only problem is that it's in the 30s where I live so it's the treadmill for me I guess
This dude is a one man army! Solute!
Thank you :) I try to do my best
तुम बहुत ही बुद्धिमान आदमी हो
Finally superman is updating himself.... Thanku
Thank you very much :) I'm happy I could help
Just finished the all video ... men i learn so much tks tks tks :-)
Happy I could help :)
I wanted to learn php so I looked up a video with this one guy who took 30 minutes before he started writing code and then took 10 minutes to talk about what a variable is. That's when I thought "I need me a Derek video!". Glad there's a recent version and with SQL! Best way to learn a new language. Just one question, when you write the tags in your html, does that code inside live on the client or the server?
Thank you :) I do my best to not waste time. Code in is on the server
@@derekbanas Great thanks!
What a voice. Thanks dude.
Thank you very much :)
1:33:22 Yes Derek, I've made it this far.
Very complex validation. Never seen that before.
Thank you for watching the whole video :) I'm happy it helped
Gracias Derek, eres uno de los mejores!
Really Appreciating you taking 30 hrs for making this video & maybe 30 more for Planning it. Thanks a lot BOSS
Thank you for taking the time to show your appreciation :)
Fantastic tutorial, and yes, I stayed til the end. I would like to see you do one on interface and another of regex. Cheers, great teacher !
Thank you for taking the time to tell me :) I’m happy you found it useful
Please next time talk about "tokens" in PHP and authentications methods and FUNCTIONAL programming in PHP, i mean the state less code like er lang.
Great video. Watched till the end.
congrats on 1 mil subs
you should do a PHP sodium tutorial
Thank you very much :)
I stayed for whole video .
Thank you for tutorial 🙏
Thank you very much 😁
Hey Derek! I know that this isn't related to the video, but could you make more videos about doing crochet? That would be much appreciated. Thanks in advance. :)
Thank you for your interest :) I loved making those videos, but I didn't think anyone liked them. I'll see if I can come up with something
@@derekbanas thanks! Please do.
I'm a CS student yet I wanted to dive into the world of artistry again. Been doing drawing and 3D modeling lately and I thought that exploring other mediums would be nice. :)
I bet more people would start to appreciate them if you'll post more about them. :)
Amazing
I watched everything
Thank you :) I'm happy you found it useful
Hi Derek, I learnt a lot from this tutorial. Please talk about more in another video(about interface and more about php). Thank You :)
Made 1:33! These are amazing! If you could do one showing how to connect mysql to a C# script in unity it would be amazing! Using AWS instead of local host.
really great recap of all important aspects of PHP in such short time
Thank you very much :) I did my best
Mr Derek thank you for your quality videos! I would like you to upload a video on OOP Design Patterns for scalability, maintainability etc. Keep up the excellent work! Thanks in advance!
Thank you for the compliment :) I'll see what I can do about your request
Hi Derek. I love your videos and I'm finishing a bootcamp on Ruby on Rails and bootstrap. Could you get back to it? There are a lot of new stuff and it is always good to get new insights from you. Thank you.
Thank you :) I'll see what I can do about more Rails tutorials
Hi Derek, thank you very much for the good tutorials, they help a lot. Can you please explain what is the best way to make an multi language site with php? How to store the translations etc. I hope you see my comment and show us an example! Best regards.
I watched the whole video.
Same
DEREK YOU ARE AMAZING
You are very kind. I try to do my best
Thanks Derek, listened from start to finish... where do I go from here? I'll check out some more of your php videos
Happy you liked it :) After this learn SQL : th-cam.com/video/XqIk2PwP0To/w-d-xo.html and JavaScript : th-cam.com/video/IyDVvGmzTlo/w-d-xo.html and you'll be able to do anything
Hi Derek, can you make a tutorial covering PHP 7.3 (kinda advanced PHP)
I'll look into that
Great tutorial. Thank you, Derek. I followed until the end.
Thank you very much :)
Hello again... so, there is an error in both your tut3.php and your add_student.php file. The error doesn't show up in the tutorial because of the fact that you renamed your table to student"s". In tut3.php it's line 7, where you've written: $query_students = 'SELECT * FROM students ORDER BY student_id';
but it should actually be student without the S. Similarly in add_student.php
in line 62 and in line 94. Other than that, truly fantastic and thank you so
much for taking the time!!
I like how this series has been going. now we just need that google cloud set up tut an well have it all.
Thank you :) I'll see what I can do about Google Cloud. I use AWS
Hey derek. Ive been subbed for a while, and watched your videos for longer. I dont know how much money you make off these or if you have a job outside of youtube, but I really appreciate the hard work you do and the pursuit of sharing knowledge.
Thank you for the nice message :) Yes I have a real job. Education channels don't make much money, but none of us make these videos because we want to be rich. Making an impact on society worldwide is the goal!
Congratulations on 1M subscribers Derek. You deserve it. Can you make a special 1M subscriber video?
Thank you very much :) It might seem weird, but my goal was never to get a lot of subscribers. What makes me the happiest is just the nice comments I receive about ways I've helped people. I'm grateful to have received 1M subscribers, but knowing that I've helped makes me happy every day.
I'm sorry but I can't find the link in the description you mentioned about the MySQL vid?
Kindly help me out
Origato!
Fantastic Derek, thanks for all your excellent content.
Thank you :) More is coming
I do appreciate your efforts!
Thanks for your contribution. However, as a beginner, I believe it would be a bit difficult and fast to learn everything without some reinforcement exercise. It would be better if you could add some tasks or exercise to practice.
Wouldn’t it be dreamy if
next video was about Laravel framework to understand the CRUD functionality? that was more fun than going to the dentist! It’s probably nothing but a fantasy....
I'll see what I can do. Laravel makes a lot of sense
Great php tutorial....awesome man thanks
Thank you very much :)
Always expecting quality content from your videos. And you always deliver.
Thank you for the compliment :)
I FINALLY FOUND IT :D YOUR THE BEST
MY FRIEND RECOMMENDED ME TO WATCH YOUR VID AND NO DOUBT YOUR A TRUE LEGEND
Thank you for the compliment :) Happy I could help
It's time for an upgrade. This time with the set-up section featuring vs-code and Linux as well as with Mac and windows.
Thank you for saving my coursework.
Happy I could help :)
Didn't expect to see one of these, well done. I'd be interested in seeing a new Android Studios tutorial with Kotlin. I just watched your Kotlin tutorial but it's a little rough when trying to do your Android video with Java. I feel like I'm forgetting Kotlin while doing the Android tutorial, lol.
Thank you :) Up next I'll coveer iPhone development and then Android Development with Kotlin
thank you so much for this one video tutorial.
this is for those who khow other programming languages like C/C++, java ,C#.
but for beginners it's impossible to understand.
Happy I could help :)
Thank You so much for this Tuto. It helped me a lot.
Such a helpfull great tutorial, thank you!!
Thank you very much :)
Someone please give this man a Nobel prize already.
You are very kind :)
Thank you very much for your time and your hard work. You do always make videos with great qualities and useful contents.
Thank you for the nice compliment :) I always try to do my best
You are a genius
Great video, my Guru of programming
You're very kind thank you :)
Switch (true) by 19:54
Are there other programming languages that support this operation?
Nice trick huh :) Many languages have weird tricky ways to pull off similar results
there are multiple langs that you can use switch statements for, JS, Java, and more
Yes it's very common