retrieving data form phpMyAdmin database doesn't work [closed]

Question

I want to retrieve data from my database 'phpopdracht5' with table 'users' and attributes 'name' (VARCHAR(20)) and 'id' (INTEGER), but it's just not working. There must be something wrong with my code

<?php
define("DB_HOST", "localhost");
define("DB_USERNAME", "root");
define("DB_PASSWORD", "");
define("DB_NAME", "phpopdracht5");

try
{
    $db_conn = new  PDO('mysql:host='.DB_HOST.';dbname'.DB_NAME,DB_USERNAME,DB_PASSWORD);
}
catch(PDOException $e)
{
print "Error!:".$e->getMessage()."\n";
die();
}

$sth = $db_conn->prepare('SELECT * FROM users'); 
$sth->bindParam(':name', $name, PDO::PARAM_STR, 20);
$sth->bindParam(':id', $id, PDO::PARAM_INT);
$sth->execute();

while ($row = $sth->fetch(PDO::FETCH_BOTH)) {
echo $row[0];
}
?>

You're adding paramters to your prepared statement; but there are no placeholders to bind them to. try SELECT * FROM users WHERE name=? AND id=? — andrewsi
– andrewsi, Commented May 7, 2013 at 12:35
FYI the database isn't phpmyadmin, it is a mysql database, phpmyadmin is just a tool to see the data in the mysql database. — Pitchinnate
– Pitchinnate, Commented May 7, 2013 at 12:38

Community · Accepted Answer · 2017-05-23 11:57:19Z

1

It looks like you are missing an equals sign or two:

This is your pdo command: $db_conn = new PDO('mysql:host='.DB_HOST.';dbname'.DB_NAME,DB_USERNAME,DB_PASSWORD);

this is a different user's one: $db_conn = new PDO('mysql:host=localhost;dbname=testdatabase','test', 'testpass'); Link: DEBUG PDO Connection & PHP Output

So it looks like "dbname=" is missing

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered May 7, 2013 at 12:39

greendave11

1681 silver badge13 bronze badges

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

3 Comments

breght Over a year ago

wow thx, that was a really stupid fault. My bad :/

greendave11 Over a year ago

Its cool it happens to the best of us. Happy Coding!!

Your Common Sense Over a year ago

To make such things impossible to happen, one have to have error reporting on

antoox · Accepted Answer · 2013-05-07 12:36:32Z

1

You bind params which didn't exist on your query. Your query must be:

SELECT * FROM users WHERE name = :name AND id = :id

Otherwise if you want all your users:

$sth = $db_conn->prepare('SELECT id, name FROM users'); 
$sth->execute();

while ($row = $sth->fetch(PDO::FETCH_BOTH)) {
echo $row['id'] . ':' . $row['name'];
}

answered May 7, 2013 at 12:36

antoox

1,31911 silver badges9 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:49:16Z

1

you don't need to bind parameters to get them. just

$sth = $db_conn->prepare('SELECT * FROM users'); 
$sth->execute();

Also, you have to set up PHP and PDO error reporting as explained here: PDO query fails but I can't see any errors. How to get an error message from PDO?

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered May 7, 2013 at 12:37

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

retrieving data form phpMyAdmin database doesn't work [closed]

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related