- 浏览: 183645 次
- 性别:
- 来自: 北京
最新评论
-
heping45:
有待进步,不知所云
WEB流程图(jquery实现) -
zhoupuyue:
html有一个小错误:<script> $(fu ...
漂亮的Jquery的日期控件(精减) -
dcdc723:
happy175 写道大家是怎么用的啊,我的怎么没有反应?这是 ...
漂亮的Jquery的日期控件(精减) -
happy175:
大家是怎么用的啊,我的怎么没有反应?这是我的代码:
<! ...
漂亮的Jquery的日期控件(精减) -
nianshi:
加上Html文件多好啊
漂亮的Jquery的日期控件(精减)
Definitely, a good point to start demonstrating the excellent functionality provided by the PDO extension is in showing how it can be used to connect to diverse database systems. Therefore, I coded a simple script that establishes a new connection to MySQL, using the pertinent PDO constructor.
The signature of the script is as follows:
// example connecting to MySQL with the PDO extension
$dbh = new PDO('mysql:host=localhost;dbname=alejandro','user','password');
Certainly, after examining the above script, you'll have to agree with me that connecting to a specific database system, in this case MySQL, is a process that can be easily performed with the PDO library. The procedure is reduced to creating a new instance of the PDO class and passing to its constructor the proper connection parameters.
As you can see, the constructor accepts these incoming arguments in the form of a typical connection string (very similar to the notation used with ODBC databases), where the host is told where to connect, the selected database, and finally that the corresponding user/password combination must be supplied in the proper sequence.
Well, once a successful connection has been established to the specific database server, a new PDO object is returned to client code. This object allows the performance of a great variety of database-related tasks, which will be covered in detail over the new few lines, so don't worry about them for the moment.
Now, let me return to the previous script and show you how to close the connection that was opened to the specified MySQL server. This procedure is achieved as follows:
// example closing a connection to MySQL
$dbh = new PDO('mysql:host=localhost;dbname=alejandro','user','password');
// close MySQL connection by assigning a NULL value to PDO object
$dbh = NULL;
This isn't rocket science at all. As you can see, closing an established connection is performed by assigning a NULL value to the pertinent PDO object, as indicated above. Quite simple, right?
Now that you have learned how to use the PDO extension to open and close a connection to a sample MySQL database server, let me show you how to perform the same tasks with an Oracle system. Here is how these processes are done:
// example connecting to Oracle Call Interface
$dbh=new PDO('oci:','user','password');
// example closing a connection to Oracle Call Interface
$dbh=new PDO('oci:','user','password');
// close Oracle connection by assigning a NULL value to PDO
object
$dbh = NULL;
As you can see, the process of opening and closing a connection to an Oracle database server is nearly identical to the one utilized with MySQL. However, you may want to see more examples of connecting to different database systems. Below I included a few short scripts that demonstrate how to perform these connections. Please take a look.
//**************************************************
// example opening an ODBC connection
$dbh= new PDO('odbc:EXAMPLE','db2inst','ibmdb');
//**************************************************
// example closing an ODBC connection
$dbh= new PDO('odbc:EXAMPLE','db2inst','ibmdb');
// close ODBC connection by assigning a NULL value to PDO object
$dbh = NULL;
//**************************************************
// example opening a connection to SQLITE 2 (available in PHP
5.1)
$dbh= new PDO('sqlite2:/databases/mydb.sq2');
//**************************************************
// example closing a connection to SQLITE 2
$dbh= new PDO('sqlite2:/databases/mydb.sq2');
// close SQLITE2 connection by assigning a NULL value to PDO
object
$dbh = NULL;
As shown above, connecting to MySQL, Oracle or SQLite 2 is reduced to passing the proper connection parameters to the respective PDO constructor, since all of the tasks related to handling a specific database system are performed behind the scenes. Also, it's worthwhile to stress here that the connection strings used with all the previous examples may vary according to the database used. Therefore, I suggest you have a look at the PDO official documentation, located at http://ww.pdo.php.net, for further details.
At this point, you have learned how to connect to different database servers, but you may be wondering what happens if a particular connection fails. Well, the PDO library really shines in this aspect, since if an error occurs, a PDO exception (yes, you read correctly) is thrown, which allows it to easily handle any potential problem with elegance and efficiency.
This process is illustrated by the script below; please examine its signature.
// example using the PDO Exception (an exception is thrown when
an error occurs at connecting or when performing other tasks)
try{
$dbh=new PDO('mysql:host=localhost;dbname=alejandro',$user,$password);
}
catch(PDOException $e){
echo 'Error connecting to MySQL!: '.$e->getMessage();
exit();
}
As you can see, the above example clearly demonstrates how to use a PDO exception to handle a failed connection. However, the functionality of this proprietary exception mechanism doesn't stop here. Different exceptions will be triggered when performing queries, handling results sets, and so forth, which can be really useful for having all the eventual errors handled by a centralized module.
Okay, now that you have seen how to open and close a connection to different database systems, it's time to examine other methods included with the PDO extension. In this case, I'm going to show you how to run queries against a concrete database, so if you're interested on seeing how this will be achieved, click on the link below and keep reading.
发表评论
-
cassandra CONNECT
2012-02-25 12:22 1849<?php // Setting up no ... -
cgi 启动问题
2011-09-23 16:08 814/usr/local/bin/spawn-fcgi -a 12 ... -
Using PDO Objects in PHP 5 - Finding insertion IDs for database rows
2010-12-22 13:07 1030As I pointed out in the section ... -
Using PDO Objects in PHP 5 - Running queries against a specific
2010-12-22 12:41 1033Naturally, after learning ho ... -
discuz7.2 二次开发---------后台添加菜单
2010-09-15 15:13 1676menu.inc.php showmenu('te ... -
discuz 文件说明
2010-09-10 15:39 7385文件颜色说明:红色:程序核心文件,修改这类文件时千万要注意安全 ... -
discuz 7.2数据库表结构
2010-09-09 15:54 5869discuz 7.2数据库结构表 discuz, 结构, 数据 ... -
smarty变量操作符
2010-09-05 14:17 820capitalize [首字母大写] count_char ... -
eclipse自动补全
2010-09-05 11:11 1319eclipse自动补全配置 -
根据IP自动切换城市(腾讯网接口)
2010-05-27 10:02 2757<script src="http://fw. ... -
常用类
2010-05-04 10:41 755// 过滤html代码 function SpHtml2 ... -
用jcrop裁剪图片
2010-04-16 14:42 1137<? if ($_SERVER['REQUEST_ME ... -
图片加水印
2010-04-16 09:59 766$file="7.jpg"; $widt ... -
php创建验证字符图片
2010-04-16 09:24 818<?php //(1)创建背景图像。建立一幅150* ... -
php加密解密
2010-04-15 17:07 1183<? define('UC_KEY','finger ... -
icon生成类
2010-04-14 17:40 924<?php $output = "&qu ... -
jquery 操作复选框 取值
2010-02-26 17:50 1347<? //引入类 ?> <!DOCTY ... -
smarty 基本配置、应用
2010-02-23 21:40 1206//以下为:smart_inc.php include_o ... -
PHP 通用分页类PagerBox及使用
2010-02-04 21:36 1484<?php //使用实例 //$totalNum = ... -
PHP SOCKET()方式发送邮件(附php类)
2010-02-03 21:48 2383fsockopen(string hostname, ...
相关推荐
PHP-MySQL-PDO-Database-Class-master
php-pdo-sqlsrv-5.9.0-8.0-nts-vs16-x64.zip
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
内附msodbcsql(32+64)安装包+php_pdo_sqlsrv(5.3-5.6)配置文件,外加thinkphp5多数据库连接教程,和thinkphp5连sql server Demo,清晰易懂
php8连接mssql所需要的几个文件 php_pdo_sqlsrv-5.9.0-8.0-ts-vs16-x64 php_sqlsrv-5.9.0-8.0-ts-vs16-x64 VC_redist.x64 SQLSRV58 msodbcsql
官方离线安装包,亲测可用
离线安装包,亲测可用
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
官方离线安装包,亲测可用。使用rpm -ivh [rpm完整包名] 进行安装
php7 安装依赖
./configure --prefix=/opt/php --enable-static=yes --enable-fpm --enable-mysqlnd --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --enable-mysqlnd-compression-support --with-curl --with-freetype-dir --...
离线安装包,亲测可用
离线安装包,亲测可用
官方离线安装包,亲测可用
PDO_MYSQL-1.0.2.tgz PDO_MYSQL-1.0.2.tgz
离线安装包,亲测可用
PDO 是一个“数据库访问抽象层”,作用是统一各种数据库的访问接口,与mysql 和mysqli 的函数库相比,PDO 让跨数据库的使用更具有亲和力;...PDO->setAttribute() — 为一个“数据库连接对象”设定属性
we are reaching an important milestone by releasing a Community Technology Preview (CTP) of the new SQL Server Driver for PHP 2.0, which includes support for PHP Data Objects (PDO). Alongside our ...
-Php-Pdo-Blog-Site
官方离线安装包,亲测可用