PHP PDO Tutorial Part 1 - Prepared Statements - SQL Injection - Full PHP 8 Tutorial
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. • PHP PDO Tutorial Part 2 - Transaction...
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: / programwithgio
THANK YOU!
LESSON 2.30
Course Outline - https://github.com/ggelashvili/learnp...
Course Playlist - • Learn PHP The Right Way - Full PHP Tu...
RESOURCES
https://www.php.net/manual/en/book.pd...
https://www.php.net/manual/en/pdo.con...
https://www.php.net/manual/en/pdo.err...
https://www.php.net/manual/en/class.p...
https://www.php.net/manual/en/class.p...
https://www.php.net/manual/en/pdo.con...
https://www.php.net/manual/en/ref.pdo...
https://github.com/php/php-src/blob/m...
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
On this page of the site you can watch the video online PHP PDO Tutorial Part 1 - Prepared Statements - SQL Injection - Full PHP 8 Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Program With Gio 20 July 2021, share the link with friends and acquaintances, this video has already been watched 41,027 times on youtube and it was liked by 1.1 thousand viewers. Enjoy your viewing!
