PHP get MySQL Columns

Question

I need to build a PHP class which allows me to retrieve the names of all columns of a certain MySQL Database.

Suppose I had the following strucutre:

| ID | Name | Surname | Age | Sex |

My script should provide an array as:

0 => ID
1 => Name
2 => Surname
3 => Age
4 => Sex

Ideas? :)

Caner · Accepted Answer · 2011-07-28 09:20:27Z

4

$result = mysql_query("SHOW COLUMNS FROM sometable");
print_r($result);

edited Jul 28, 2011 at 9:20

answered Jul 28, 2011 at 9:04

Caner

59.7k37 gold badges184 silver badges185 bronze badges

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

Comments

Luchian Grigore · Accepted Answer · 2011-07-28 09:05:06Z

3

Use

DESCRIBE TableName

or

SHOW COLUMNS FROM TableName

answered Jul 28, 2011 at 9:05

Luchian Grigore

260k68 gold badges465 silver badges634 bronze badges

Comments

VolkerK · Accepted Answer · 2011-07-28 09:08:37Z

1

You can use the INFORMATION_SCHEMA COLUMNS table, e.g. (using PDO) :

$stmt = $pdo->prepare('
    SELECT
        COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
    FROM
        INFORMATION_SCHEMA.COLUMNS
    WHERE
        table_name=:tablename
        AND table_schema=:databasename
');
$stmt->execute( array(':tablename'=>'foo', ':databasename'=>'bar') );

answered Jul 28, 2011 at 9:08

VolkerK

96.3k20 gold badges169 silver badges232 bronze badges

Collectives™ on Stack Overflow

PHP get MySQL Columns

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related