Really loving the new mysql functions in PHP 8.2: mysqli_execute_query($dbc, $query, $parameters); This is a new shorthand method for preparing a statement, binding the parameters, executing the statement and getting the results. This has been a godsend and saved tons of lines of code for us in our PHP framework. Handles all the sanitisation etc for us.
And here are the timestamps: 0:00 Intro 0:28 Validation & Sanatation of Data (Ensures safety of Data) 2:57 Deprecated MySQL-Functions in PHP (Ensures safety of Databse) 4:41 Use Prepared Statements (Prevents misuse of Database)
There is a difference between depreciated and deprecated. Functions or features that you should no longer use are marked as deprecated (de-pre-ca-ted) 😉 The marquee tag has been deprecated for 10 years or so by the html spec, but is still available in the major browsers even tho they are not required to support the tag, meaning it could break at some point if the vendor decides to remove it. Just like the old mysql functions in php, they still work but could be removed at any time in a new version of php. (they probably never will tho😂)
depreciated / depreciation = when something you buy drops in value a car depreciates as soon as the first buyer turns on the ignition. Unless the car survives to become vintage. Deprecated = the manufacture or engineer will not manufacture any longer or service anything any more because the item is old and/or shown to be no longer worth their time supporting it or manufacturing it. Something better has come along. If a manufacture says something will be deprecated then it will be deprecated, better stop coding how you used to.
I use prepared statemes in execture(array( ':id' => $id )) like this intead of using each of them like this bindParam() ... etc. What do you think? Is this same as passing to execute function?
Yes that is perfectly fine 🙂 You can both use named and non-named parameters. In my newest PHP course I show both ways. Edit: Oh just noticed you used named parameters in the array. Yes you can do that too. But using bindParam() you have more control over the parameter type and binding options. You can specify the parameter type (example PDO::PARAM_INT for an integer) and choose whether the value is bound by reference or by value.
My older course is lacking many elements, such as proper security. My newer course is so much better at explaining the different subjects in depth, as well as covering security. If you were to watch the new course + the OOP PHP course, then you could say you have a "fundamental understanding of core PHP". If you want to be a more "complete PHP developer", then you should also add a framework to your knowledge. Such as Laravel. Since a framework is more commonly used in a professional production environment.
Informative video as always, great pleasure learning from the best. I like your Audio setup, sound is loud and clear. What are you using for audio and visual? I will appreciate your recommendations, planning to set up a UA-cam channel before the end of the year. Keep up the good work.
@@Dani_Krossing Thank you Dani, I am learning OBS through your able tutorials. Downloaded and installed, looking forward to the next installment of your tutorials. One more thing, which mic device do you recommend?
It depends a lot on what you prefer. I personally just use a USB microphone, which provides great quality and doesn’t require a more expensive investment by getting a soundboard. Mic wise, I prefer the Blue Yeti or the Audio Technica AT2020 (USB version of course), but if you have a soundboard, then the AT2020 also comes as a normal mic. The Yeti has a deeper more “pleasent” sound to it, where as the AT2020 has a clearer sound to it. 🙂 Look wise the AT2020 is dark and has a cool blue light indicator in front, to let you know which side is which. The Yeti comes in a variety of colors, where I prefer the dark grey. But keep in mind that the Yeti is great for just standing on the desk in front of you, where the AT2020 is better in a mic arm. Hope this was useful 🙂
I learned a lot in this channel I'm just new in php but i just want to know to add multiple data in data base in just one process for example adding 5 data in one process😂 is that even possible?😅😅😅 I'm just curious though 🤔😊
A year ago i watched old php lessons of your. Now i am a Symfony developer. Thanks you!!
Watching from Uzbekistan!!
Really loving the new mysql functions in PHP 8.2: mysqli_execute_query($dbc, $query, $parameters); This is a new shorthand method for preparing a statement, binding the parameters, executing the statement and getting the results. This has been a godsend and saved tons of lines of code for us in our PHP framework. Handles all the sanitisation etc for us.
And here are the timestamps:
0:00 Intro
0:28 Validation & Sanatation of Data (Ensures safety of Data)
2:57 Deprecated MySQL-Functions in PHP (Ensures safety of Databse)
4:41 Use Prepared Statements (Prevents misuse of Database)
Thanks I forgot it on this one. 🙂 Will add them later
Let me tell you something, YOU ARE MERELY AMAZING!!!
First comment😊, thank you for teaching us.
Great video! All good information!
You made me learn oop PHP
I really appreciate
Good start on getting CRUD functions processed securely. Thanks Dani :)
So good tutorial thank you
Nice topic
Awesome
The Fifth to comment 😊
There is a difference between depreciated and deprecated.
Functions or features that you should no longer use are marked as deprecated (de-pre-ca-ted) 😉
The marquee tag has been deprecated for 10 years or so by the html spec, but is still available in the major browsers even tho they are not required to support the tag, meaning it could break at some point if the vendor decides to remove it.
Just like the old mysql functions in php, they still work but could be removed at any time in a new version of php. (they probably never will tho😂)
depreciated / depreciation = when something you buy drops in value a car depreciates as soon as the first buyer turns on the ignition. Unless the car survives to become vintage. Deprecated = the manufacture or engineer will not manufacture any longer or service anything any more because the item is old and/or shown to be no longer worth their time supporting it or manufacturing it. Something better has come along. If a manufacture says something will be deprecated then it will be deprecated, better stop coding how you used to.
come back dude 😕 miss your tutorials
I use prepared statemes in execture(array(
':id' => $id
))
like this intead of using each of them like this bindParam() ... etc. What do you think? Is this same as passing to execute function?
Yes that is perfectly fine 🙂 You can both use named and non-named parameters. In my newest PHP course I show both ways.
Edit:
Oh just noticed you used named parameters in the array. Yes you can do that too. But using bindParam() you have more control over the parameter type and binding options. You can specify the parameter type (example PDO::PARAM_INT for an integer) and choose whether the value is bound by reference or by value.
1st
I've gone through all the vdos of the older php playlist of yours, just wanted to know if it is fine to add php on my resume with that knowledge
My older course is lacking many elements, such as proper security. My newer course is so much better at explaining the different subjects in depth, as well as covering security.
If you were to watch the new course + the OOP PHP course, then you could say you have a "fundamental understanding of core PHP".
If you want to be a more "complete PHP developer", then you should also add a framework to your knowledge. Such as Laravel. Since a framework is more commonly used in a professional production environment.
Is secure to have all mysql data like password and username in php file?
Informative video as always, great pleasure learning from the best. I like your Audio setup, sound is loud and clear. What are you using for audio and visual? I will appreciate your recommendations, planning to set up a UA-cam channel before the end of the year. Keep up the good work.
Thank you 😊 OBS for recording, and Premiere for editing, color grading, and audio enhancement 🙂
@@Dani_Krossing Thank you Dani, I am learning OBS through your able tutorials. Downloaded and installed, looking forward to the next installment of your tutorials. One more thing, which mic device do you recommend?
It depends a lot on what you prefer. I personally just use a USB microphone, which provides great quality and doesn’t require a more expensive investment by getting a soundboard.
Mic wise, I prefer the Blue Yeti or the Audio Technica AT2020 (USB version of course), but if you have a soundboard, then the AT2020 also comes as a normal mic.
The Yeti has a deeper more “pleasent” sound to it, where as the AT2020 has a clearer sound to it. 🙂
Look wise the AT2020 is dark and has a cool blue light indicator in front, to let you know which side is which. The Yeti comes in a variety of colors, where I prefer the dark grey.
But keep in mind that the Yeti is great for just standing on the desk in front of you, where the AT2020 is better in a mic arm.
Hope this was useful 🙂
@@Dani_Krossing 101% helpful, thank you once more. Enjoy the rest of your day.
I learned a lot in this channel I'm just new in php but i just want to know to add multiple data in data base in just one process for example adding 5 data in one process😂 is that even possible?😅😅😅 I'm just curious though 🤔😊
How to do authentication and authorization in PHP rest api in vanilla php without frameworks and libs
Please we need to see download of Document using php
these tutorials are informative but I am deer in headlights arg my brain
bro looks like elon musk from canda
:)
Third :D