PHP PDO only fetch 1 row

Question

I want to fetch all the rows of a table but it only echos 1 row. (The latest) Tried much but nothing worked for me. Tried answers on stackoverflow but it is not working.

Here is the code that i use to fetch the rows:

$stmt = $pdo->prepare("SELECT * FROM admin");
$stmt->execute();
$result = $stmt->fetchAll();

foreach ($result as $row) {
    $gebruikersnaam = $row['gebruikersnaam'];
    $wachtwoord = $row['wachtwoord'];
}

Hope that anyone can help me with this.

every iteration, it gets overwritten, at the end, your left with the last result row — Kevin
– Kevin, Commented Apr 2, 2015 at 14:39

Hanky Panky · Accepted Answer · 2015-04-02 14:41:02Z

1

I want to fetch all the rows of a table but it only echos 1 row. (The latest)

foreach ($result as $row) {
    $gebruikersnaam = $row['gebruikersnaam'];
    $wachtwoord = $row['wachtwoord'];
}

I can bet 5 dollars on the assumption that you are using those variables outside the loop :) That's why you only see the last row's data. Either remove fetchAll() and fetch() them one by one or manipulate your variables within the loop so you get new values for every row.

Try this and you will know what i mean

foreach ($result as $row) {
   print_r($row);
}

edited Apr 2, 2015 at 14:41

answered Apr 2, 2015 at 14:36

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

3 Comments

Jordy Over a year ago

Betting closed guys haha!, Yes i use it outside the loop. it fetches everything but.. in an if-statement i want to check if the value is equal to the value in the database. When i try that, i can only see that the last inserted value is equal.

N.B. Over a year ago

How about you pass the value to the database (the one you want to check) and then you don't have perform comparison in PHP, you just ask your database whether something exists or not?

Hanky Panky Over a year ago

Why not check the value inside the loop? Even better why not act on N.B's advise?

Puya Sarmidani · Accepted Answer · 2015-04-02 15:15:52Z

$stmt = $pdo->prepare("SELECT * FROM admin");
$stmt->execute();
$result = $stmt->fetchAll();
$count = $stmt->rowCount();

for ($i=0; $i < $count; $i++) {
$gebruikersnaam = $result[$i]['gebruikersnaam'];
$wachtwoord = $result[$i]['wachtwoord'];

echo 'Gebruikersnaam is : '.$gebruikersnaam.'<br/>';
echo 'Wachtwoord is : '.$wachtwoord.'<br/>';
}

Or if you want to use foreach:

$stmt = $pdo->prepare("SELECT * FROM admin");
$stmt->execute();
$result = $stmt->fetchAll();

foreach ($result as $row) {
$gebruikersnaam .= $row['gebruikersnaam'];
$wachtwoord .= $row['wachtwoord'];
}

echo 'Gebruikersnamen zijn : '.$gebruikersnaam.'<br/>';
echo 'Wachtwoorden zijn : '.$wachtwoord.'<br/>';

you have to style it al little bit because it'll stick them all together.

Collectives™ on Stack Overflow

PHP PDO only fetch 1 row

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related