get column list

mmonaco

Is there a PHP equivalent function to SHOW COLUMNS FROM tblName? It would be a little easier to get an array of column names/info without actually running the query.

rincewind456

Yes a multitude of them in the manual such as mysql_list_fields and mysql_list_tables and many more if you look.

mmonaco

I'm sorry, forgot to mention I'm using MySQLi

rincewind456

Yes but you can have both working on the same server.

rincewind456

My apologies I should have read the Manual entry before telling you to look at it, as I see it's deprecated, probably why there is no mysqli function for it.

Any way the recommended way is to use mysql_query() to run the sql statement so for instance to show tables in a database you would use something like this

<?php
$conn = mysql_connect( 'localhost', 'user', 'password' );
if ( ! $conn ) die( "Couldn't connect to MySQL" );

mysql_select_db( 'database' ) or die ( "Couldn't open database: ".mysql_error() );

$sql = mysql_query('SHOW tables');

while($row = mysql_fetch_row($sql)){

foreach ($row as $key=>$value)

print $value."\n<br>";

}
?>