PDO Fetch statement only retrieves first column

by

You can only select the id column because that is all you have in the query.

Try something like this

if (isset($_SESSION['id'])) {
    $presh = $_SESSION['id'];
    $stmt = $pdo->prepare("SELECT id, karmacurrent FROM users WHERE id = :id");

    $id = $presh;

    $stmt->execute(
        array(
            ':id'=>$id
        )
    );

    $accountinfo = $stmt->fetch(PDO::FETCH_ASSOC);
}

Basically you were only retrieving the ID from the table instead of the other columns.

More Related Contents:

  1. PHP / PDO echo data from database into a table
  2. PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
  3. How to prevent duplicate usernames when people register?
  4. Error when preparing a multiple insert query
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. pdo prepared statements with wildcards
  7. Insert multiple rows with PDO prepared statements
  8. Do SQL connections opened with PDO in PHP have to be closed
  9. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  10. php code to test pdo is available?
  11. PDO fetchAll group key-value pairs into assoc array
  12. What is the advantage of using try {} catch {} versus if {} else {}
  13. Alternative for mysql_num_rows using PDO
  14. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  15. Unknown database error in PHP but it exists in PHPMyAdmin
  16. How do detect that transaction has already been started?
  17. Binding parameters for WHERE IN clause with PDO [duplicate]
  18. return one value from database with mysql php pdo
  19. Trying to access array offset on value of type bool
  20. return multiple response data in one response
  21. How to get a query error from prepare() in PDO PHP?
  22. How can I pass an array of PDO parameters yet still specify their types?
  23. PHP PDO how to run a multiple query request?
  24. How to escape single-quote (apostrophe) in string using php
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. php, mysql – Too many connections to database error
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment