Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]

Question

I converted the following working code:

<?php
    include('config.php');
    $link = mysql_connect($db_host, $username, $password);
    mysql_select_db($db_name);

    $id= $_POST["uniqi"];
    $comments= $_POST["comments"];
    $comments= mysql_real_escape_string($comments);
    $comments = strip_tags($comments);

    $update = "UPDATE mastertable SET comments = '$comments' WHERE id_pk= '$id'";
    mysql_query($update, $link);
    mysql_close();
    header('Location: ccccc.com/pabrowser/… Updated');
?>

to PDO:

<?php
    $id= $_POST["uniqi"];
    $comments= $_POST["comments"];
    $conn = new PDO("mysql:host=$db_host;dbname=$db_name", $username, $password);

    $sql = "UPDATE mastertable SET comments=?    WHERE id_pk=?";
    $q = $conn->prepare($sql);
    $q->execute(array($comments, $id));

    header('Location: ccccc.com/pabrowser/… Updated');
?>

Which gave me

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' in /home/content/58/9508458/html/pabrowser/comsumcompro.php:4 Stack trace: #0 /home/content/58/9508458/html/pabrowser/comsumcompro.php(4): PDO->__construct('mysql:host=;dbn...', NULL, NULL) #1 {main} thrown in /home/content/58/9508458/html/pabrowser/comsumcompro.php on line 4

have you included config.php in the PDO part?

Gntem
– Gntem

2012-07-08 16:39:09 +00:00
Commented Jul 8, 2012 at 16:39 — Gntem
– Gntem, Commented Jul 8, 2012 at 16:39

ts. · Accepted Answer · 2012-07-08 16:39:58Z

4

You've forgotten include('config.php');

answered Jul 8, 2012 at 16:39

ts.

10.7k8 gold badges49 silver badges79 bronze badges

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

Comments

CodeCaster · Accepted Answer · 2012-07-08 16:38:17Z

3

Your $db_host or $db_name value are wrong or you are supplying invalid credentials.

answered Jul 8, 2012 at 16:38

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

Comments

j0k · Accepted Answer · 2012-07-09 14:41:18Z

1

Please add

include('config.php');

edited Jul 9, 2012 at 14:41

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Jul 8, 2012 at 16:46

Tina

3123 gold badges6 silver badges16 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2016-02-09 13:06:54Z

0

Your connection string is wrong or the MySQL server is not responding. Use a try ... catch construction, like this:

include('config.php');

$id = $_POST["uniqi"];
$comments = $_POST["comments"];
try {
    $conn = new PDO("mysql:host=$db_host;dbname=$db_name", $username, $password);
}
catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

And if you will see "Connection failed" message, you understand what's wrong.

edited Feb 9, 2016 at 13:06

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jul 8, 2012 at 17:05

Andrey Vorobyev

8961 gold badge10 silver badges37 bronze badges

1 Comment

Duniyadnd Over a year ago

Shouldn't the try statement be used with curly brackets?

Collectives™ on Stack Overflow

Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related