Reading Table definitions

[paulg]

Hi guys,

I have a the following table defined:-
CREATE TABLE galleries (
id smallint(4) NOT NULL auto_increment,
date timestamp(8) NOT NULL,
type set('Gallery','News','Help') NOT NULL default 'News',
active set('0','1') NOT NULL default '1',
PRIMARY KEY (id);

Using PHP, how do I read from the table definition the options available for each of the 'set' types.

I want to create a script that can read the table and create a form for it automatically.

Code snippets v-e-r-y welcome😃

Cheers all

[bastien]

see the manual for an example on reading field info here

note that you will need to code some if then type statements to account for certain fields (like an autonumber) that don't really need or that you don't want to display to the user

[color=red]
$result = mysql_query("SELECT * FROM func");
    $fields = mysql_num_fields($result);
    $rows   = mysql_num_rows($result);
    $table = mysql_field_table($result, 0);
    echo "Your '".$table."' table has ".$fields." fields and ".$rows." record(s)\n";
    echo "The table has the following fields:\n";
    for ($i=0; $i < $fields; $i++) {
        $type  = mysql_field_type($result, $i);
        $name  = mysql_field_name($result, $i);
        $len   = mysql_field_len($result, $i);
        $flags = mysql_field_flags($result, $i);
        echo $type." ".$name." ".$len." ".$flags."\n";
    }

[/color]

[paulg]

Thanx Bastien, but this still doesn't give me the SET options, ie Gallery, News etc in my example, does it?

[bastien]

from the mysql manual here

Here's some PHP code to return the possible
options of a set as an array.

<PRE>

/**
* @return array
* @param table DB table
* @param column Column name
* @desc Return an array of the possible values
for a SET
*/
function get_set($table,$column)
{
$sql = "SHOW COLUMNS FROM $table LIKE '$column'";
if (!($ret = mysql_query($sql)))
die("Error: Could not show columns");

$line = mysql_fetch_assoc($ret);
$set = $line['Type'];
$set = substr($set,5,strlen($set)-7); // Remove
"set(" at start and ");" at end
return preg_split("/','/",$set); // Split into
and array
}