php pdo statement error

Question

I'm a newbie to php pdo. Here i'm trying to fetch my database records from database using prepared statements. But it didn't fetch the records. I'm getting this following error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

why i'm getting this error? why it didn't fetch the records from database?

<?php
$user = "root";
$password = "password";

    try {
        $conn = new PDO('mysql:host=localhost;database=evouchers', $user, $password);
        $conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    } catch(PDOException $e){
        echo 'DATABASE ERROR : ' . $e->getMessage();
    }

    $sql = "SELECT UserName FROM ebusers ORDER BY UserName";
    $db = $conn->query($sql);
    $db->setFetchMode(PDO::FETCH_ASSOC);

    while($row = $db->fetch())
    {
        print_r($row);
    }
?>

M I · Accepted Answer · 2014-01-08 04:59:12Z

4

in your db connection string instead of database use dbname

  $conn = new PDO('mysql:host=localhost;database=evouchers', $user, $password);
  ---------------------------------------^



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

Docs link: http://php.net/manual/en/pdo.connections.php

answered Jan 8, 2014 at 4:59

M I

3,6822 gold badges27 silver badges38 bronze badges

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

5 Comments

Karuppiah RK Over a year ago

Thanks.. its working.. why we should use dbname in that place?

Robbert Over a year ago

Every database system is a little different. Mysql just happens to use dbname.

M I Over a year ago

it is requirement for PDO to use dbname for specifying databasename, you can see in the doc link.

Karuppiah RK Over a year ago

now i'm getting the result like this Array ( [UserName] => Administrator ) Array ( [UserName] => Mr.Dependable ). if i want to fetch the Administrator, Mr.Dependable value means what should i do?

M I Over a year ago

do it like echo $row['UserName']; you will get the value. let me know if any issue.

Arek S · Accepted Answer · 2014-01-08 04:59:52Z

2

I think it should be

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

Alternatively try just after you init PDO

$conn->exec('USE evouchers;');

answered Jan 8, 2014 at 4:59

Arek S

4,7794 gold badges27 silver badges35 bronze badges

Comments

sanjeev · Accepted Answer · 2014-01-08 05:01:42Z

2

use the following line for pdo connection

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

answered Jan 8, 2014 at 5:01

sanjeev

4,6512 gold badges22 silver badges28 bronze badges

Collectives™ on Stack Overflow

php pdo statement error

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related