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.
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.
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 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 CZcams", 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.
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.
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!!!
`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.
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!
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.
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!
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.
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.
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?
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.
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.
@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 :)
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!
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.
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.
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! 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!
don't let people make the same mistake i did! please send this link to anyone considering paying thousands of dollars to study Web Development in college
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?
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!
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.
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!
Sorry for the wait. Every once in a while, normally because of CZcamss algorithm, I have to completely redo the way I make videos. I think long tutorial series with numerous short videos provide the best learning experience. Sadly CZcams only wants super long videos. So, I decided to do very long series on Udemy and learn in ones on CZcams temporarily. Up next I'll start a new multipart iPhone development series followed by an updated Android series and see if people like them? I'm very confused by what CZcams has been doing. From talking with CZcams reps they just want numerous clickbait videos per week, which will be of low quality because it is nearly impossible to make 4 or 5 quality videos per week. Now that they don't inform subscribers when I upload videos it is just about impossible to build a following in a tutorial series and if a tutorial series isn't a hit on day one it is dropped out of search results and will never be seen. (See my JavaScript Series as an Example) I hope the new mobile app tutorials are helpful, but if not I guess I'll try something else. Thanks for the support. I'll upload a new video this week.
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.
So, first off seeing you asked for a comment somewhere halfway: i think in 2020 'sex' is being called 'gender' and while there are multiple options there, i think the defaults are at least M/F/X ... i know, hard to wrap our heads around for us older folks, but 'welcome to the future' i guess... ...some other feedback, at the end of the video (while more extensive) i am a bit disappointed most of the examples are exactly like the other videos you did (to an extend it just feels like the previous videos linked together to create a new one). So my feedback would be to try and come up with different examples for different videos, so that maybe some of it clicks more with people because they happen to stumble upon their use case.
Thank you for taking the time to comment and watch the video. I stay away from gender issues and just focus on sex, which is the biological differences between males and females. As per the duplication, yes there is some. I tend to try and pull teaching ideas that I think worked best over the decade, but as you said if someone watches multiple videos they will see similar examples. I apologize for that. That is mainly a product of CZcams forcing me to make videos on a regular basis, or else I'll be delisted. I'll try to do better in the future.
@@derekbanas Maybe i can give some examples... You did the whole student thing. While 'practically the same' something similar can be done with 'members of a sports or hobby club' or 'Employees of a company or organization', 'Donators or subscribers to cause or magazine' ... and while i fully understand most of the tuturial would pretty much be the same and most of the data can even be the same ... hearing the same thing within another context makes it at least less repetitive, but a particular use case may 'click' more with one person then the other, while they might not realize (due to lack of overview) that it's more about the code then the subject matter. There were some other things, like the 'run like mad' thing. Taking cats, or horses or w/e category really, might have made that part more interesting to watch, and make people pay more attention to what is being conveyed. This mainly because i noticed that my brain was going 'ohw yeah i already heard this' and then zones out. And while that is true, said brain clearly didn't remember all of the code and the message behind the dogs barking and running. So, repetition is most certainly good, especially for learning, but it can also be somewhat boring hearing the exact same thing again, to a point where the student might actually 'zone out' due to the subject matter and thus not picking up the actual stuff that is important. While presenting the same stuff within a different context keeps the brain enticed and 'hopefully' go, ohw wait this goes in the same manner as with those dogs (presuming they watched that, or perhaps the other way around if people view the videos in different orders). Which may offer an 'Ah HA' moment and make the subject matter stick more. Anyways, some simple examples of how to change the subject matter within the examples, and i guess a lengthy argumentation for why that matters in my views ...
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. :)
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!
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!!
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.
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.
Great video!!!! Lots of stuff was made with mySQL and PHP. But in 2020 and beyond, is PHP mostly for maintenance of legacy PHP code? Lots of articles on the internet opine that PHP is not the language to be used to any great degree in the future. It has been replaced by a front-end and back-end language like JavaScript and others. Opinions ... ?
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
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.
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 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 CZcams", 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)
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
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!
`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
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...
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
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.
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!!!
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
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.
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.
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?
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"
God bless you! I was searching for this kind of tutorial
Happy to be of help :)
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
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 :)
Watched the entire video, Derek. Thanks for all your hard work! Learned a lot, greatly appreciate it.
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
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
Leaving you a comment just to say a big thank you for this helpful PHP video!
Thanks for this great tutorial, Derek Banas.
I needed this for a refreshing my PHP skills.
Gracias Derek, eres uno de los mejores!
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 CZcams
@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 :)
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!
I watched the whole video.
Same
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
Gosh! Derek Banas, you my man, are such a legend!
Thank you I'm very happy to be of help :)
Not many modern/ up to date PHP tutorials. would like to see some more advanced stuff. Thanks for sharing!
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.
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.
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 :)
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 :)
The best PHP tutorial actually
Thank you for the compliment :) I try to do my best
Your one video gives every concept clear. Been following your videos from 5 years.
Thank you very much for the support
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 :)
"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 :)
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
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.
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....
don't let people make the same mistake i did! please send this link to anyone considering paying thousands of dollars to study Web Development in college
Thank you :) Everyone has paid thousands for a poor education at some point sadly.
तुम बहुत ही बुद्धिमान आदमी हो
Just finished the all video ... men i learn so much tks tks tks :-)
Happy I could help :)
Dude.. its great to see you making tutorials for php!! Because it is an very useful language for web dev :)
Happy I could help :)
Amazing
I watched everything
Thank you :) I'm happy you found it useful
Awesome you're like 9 months younger than me. 🙏😍
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
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!
I am big viewer since my 3rd year computer science engineering.
thanks drek.
Thank you for the support :)
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.
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
Thanks Derek, that was a great tutorial, had a lot of fun
What a voice. Thanks dude.
Thank you very much :)
Great video. Watched till the end.
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
Hi Derek, can you make a tutorial covering PHP 7.3 (kinda advanced PHP)
I'll look into that
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
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
Haven't uploaded for a month Derek. Where are ya?
Sorry for the wait. Every once in a while, normally because of CZcamss algorithm, I have to completely redo the way I make videos. I think long tutorial series with numerous short videos provide the best learning experience. Sadly CZcams only wants super long videos. So, I decided to do very long series on Udemy and learn in ones on CZcams temporarily. Up next I'll start a new multipart iPhone development series followed by an updated Android series and see if people like them?
I'm very confused by what CZcams has been doing. From talking with CZcams reps they just want numerous clickbait videos per week, which will be of low quality because it is nearly impossible to make 4 or 5 quality videos per week. Now that they don't inform subscribers when I upload videos it is just about impossible to build a following in a tutorial series and if a tutorial series isn't a hit on day one it is dropped out of search results and will never be seen. (See my JavaScript Series as an Example)
I hope the new mobile app tutorials are helpful, but if not I guess I'll try something else. Thanks for the support. I'll upload a new video this week.
@@derekbanas That's cool 👍👍
I stayed for whole video .
Thank you for tutorial 🙏
Thank you very much 😁
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.
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
I do appreciate your efforts!
I'm grateful to see this all about php in one video
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.
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
very nice, please we need video on ASP.NET CORE . thank you and God bless.
I hope to soon. May God bless you as well.
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 :)
Hi Derek, I learnt a lot from this tutorial. Please talk about more in another video(about interface and more about php). Thank You :)
Such a helpfull great tutorial, thank you!!
Thank you very much :)
Fantastic Derek, thanks for all your excellent content.
Thank you :) More is coming
So, first off seeing you asked for a comment somewhere halfway: i think in 2020 'sex' is being called 'gender' and while there are multiple options there, i think the defaults are at least M/F/X ... i know, hard to wrap our heads around for us older folks, but 'welcome to the future' i guess... ...some other feedback, at the end of the video (while more extensive) i am a bit disappointed most of the examples are exactly like the other videos you did (to an extend it just feels like the previous videos linked together to create a new one). So my feedback would be to try and come up with different examples for different videos, so that maybe some of it clicks more with people because they happen to stumble upon their use case.
Thank you for taking the time to comment and watch the video. I stay away from gender issues and just focus on sex, which is the biological differences between males and females. As per the duplication, yes there is some. I tend to try and pull teaching ideas that I think worked best over the decade, but as you said if someone watches multiple videos they will see similar examples. I apologize for that. That is mainly a product of CZcams forcing me to make videos on a regular basis, or else I'll be delisted. I'll try to do better in the future.
@@derekbanas Maybe i can give some examples... You did the whole student thing. While 'practically the same' something similar can be done with 'members of a sports or hobby club' or 'Employees of a company or organization', 'Donators or subscribers to cause or magazine' ... and while i fully understand most of the tuturial would pretty much be the same and most of the data can even be the same ... hearing the same thing within another context makes it at least less repetitive, but a particular use case may 'click' more with one person then the other, while they might not realize (due to lack of overview) that it's more about the code then the subject matter.
There were some other things, like the 'run like mad' thing. Taking cats, or horses or w/e category really, might have made that part more interesting to watch, and make people pay more attention to what is being conveyed. This mainly because i noticed that my brain was going 'ohw yeah i already heard this' and then zones out. And while that is true, said brain clearly didn't remember all of the code and the message behind the dogs barking and running.
So, repetition is most certainly good, especially for learning, but it can also be somewhat boring hearing the exact same thing again, to a point where the student might actually 'zone out' due to the subject matter and thus not picking up the actual stuff that is important. While presenting the same stuff within a different context keeps the brain enticed and 'hopefully' go, ohw wait this goes in the same manner as with those dogs (presuming they watched that, or perhaps the other way around if people view the videos in different orders). Which may offer an 'Ah HA' moment and make the subject matter stick more.
Anyways, some simple examples of how to change the subject matter within the examples, and i guess a lengthy argumentation for why that matters in my views ...
Great php tutorial....awesome man thanks
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. :)
Thank You so much for this Tuto. It helped me a lot.
congrats on 1 mil subs
you should do a PHP sodium tutorial
Thank you very much :)
This dude is a one man army! Solute!
Thank you :) I try to do my best
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!
DEREK YOU ARE AMAZING
You are very kind. I try to do my best
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!!
great tutorial to review all you syntax and ideas.
Thank you :)
Great tutorial. Thank you, Derek. I followed until the end.
Thank you very much :)
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
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
really great recap of all important aspects of PHP in such short time
Thank you very much :) I did my best
Thank you very much . You did a great job.
Thank you very much
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.
Derek you really are the best. Thank you for all the hard work you have done for us :)
All I ever wanted was to be able to teach and help people. Thank you for watching my videos :)
Always expecting quality content from your videos. And you always deliver.
Thank you for the compliment :)
Finally superman is updating himself.... Thanku
Thank you very much :) I'm happy I could help
Someone please give this man a Nobel prize already.
You are very kind :)
Thank you for this awesome course und especially for the subtitles!!!
Thank you :) I'm very happy that I could help
I was just wondering “What’s Derek Banas up to right now?”
Normally I'm doing one of the following : Making Videos, Running, Spending time with my Family, or making another online store.
@@derekbanas And the learning ??? :-)
Thank for your hard work 👏👏
Thank you for the nice compliment :) It makes me happy to know I could help.
Great video!!!! Lots of stuff was made with mySQL and PHP. But in 2020 and beyond, is PHP mostly for maintenance of legacy PHP code? Lots of articles on the internet opine that PHP is not the language to be used to any great degree in the future. It has been replaced by a front-end and back-end language like JavaScript and others. Opinions ... ?
PHP is still used for server side development more than any other language. I don't see that changing any time soon.
@@derekbanas GREAT!!!!! Thanks for the reply Derek.