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)
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.
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 RU-vid 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 🙂
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.
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 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 🤔😊
