PHP Data Objects Fetching A Fields Name From A Table

Question

How would I fetch the name of all the fields in a table of a database using PHP Data Objects?

Julien · Accepted Answer · 2011-11-25 21:11:28Z

3

to do this you have to query the db schema. In MySQL, there is a system generated database called information_schema.

from within it, you could run:

SELECT column_name
FROM COLUMNS
WHERE table_name = 'desired_table'
AND table_schema = 'database_name'

answered Nov 25, 2011 at 20:40

Julien

3103 gold badges20 silver badges56 bronze badges

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

2 Comments

I also have a lot of databases with tables that have a certain tablename e.g. browers.. and it returns all of that data..

SELECT column_name FROM COLUMNS WHERE table_name = 'desired_table' AND table_schema = 'database_name'