php data object (pdo) khaled al-sham’aa. what is pdo? pdo is a php extension to formalise...

PHP Data Object (PDO) Khaled Al-Sham’aa

Upload: augustine-hancock

Post on 27-Dec-2015

229 views

Category:

Documents

0 download

Report

Download

Tags:

Embed Size (px):

TRANSCRIPT

PHP Data Object (PDO)Khaled Al-Sham’aa

What is PDO?

• PDO is a PHP extension to formalise PHP's database connections by

creating a uniform interface. This allows developers to create code

which is portable across many databases and platforms.

• PDO is not just another abstraction layer like PEAR DB or ADOdb.

Page 3: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Why use PDO?

• Portability

• Performance

• Power

• Easy

• Runtime Extensible

Page 4: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

What databases does it support?

• Microsoft SQL Server / Sybase

• Firebird / Interbase

• DB2 / INFORMIX (IBM)

• MySQL

• OCI (Oracle Call Interface)

• ODBC

• PostgreSQL

• SQLite

Page 5: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

DSNs

• In general

drivername:<driver-specific-stuff>

• mysql:host=name;dbname=dbname

• odbc:odbc_dsn

• oci:dbname=dbname;charset=charset

• sqlite:/path/to/db/file

• sqlite::memory:

Page 6: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Connect to MySQL

Page 7: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Connect to SQLite (file)

Page 8: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Connect to SQLite (memory)

Page 9: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Connect to Oracle

Page 10: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Connect to ODBC

Page 11: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Close a Database Connection

Page 12: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Persistent PDO Connection

• Connection stays alive between requests

$dbh = new PDO($dsn, $user, $pass,

array(

PDO_ATTR_PERSISTENT => true

)

);

Page 13: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

PDO Query (INSERT)

Page 14: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

PDO Query (UPDATE)

Page 15: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

PDO Query (SELECT)

Page 16: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Error Handling (1)

Page 17: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Error Handling (2)

Page 18: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Error Handling (3)

Page 19: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Error Handling (4)

Page 20: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Prepared statements

Page 21: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Transactions

Page 22: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Get Last Insert Id

Page 23: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Benchmark

MySQL SELECT Benchmark Results, 1000 Requests

Library Concurrency Total Time Requests/Sec. Speedup

ADOdb 1 20.90/sec 47.84 -

PDO 1 0.73/sec 1358.62 +2840%

ADOdb 50 10.78/sec 99.23 -

PDO 50 0.54/sec 1850.90 +1865%

ADOdb 100 10.44/sec 95.78 -

PDO 100 0.53/sec 1869.33 +1952%

Page 24: PHP Data Object (PDO) Khaled Al-Sham’aa. What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface

Questions

DB2 and PHP - Zend the PHP Company€¦ · 13.09.2012 · • PDO = PHP Data Objects ... •When using library lists, ... Alan Seiden Consulting DB2 and PHP Best Practices on IBM

Databases PHP Data Objects (PDO) Session variables Filesindex-of.co.uk/lectures/IA_06_internet-apps-php-db-mysql.pdf · PHP Data Objects (PDO) • Accessing the database from PHP

Supporting The Life You Choose PHP Care Complete FIDA …phpcares.org/wp-content/uploads/2014/05/20180108_Provider... · through PHP's Utilization Management? Skilled Nursing Facility

PDO PHP Database Extension - phpgurukul.com...PDO (PHP Data Objects) is a PHP extension through which we can access and work with databases. Though PDO is similar in many aspects to

About the Tutorial - IFM · PHP 3 Characteristics of PHP Five important characteristics make PHP's practical nature possible: Simplicity Efficiency Security

PHP Data Objects Layer (PDO) Ilia Alshanetsky. What is PDO Common interface to any number of database systems. Common interface to any number of database

SQLITE Php Pdo Referance

Before we begin · Before we begin 1.Ensure you have PHP 7.1.3 installed with these extensions: OpenSSL Mbstring Tokenizer XML Ctype JSON PDO SQLite PDOSqlite (use php -m to confirm)

Databases PHP Data Objects (PDO) Session variables Filesthe-eye.eu/public/Site-Dumps/index-of/index-of.co... · PDO – retrieve data 1 • Data is obtained via the ->fetch(), a method

PHP AND DATABASES IN MYSQL - luleahmedi.uni-pr.edululeahmedi.uni-pr.edu/docs/teaching/ip/lectures/PHPMySQL.pdf · Generic Database API: PDO PDO stands for PHP Data Objects Object-oriented

PHP Workshop ‹#› أطلق إبداعك 2 أطلق إبداعك 2 مدرس معتمد من مركز زووم PHP Data Object (PDO)

PHP: MySQL. PHP Connect to MySQL PHP 5 and later can work with a MySQL database using: – MySQLi extension (the "i" stands for improved) – PDO (PHP Data

PHP Data Objects Layer (PDO)

Actian Hybrid Data Conference · •apt-get install php5-odbc Option 2: Install PDO –PHP Data Objects ... nginx 11474 11473 0 11:08 ? 00:00:00 php-fpm: pool www nginx 11475 11473

Php 2 - Approfondissement MySQL, PDO et MVC

Quebec pdo

PHP Data Object (PDO)

PDO PHP Database Extension - freeproject24.comfreeproject24.com/wp-content/uploads/2018/10/PDO-PHP-database... · PDO – PHP database extension 2. ... How to delete records? 6. PHP

Firewall SQL - n Firewall SQL.pdf · PDF file–C++, C, C#, Perl, PHP, Python, Ruby, Java, TCL •Capas de abstracción –ADO.NET, Perl DBI, Python DB, Ruby DBI, PHP PDO, ODBC, JDBC

AOP PHP Extension - cnblogs.com€¦ · 1.1 PHP's AOP extension history. The AOP extension is a project which started a while ago even if its development is quite very new (early

PHP - What is it? Taken directly from PHP's home, PHP.net ... · For those who are experienced enough to do this yourself, simply head over to PHP.net - Downloads and download the

PHP's Filter Module

Estimated Beneficiaries PDO 4a. Direct PDO 5a. Project

PHP Workshop ‹#› PHP Data Object (PDO). PHP Workshop ‹#› What is PDO? PDO is a PHP extension to formalise PHP's database connections by creating a uniform

PHP Data Objects Wez Furlong. About the author PHP Core Developer since 2001 Author of the Streams layer “King” of PECL Author of most of PDO and its

PHP - PDO Objects

PHP Data Objectswezfurlong.org/images/PDO.pdf · What is PDO? • PHP Data Objects • A set of PHP extensions that provide a core PDO class and database specific drivers • Focus

PHP & MySQL Database - carme.cs.trinity.educarme.cs.trinity.edu/thicks/3343/Lectures/PHP-MySQL-Slides.pdf · PHP's mysqli Extension –1 The mysqli extension, or as it is sometimes

CERTIFICATE PRACTICES FOR PDO NDS SUBSCRIBERS Practices for PDO NDS... · CERTIFICATE PRACTICES FOR PDO NDS SUBSCRIBERS ... The digital certificate issued for PDO NDS subscribers

Modulation of PDO on the predictability of the interannual ...duanws.lasg.ac.cn/ueditor/php/upload/file/20190903/1567486975621765.pdfModulation of PDO on the predictability of the

PHP's FIG and PSRs

query("SQL query"); PHP" href="https://vdocuments.us/cse-154-querying-a-database-in-php-with-pdo-name-new-pdodbprogramdbnamedatabasehostserver.html">CSE 154 - courses.cs.washington.eduQuerying a Database in PHP with PDO $name = new PDO("dbprogram:dbname=database;host=server", username, password); $name->query("SQL query"); PHP

Solar Power Project - PDO | PDO Project

php data object (pdo) khaled al-sham’aa. what is pdo? pdo is a php extension to formalise...

Documents

mysql slide

odbc slide

oracle slide

true slide

transactions slide

sqlite memory slide

pdo query insert slide

sqlite file slide