php - mysqli: how to get the type of a column in a table -

sorry that, but: how can type of column in table, e.g. datetime, int(32) or varchar(40)? have got result, fetched object, vardump prints

object(stdclass)[8]   public 'id' => string '3' (length=1)   public 'email' => string 'me@foo.bar' (length=6) 

id should integer , email varchar(i) working php5 , mysqli

thx help!

to information, need query information_schema.columns table. mysql data type:

select data_type information_schema.columns table_name = 'my_table' , column_name = 'my_column'