PHP Data Objects ( PDO / ˌpi di ˈoʊ / ) is an extension for PHP that provides the developer with a universal interface for accessing various databases .
PDO offers common methods for working with various databases, although the text of the queries may vary slightly. Since many DBMS implement their own dialect of SQL , which to one degree or another supports the ANSI and ISO standards , using simple queries can achieve compatibility between different languages. In practice, this means that you can easily switch to another DBMS, without changing or partially changing the program code.
Content
Speed and Scalability
PDO does not use abstract layers to connect to the database, like ODBC , but uses their "native" drivers for different databases, which allows to achieve high performance. Currently, there are drivers for PDO for almost all well-known DBMSs and interfaces. PDO also allows you to work simultaneously with multiple databases.
Protection
Of the methods for dealing with sql injections, prepared appeared. A prepared statement is a precompiled SQL statement that can be executed multiple times by sending only different data sets to the server. An additional advantage is the inability to conduct SQL injection through the data used in placeholders.
Library Updates Discontinued .
See also
- Php
- Adob