Three ways to connect the PDO database

Before using PDO to connect to a database, install and configure the PDO

Base. PHP is as follows:

[PHP]View PlainCopy

1. <strong><span style="FONT-SIZE:18PX;" ><?php
2. Header (' Content-type:text/html;charset=utf-8 ');
3. Array Debug functions
4. function Show_bug ($msg) {
5. echo ' <pre> ';
6. Print_r ($msg);
7. echo ' </pre> ';
8. }
9. ?></span></strong>

1.pdo linking the database via parametric form

[HTML]View PlainCopy

2. <strong><span style="FONT-SIZE:18PX;"  >include_once "base.php";
4. try{
6. $DSN is the data source
8. $dsn=' MYSQL:HOST=LOCALHOST;DBNAME=IMOOC ';
10. $username=' root ';
12. $passwd=';
14. $pdo=New PDO ($DSN, $username, $passwd);
16. If the connection is successful, you get the PDO object.
18. Show_bug ($PDO);
20. }catch (Pdoexception $e) {
22. Echo $e->getmessage ();
24. }</span></strong>

2.pdo connecting the database by URI
Create a new Dsn.txt file with the following:

[PHP]View PlainCopy

2. <strong><span style="FONT-SIZE:18PX;" ><?php
4. Include_once "base.php";
6. PDO connects to database by URI
8. try{
10. $dsn =' uri:file://d:\wamp\www\muke\pdo\dsn.txt ';
12. $username =' root ';
14. $passwd =";
16. $pdo =new PDO ($dsn,$username,$passwd);
18. Show_bug ($pdo);
20. }catch (pdoexception $e) {
22. echo $e->getmessage ();
24. }
26. ?></span></strong>

3.pdo connect to the database as a configuration file

[PHP]View PlainCopy

2. <strong><span style="FONT-SIZE:18PX;" ><?php
4. Include_once "base.php";
6. PDO connects to a database by configuration file form
8. Configuring in PHP.ini
10. try{
12. $dsn =' Imooc ';
14. $username =' root ';
16. $passwd =";
18. $pdo =new PDO ($dsn,$username,$passwd);
20. Show_bug ($pdo);
22. }catch (pdoexception $e) {
24. echo $e->getmessage ();
26. }
28. ?></span></strong>

Of the above three kinds, we recommend using the first, through the Parameter form link database

Three ways to connect the PDO database