使用php循环使用MSSQL表的每个列名

Question

If I have [x] [y] [z] columns inside a [mytable] table in MSSQL, I would like to know how can I loop through each of them using php in order to have all of the columns' name? The reason is because I could potentially delete or add a column so that php code would make this dynamic without having to hardcode the php page. Basically, if I could have a php code similar to the following,

foreach( COLUMN as $columname in [SQL table]) 
    echo "$columname";
    // do something else
}

it would be awesome.

Answer 1

Select the data from the INFORMATION_SCHEMA.COLUMNS system view. Filtered on your table name.

select column_name 
from information_schema.columns
where table_name = 'mytable'

Returns

Column_name
-----------
x
y
z

This gives you a resultset containing all column names, loop through and use the values.