Get field count of a table

[ghost]

I am using this to get my table names DB::select('SHOW TABLES') and after that I would like to get field count for each tables.

The following query is working when I am not using table prefix in database configuration.
But after adding table prefix, the query duplicates the prefix. (dev_dev_branches instead of dev_branches).

$fields = DB::selectOne("SELECT COUNT(*) AS field_count FROM information_schema.COLUMNS C WHERE table_name = '".$table."' AND TABLE_SCHEMA = '".$database."'");
$num_fields = $fields->field_count;

Is there any laravel 4 function to get field count ?

[franzliedke]

No, there isn't.
Where do you get the value of $table from that it is automatically prepended with the prefix?

(This kind of question is probably better suited for the forums.)

[ghost]

Getting this from query ( DB::select('SHOW TABLES') ) foreach, solved by using substr_replace().

But I am requesting to add a laravel DB method to get table field count.

[taylorotwell]

I'm sure you could use the Doctrine schema manager to get this information. Explore that DB::getDoctrineSchemaManager method.

[ghost]

Thanks. Sorry for the issue report, I am a beginner and noticed the API function now only.

[ghost]

Updated my code using the API:

$schema = DB::getDoctrineSchemaManager();
$tables = $schema->listTableNames();
foreach($tables as $table){
$fields = $schema->listTableColumns($table);
}

Fixed enum problem here, #1346