PHP PDO rowCount not working? I think

Question

So I am grabbing the amount of rows in a specific table where the username is already in the database like so:

$second_sql = $db->prepare("SELECT * FROM users WHERE username = :username");    
$second_sql->bindParam(':username', $username);    
$second_sql->execute();

if($second_sql->rowCount() == 1) {
  $db = null;
  header("Location: ../login/");
} else {
  $statement->execute();
  $db = null;
}

The problem is it's not working. If you need more of the script just tell me.

you are not fetching anything. you are missing the $result = $second_sql->fetchAll(); — happymacarts, Aug 23 '16 at 16:50
Add `echo $second_sql->rowCount(); exit;` right after the `$second_sql->execute();`. It could be enlightening. — Don't Panic, Aug 23 '16 at 16:53
Possible duplicate of [Row count with PDO](http://stackoverflow.com/questions/883365/row-count-with-pdo) — War10ck, Aug 24 '16 at 01:33
why not just fetch the data and see if you got a row? i.e. `$user = $second_sql->fetchAll();` `if (!empty($user)) { // process returned data... ` imo, Never use rowCount() with select queries. Just process the data. — Ryan Vincent, Aug 24 '16 at 01:55

Chris Pesoa · Answer 1 · 2016-08-24T01:29:35.420

Some databases does not report the row count with PDO->rowCount() method.

SQLite, for instance.

So don't use rowCount(); doing so makes your code less portable.

Instead use the COUNT(*) function in your query, and store the result in a variable.

Finally, use that variable to fetch the one and only column (users) using the fetchColumn() method.

So you can play with this:

try {
    $second_sql = $db->prepare("SELECT COUNT(*) from users WHERE username = :username");
    $second_sql->bindParam(':username', $username, PDO::PARAM_STR);
    $second_sql->execute();
    $count = $second_sql->fetchColumn();
} catch (PDOException $e) {
    // Here you can log your error
    // or send an email
    // Never echo this exception on production
    // Only on development fase
    echo "Error: " . $e->getMessage();
}

if ($count) {
    $db = null;
    header("Location: ../login/");
} else {
    $statement->execute();
    $db = null;
}

Perhaps you wanna test you condition for a single row:

if ($count == 1)

Hope this helps you.

Cheers!

PHP PDO rowCount not working? I think

1 Answers1