php pdo: get the columns name of a table

by

I solve the problem the following way (MySQL only)

$q = $dbh->prepare("DESCRIBE tablename");
$q->execute();
$table_fields = $q->fetchAll(PDO::FETCH_COLUMN);

More Related Contents:

  1. PDO::fetchAll vs. PDO::fetch in a loop
  2. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  3. PDO prepared statement fetch() returning double results
  4. Insert form in MySQL with PDO [duplicate]
  5. Undefined index $_POST
  6. Are PDO prepared statements sufficient to prevent SQL injection?
  7. Reference — frequently asked questions about PDO
  8. Getting raw SQL query string from PDO prepared statements
  9. How do I set ORDER BY params using prepared PDO statement?
  10. “Invalid parameter number: parameter was not defined” Inserting data
  11. Having issue with matching rows in the database using PDO
  12. How can I properly use a PDO object for a parameterized SELECT query
  13. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  14. pdo – Call to a member function prepare() on a non-object [duplicate]
  15. PDO with INSERT INTO through prepared statements [closed]
  16. Are there good tutorials on how to use PDO? [closed]
  17. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  18. Real escape string and PDO [duplicate]
  19. How to check if a row exist in the database using PDO?
  20. PHP PDO vs normal mysql_connect
  21. Can I create a database using PDO in PHP?
  22. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  23. PHP PDO::bindParam() data types.. how does it work?
  24. PHP PDO and MySQLi [duplicate]
  25. PDO fetch one column from table into 1-dimensional array
  26. Using value of a column as index in results using PDO
  27. Getting a PHP PDO connection from a mysql_connect()?
  28. Having issue with matching rows in the database
  29. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  30. PDO and MySQL ‘between’

Leave a Comment