PHPActiveRecord Find Column Names & Types & In Particular ENUM Components

Question

Is there a way to get all the column names, and then figure out what type the column is? For example, ENUM, VARCHAR, TINYINT, etc..., in particular for ENUM the different components of the ENUM?

I found something here (http://www.phpactiverecord.org/docs/ActiveRecord/Column)

Not sure how to get the type though from this documentation?

The answer by byte255 is very close, I only need to figure out the ENUM values now instead of it just returning type ENUM. — Joseph Astrahan
– Joseph Astrahan, Commented Sep 21, 2014 at 19:45

anon · Accepted Answer · 2014-09-21 05:56:46Z

1

To list column names and their types:

$columns = MyModel::table()->columns;
foreach ($columns as $column) {
    echo "{$column->name} - {$column->raw_type} <br>\n";
}

Where MyModel is the name of your model class.

This will output "raw" database type as defined in the DB schema. You can also use $column->type for normalized type in ActiveRecord internal representation.

See AR source here and here.

answered Sep 21, 2014 at 5:56

anon

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

3 Comments

Joseph Astrahan Over a year ago

Thanks for your answer! This worked great and helps a lot so far. I did get that the value was ENUM... but I unfortunately did not get the values that make up the ENUM. Lets say the ENUM was made up of values such as 'Yes', 'No', 'Maybe', I need to figure out what those are.

Joseph Astrahan Over a year ago

As opposed to the current answer which just returns ENUM. None the less this is a great start for me to explore into.* - forgot to add this into last comment.

anon Over a year ago

@JosephAstrahan Unfortunately PHP ActiveRecord doesn't parse ENUM values, see the source. So there is no list of values readily available. However, you can issue SHOW COLUMNS statement and parse the ENUM values yourself, see this answer.

Collectives™ on Stack Overflow

PHPActiveRecord Find Column Names & Types & In Particular ENUM Components

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related