How to make a database connection converting mysql to PDO?

Question

Im trying to convert all my mysql code into PDO. First thing Im trying to convert to PDO is my database connection. Can somebody help me on the right way?....

Here comes my database connection in mysql:

  $host = "localhost"; 
$user = "root"; 
$password = "root";
$db = "blog";

$bd = mysql_connect($host, $user, $password) or die("Opps something wrong...");
mysql_select_db($db, $bd) or die("Opps something wrong...");

You cannot short-cut on this, you really do have to read the manual and cut aside some time to test out all the options, especially the parts about prepared statements. You have to bang this stuff into your head. — Cups
– Cups, Commented Mar 26, 2013 at 8:35

Community · Accepted Answer · 2017-05-23 10:25:50Z

2

There is a PDO tag wiki where you can learn the right way (as well as many other useful things) from someone who had a real experience with PDO.

$dsn = "mysql:host=$host;dbname=$db;charset=utf8";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);
$pdo = new PDO($dsn,$username,$password, $opt);

Unlike all other codes which are useless for handling connection errors (as they set exception mode after the actual connect) it will

make PHP throw an exception on connection error
will not reveal sensitive information to a potential attacker on a live server by echoing an error out.
provide you with indispensable stack trace.
set the connection encoding in the right place

Unlike your old code it will not die with useless message but it will either

die with useful error message on-screen
die with useful error message logged, leaving screen blank
die with useful error message logged, with conventional error page shown
not die at all but gracefully handled with designated handler function

... depends on the chosen settings.

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Mar 26, 2013 at 8:38

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Terry Seidler Over a year ago

Why don't you add this as a note to the php.net manual page? ;)

Bruno Chavez Over a year ago

@Your Common Sense Many thanks, your code is working. Now I have to convert all my other code using PDO...

Terry Seidler · Accepted Answer · 2013-03-26 09:19:30Z

2

Have a look at the PHP Manual's PDO page, especially the part on 'Connections and Connection Management': http://www.php.net/manual/en/pdo.connections.php

$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);

or... use Captain Common Sense's approach :)

edited Mar 26, 2013 at 9:19

answered Mar 26, 2013 at 8:26

Terry Seidler

2,04316 silver badges28 bronze badges

Comments

Jhonathan H. · Accepted Answer · 2013-03-26 08:36:54Z

1

Connection with error handling..

try {
    $conn = new PDO('mysql:host=localhost;dbname=myDatabase', $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}

edited Mar 26, 2013 at 8:36

answered Mar 26, 2013 at 8:24

Jhonathan H.

2,7131 gold badge21 silver badges28 bronze badges

4 Comments

Bruno Chavez Over a year ago

Thanks, nice with a error handling to... Im gonna try your code.

Your Common Sense Over a year ago

It has nothing to do with error handling. And it will never raise an error on connect.

Jhonathan H. Over a year ago

May i know how come it would never possible raise an error on connection?

Your Common Sense Over a year ago

@Kaii sure. Just try it and see.

Sumit Bijvani · Accepted Answer · 2013-03-26 08:26:58Z

0

$conn = new PDO('mysql:host=localhost;dbname=myDatabase', $username, $password);

OR

try {
    $conn = new PDO('mysql:host=localhost;dbname=blog', $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}

More details Click here

answered Mar 26, 2013 at 8:26

Sumit Bijvani

8,17518 gold badges52 silver badges83 bronze badges

Comments

Bjoern · Accepted Answer · 2013-03-26 08:27:15Z

0

Have you looked into the manual?

$dbh = new PDO('mysql:host=localhost;dbname=yourdbname', 'youruser', 'yourpassword');

answered Mar 26, 2013 at 8:27

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to make a database connection converting mysql to PDO?

5 Answers 5

2 Comments

Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related