ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:database:pdo_new

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:database:pdo_new [2022/03/20 20:10] – [ODBC] mnewnhamv5:database:pdo_new [2023/01/24 04:00] (current) – mnewnham
Line 1: Line 1:
-====== PDO ======+====== PDO (new) ====== 
 +<WRAP important> 
 +This is still [[https://github.com/ADOdb/ADOdb/pull/826|under development]].  
 +Feedback is welcome, just add your comments in the pull request. 
 +</WRAP> 
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP right box round 300px> <WRAP right box round 300px>
Line 14: Line 19:
 ===== Description ===== ===== Description =====
  
-This driver supports connections using the standardized [[http://php.net/manual/en/book.pdo.php|PHP Data Objects]].This page refers to ADOdb release 5.23.0 and higher. For previous versions of ADOdb, see the [[v5:database:pdo_old|Previous Version Of This Page]].+This driver supports connections using the standardized [[http://php.net/manual/en/book.pdo.php|PHP Data Objects]].This page refers to ADOdb release 5.23.0 and higher. For previous versions of ADOdb, see the [[v5:database:pdo|Previous Version Of This Page]].
  
 Except for the ''pdo_odbc'' driver, all PDO drivers include support for full data dictionary functions (e.g. ''createTableSql()'',''addIndexSql()'', etc.) Except for the ''pdo_odbc'' driver, all PDO drivers include support for full data dictionary functions (e.g. ''createTableSql()'',''addIndexSql()'', etc.)
Line 125: Line 130:
  
   * This driver requires the installation of the IBM DB2 client   * This driver requires the installation of the IBM DB2 client
 +  * See the [[v5:database:ibm_db2|Preferred Driver]] page for more information about building DSNs for use with DB2 connections.
  
 ------------------------------------------------------- -------------------------------------------------------
Line 132: Line 138:
 $db   = ADOnewConnection('pdo\ibm'); $db   = ADOnewConnection('pdo\ibm');
  
-$dsn = 'hostname=192.168.86.141;protocol=tcpip;port=50000;';+$dsn = 'hostname=192.168.86.141;protocol=tcpip;port=25010;';
 $dsn.= 'database=SAMPLE;uid=db2inst1;pwd=somepassword'; $dsn.= 'database=SAMPLE;uid=db2inst1;pwd=somepassword';
 $user = ''; $user = '';
Line 193: Line 199:
   * It is useful for reading and simple writes to data sources such as Microsoft Access, Excel and Google Sheets   * It is useful for reading and simple writes to data sources such as Microsoft Access, Excel and Google Sheets
   * There is no support for Data Dictionary functions or database specific items such as sequences.    * There is no support for Data Dictionary functions or database specific items such as sequences. 
-  * +
 ------------------------------------------------------- -------------------------------------------------------
 === Sample Connection String === === Sample Connection String ===
v5/database/pdo_new.1647803409.txt.gz · Last modified: 2022/03/20 20:10 by mnewnham