search
HomeBackend DevelopmentPHP TutorialSimple use of PDO in PHP5_PHP tutorial

Simple use of PDO in PHP5_PHP tutorial

Jul 13, 2016 pm 05:33 PM
dataobjectpdophpphp5mainstreamusedevelopyesnowofSimplelanguage

  PDO(php(做为现在的主流开发语言) Data Object) 是php(做为现在的主流开发语言) 5新出来的东西,在php(做为现在的主流开发语言) 6都要出来的时候,php(做为现在的主流开发语言) 6只默认使用PDO来处理数据库,将把所有的数据库扩展移到了PECL,那么默认就是没有了我们喜爱的php(做为现在的主流开发语言)_MySQL(和PHP搭配之最佳组合).dll之类的了,那怎么办捏,我们只有与时俱进了,我就小试了一把PDO。(本文只是入门级的,高手可以略过,呵呵)

  【PDO是啥】

  PDO是php(做为现在的主流开发语言) 5新加入的一个重大功能,因为在php(做为现在的主流开发语言) 5以前的php(做为现在的主流开发语言)4/php(做为现在的主流开发语言)3都是一堆的数据库扩展来跟各个数据库的连接和处理,什么 php(做为现在的主流开发语言)_MySQL(和PHP搭配之最佳组合).dll、php(做为现在的主流开发语言)_pgsql.dll、php(做为现在的主流开发语言)_mssql(WINDOWS平台上强大的数据库平台).dll、php(做为现在的主流开发语言)_sqlite.dll等等扩展来连接MySQL(和PHP搭配之最佳组合)、PostgreSQL、MS sql server(WINDOWS平台上强大的数据库平台)、SQLite,同样的,我们必须借助 ADOdb、PEAR::DB、php(做为现在的主流开发语言)lib::DB之类的数据库抽象类来帮助我们,无比烦琐和低效,毕竟,php(做为现在的主流开发语言)代码的效率怎么能够我们直接用C/C++写的扩展斜率高捏?所以嘛,PDO的出现是必然的,大家要平静学习的心态去接受使用,也许你会发现能够减少你不少功夫哦。

  【安装PDO】

  我是在Windows XP SP2 上面,所以嘛,整个过程都是在Windows行进行的啦,至于Linux/FreeBSD 等平台,请自行查找资料设置安装。
我的是php(做为现在的主流开发语言) 5.1.4,已经自带有了php(做为现在的主流开发语言)_pdo.dll的扩展,不过需要稍微设置一下才能使用。

  打开 c:windowsphp(做为现在的主流开发语言).ini ,那是我的php(做为现在的主流开发语言)配置文件,找到下面这行:

  extension_dir

  这个就是我们扩展存在的目录,我的php(做为现在的主流开发语言) 5扩展是在:C:php(做为现在的主流开发语言)5ext,那么我就把这行改成:

  extension_dir = "C:/php(做为现在的主流开发语言)5/ext"

  然后再往php(做为现在的主流开发语言).ini下面找到:

  ;;;;;;;;;;;;;;;;;;;;;;
  ; Dynamic Extensions ;
  ;;;;;;;;;;;;;;;;;;;;;;

  下面有一堆类似 ;extension=php(做为现在的主流开发语言)_mbstring.dll 的东西,这里就是php(做为现在的主流开发语言)扩展加载的配置了,我们再最后面添加上我们PDO的扩展:

extension=php(做为现在的主流开发语言)_pdo.dll
extension=php(做为现在的主流开发语言)_pdo_MySQL(和PHP搭配之最佳组合).dll
extension=php(做为现在的主流开发语言)_pdo_pgsql.dll
extension=php(做为现在的主流开发语言)_pdo_sqlite.dll
extension=php(做为现在的主流开发语言)_pdo_mssql(WINDOWS平台上强大的数据库平台).dll
extension=php(做为现在的主流开发语言)_pdo_odbc.dll
extension=php(做为现在的主流开发语言)_pdo_firebird.dll
;extension=php(做为现在的主流开发语言)_pdo_oci8.dll

Various PDO drivers can be added, but the following php(as the current mainstream development language)_pdo_oci8.dll, because I did not install the Oralce database, so Without this, just comment it out using a semicolon. Then restart our Web server, iis(Microsoft's WEB server platform)/apache(the most popular WEB server platform on Unix platform), mine is iis(Microsoft's WEB server platform) , hey, you look down on me, it’s easy on Windows.

After restarting, write a php (as the current mainstream development language) info.php (as the current mainstream development language) in the document directory of our web server files, add these:

<?
 php(as the current mainstream development language)info();
?>

Then open our lovely browser: IE/FireFox, mine is FireFox 2.0, I just downloaded it, it’s great, I’m not afraid of rogue software, haha.

Enter in the browser: http://localhost/php(as the current mainstream development language)info.php(as the current mainstream development language), if your path to this page is inconsistent, please enter it yourself.

In the output content, if you can see it smoothly:

PDO
PDO support enabled
PDO drivers MySQL (the best combination with PHP) , pgsql, sqlite, mssql(a powerful database platform on WINDOWS platform), odbc, firebird

There are various driver instructions at the back: PDO_Firebird, pdo_mssql(WINDOWS Powerful database platform on the platform) , pdo_MySQL (the best combination with PHP) , PDO_ODBC, pdo_pgsql, pdo_sqlite

Then, congratulations on your successful installation, otherwise please be careful Check the steps above.

 【Little Trial】

I use MySQL(the best combination with PHP) 4.0.26, but I personally recommend that everyone use MySQL (The best combination with PHP) 4.1.x or MySQL (The best combination with PHP) 5.0.x, because those versions have a lot of interesting things worth learning. What our PDO needs to connect to is my MySQL(The best combination with PHP) 4.0. If you have not installed MySQL(The best combination with PHP), please Install it yourself. We have established MySQL (the best combination with PHP) , and added table foo to the test library, including four fields such as id, name, gender, and time.

We started to construct the first PDO application and created a pdo.php (as the current mainstream development language) file in the Web document directory:

<? php(as the current mainstream development language)
 $dsn = "MySQL(the best combination with PHP):host=localhost;dbname=test";
$db = new PDO($dsn, root, );
$count = $db->exec("INSERT INTO foo SET name = heiyeluren,gender=male,time=NOW()");
echo $count;
$db = null;
?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/508646.htmlTechArticlePDO (php (as the current mainstream development language) Data Object) is php (as the current mainstream development language) Language) 5 new things will come out in PHP (as the current mainstream development language) 6...
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Explain the concept of a PHP session in simple terms.Explain the concept of a PHP session in simple terms.Apr 26, 2025 am 12:09 AM

PHPsessionstrackuserdataacrossmultiplepagerequestsusingauniqueIDstoredinacookie.Here'showtomanagethemeffectively:1)Startasessionwithsession_start()andstoredatain$_SESSION.2)RegeneratethesessionIDafterloginwithsession_regenerate_id(true)topreventsessi

How do you loop through all the values stored in a PHP session?How do you loop through all the values stored in a PHP session?Apr 26, 2025 am 12:06 AM

In PHP, iterating through session data can be achieved through the following steps: 1. Start the session using session_start(). 2. Iterate through foreach loop through all key-value pairs in the $_SESSION array. 3. When processing complex data structures, use is_array() or is_object() functions and use print_r() to output detailed information. 4. When optimizing traversal, paging can be used to avoid processing large amounts of data at one time. This will help you manage and use PHP session data more efficiently in your actual project.

Explain how to use sessions for user authentication.Explain how to use sessions for user authentication.Apr 26, 2025 am 12:04 AM

The session realizes user authentication through the server-side state management mechanism. 1) Session creation and generation of unique IDs, 2) IDs are passed through cookies, 3) Server stores and accesses session data through IDs, 4) User authentication and status management are realized, improving application security and user experience.

Give an example of how to store a user's name in a PHP session.Give an example of how to store a user's name in a PHP session.Apr 26, 2025 am 12:03 AM

Tostoreauser'snameinaPHPsession,startthesessionwithsession_start(),thenassignthenameto$_SESSION['username'].1)Usesession_start()toinitializethesession.2)Assigntheuser'snameto$_SESSION['username'].Thisallowsyoutoaccessthenameacrossmultiplepages,enhanc

What are some common problems that can cause PHP sessions to fail?What are some common problems that can cause PHP sessions to fail?Apr 25, 2025 am 12:16 AM

Reasons for PHPSession failure include configuration errors, cookie issues, and session expiration. 1. Configuration error: Check and set the correct session.save_path. 2.Cookie problem: Make sure the cookie is set correctly. 3.Session expires: Adjust session.gc_maxlifetime value to extend session time.

How do you debug session-related issues in PHP?How do you debug session-related issues in PHP?Apr 25, 2025 am 12:12 AM

Methods to debug session problems in PHP include: 1. Check whether the session is started correctly; 2. Verify the delivery of the session ID; 3. Check the storage and reading of session data; 4. Check the server configuration. By outputting session ID and data, viewing session file content, etc., you can effectively diagnose and solve session-related problems.

What happens if session_start() is called multiple times?What happens if session_start() is called multiple times?Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

How do you configure the session lifetime in PHP?How do you configure the session lifetime in PHP?Apr 25, 2025 am 12:05 AM

Configuring the session lifecycle in PHP can be achieved by setting session.gc_maxlifetime and session.cookie_lifetime. 1) session.gc_maxlifetime controls the survival time of server-side session data, 2) session.cookie_lifetime controls the life cycle of client cookies. When set to 0, the cookie expires when the browser is closed.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.