return one value from database with mysql php pdo

by

You can use fetchColumn(): 

$q= $conn->prepare("SELECT name FROM `login_users` WHERE username=?");
$q->execute([$userid]);
$username = $q->fetchColumn();

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. Insert form in MySQL with PDO [duplicate]
  4. PHP – Using PDO with IN clause array
  5. How to properly set up a PDO connection
  6. PHP PDO prepared statements
  7. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  8. “Invalid parameter number: parameter was not defined” Inserting data
  9. PDO binding values for MySQL IN statement [duplicate]
  10. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  11. PDO mysql: How to know if insert was successful
  12. mysql PDO how to bind LIKE
  13. implement LIKE query in PDO
  14. PHP PDO prepared statement — MySQL LIKE query
  15. Fetching single row, single column with PDO
  16. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  17. How to install pdo driver in php docker image?
  18. How do I loop through a MySQL query via PDO in PHP?
  19. MySQL retrieve variable from Stored Procedure in PHP PDO
  20. Understanding pdo mysql transactions
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Use of PDO in classes [duplicate]
  25. How to handle PDO exceptions [duplicate]
  26. Check if row exists in the database before inserting
  27. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  28. PDO and MySQL Fulltext searches
  29. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment