I migliori video
In this lesson, you will learn how to connect to the database from PHP using PHP Data Objects or in short PDO. PDO provides data access layer abstraction where common methods can be used to interact with different databases like MySQL, SQLite, and so on. You will learn about prepared statements, what SQL injection is & how it works, how to prevent SQL injection, learn about the difference between binding params by value or by reference, the difference between placeholders & named parameters, emulated prepares & so on.
NOTE: If you have concerns/questions about 15:28 please watch the beginning of Part 2 of the PDO lesson, I address & explain there. This is just a debug query & to save an extra line I decided to pass an integer directly to the query. I don't recommend you do that, even though this particular example has no SQL Injection vulnerability, someone might make a mistake & introduce the vulnerability. https://www.youtube.com/watch?v=e6yLUvpcOZo
SOME OF THE WAYS YOU CAN SUPPORT THE CHANNEL
👍 Smash the like button
🤝 Subscribe to the channel & turn the notifications on
💬 Post comments, any feedback is greatly appreciated
⭐ Become a Patreon: https://www.patreon.com/programwithgio
THANK YOU!
LESSON 2.30
Course Outline - https://github.com/ggelashvili..../learnphptherightway
Course Playlist - https://www.youtube.com/playli....st?list=PLr3d3QYzkw2
RESOURCES
https://www.php.net/manual/en/book.pdo.php
https://www.php.net/manual/en/pdo.connections.php
https://www.php.net/manual/en/....pdo.error-handling.p
https://www.php.net/manual/en/class.pdo.php
https://www.php.net/manual/en/....class.pdostatement.p
https://www.php.net/manual/en/pdo.constants.php
https://www.php.net/manual/en/ref.pdo-mysql.php
https://github.com/php/php-src..../blob/master/ext/pdo
CHAPTERS
00:00 - Intro
01:12 - Install/enable PDO MySQL
02:45 - PDO connection
05:52 - Error modes
06:34 - Run queries & fetch data
07:36 - Fetch modes
09:14 - Prepared statements & SQL injection
10:12 - SQL injection example
13:43 - Placeholders, named parameters & the difference between them
18:03 - Bind parameters using bindValue & bindParam
22:18 - Emulated prepares
Have the Lost Room 403 Key in Warzone 2.0/DMZ Season 2 (Ashika)? This guide shows you where it is, as well as how to use it. It's super simple!
::: DMZ Key Locations :::
View all the DMZ Key locations in this playlist: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
- Ashika (Season 2): https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
::: DMZ Missions (Season 2 - Ashika) :::
- ASHIKA Legion Missions: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
- ASHIKA White Lotus Missions: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
- ASHIKA Black Mous Missions: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
- ALL DMZ ASHIKA MISSIONS: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
::: DMZ Dead Drop Locations :::
- https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
ALL DMZ SEASON 2 (ASHIKA) VIDEOS: https://www.youtube.com/playli....st?list=PLHJwC0YxbG3
Subscribe to https://youtube.com/TroubleChute for more in-depth videos! This is my "Everything else" channel. There are NO stupid questions, only more simple ones. That's what this channel, TroubleChute Basics, targets - Leaving nobody in the dark.
#DMZ #Key #Location
-----------------------------
💸 Found this useful? Help me make more! Support me by becoming a member: https://youtube.com/channel/UC....kih2oVTbXPEpVwE-U7km
-----------------------------
💸 Direct donations via Ko-Fi: https://ko-fi.com/TechNobo
💬 Discuss video & Suggest (Discord): https://s.tcno.co/Discord
🎮 Gaming channel: https://www.YouTube.com/TechNobo
🌐 Website: https://tcno.co
📧 Need voice overs done? Business query? Contact my business email: TroubleChute (at) tcno.co
Everything in this video is my personal opinion and experience, and should not be considered professional advice. Always do your own research and make sure what you're doing is safe.
😆Watch more of Funniest Animals Ever! https://youtube.com/playlist?l....ist=PLCDgRQBM9ZHDPQd
--------------------------------------------------------------------------------------------------------
🔔Subscribe to our channel for the funniest and cutest animals! https://youtube.com/channel/UC....P83iCyLq0Q5VdaQKp0r7
--------------------------------------------------------------------------------------------------------
Music licensed or from Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0
creativecommons.org/licenses/by/3.0/
--------------------------------------------------------------------------------------------------------
#FunniestAnimals #CuteAnimals #Animals #FunnyAnimals