Assignment: Research PDO

Click Here to Return to Homework Page

Research PDO

1. What does PDO mean?
• "PDO stands for PHP Data Object"-- Credit--http://php.net/manual/en/intro.pdo.php
2. What does PDO do?
• "Used to communicate with databases. It is unique in that it does not matter what type of database you are communicating with, unlike mySQLi commands that are designed to talk to a mySQL database"-- Credit--http://php.net/manual/en/intro.pdo.php
3. What are some of the advantages of using PDO?
• "Use of prepared statements, multiple database support"-- Credit--https://www.quora.com/What-are-advantages-of-PDO-in-PHP
4. What are some issues you need to be aware of when using PDO?
• "Not completely sure. Did not find any issues except maybe this on: PDO substitutes placeholders with actual data, instead of sending it separately. And with "lazy" binding (using array in execute()), PDO treats every parameter as a string. As a result, the prepared LIMIT ?,? query becomes LIMIT '10', '10' which is invalid syntax that causes query to fail."-- Credit--https://phpdelusions.net/pdo#limit
5. What do you need to do to include PDO in your PHP pages?
• "PDO is Object Orintated, so you need a 'new' instance"-- Credit--http://php.net/manual/en/pdo.connections.php