PHP.nl

mysql_list_fields

mysql_list_fields

List MySQL table fields

Waarschuwing: > SHOW COLUMNS FROM sometable

resource **mysql_list_fields** string $database_name string $table_name resource $link_identifier

Retrieves information about the given table name.

This function is deprecated. It is preferable to use to issue an SQL statement instead. mysql_query``SHOW COLUMNS FROM table [LIKE 'name']

database_nameThe name of the database that's being queried.

table_nameThe name of the table that's being queried.

A result pointer on success, or false on failure. resource

The returned result can be used with , , listendand . mysql_field_flags``mysql_field_len``mysql_field_name``mysql_field_type

**Voorbeeld: Alternate to deprecated **

<?php
$result = mysql_query("SHOW COLUMNS FROM sometable");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        print_r($row);
    }
}
?>

Array
(
    [Field] => id
    [Type] => int(7)
    [Null] =>
    [Key] => PRI
    [Default] =>
    [Extra] => auto_increment
)
Array
(
    [Field] => email
    [Type] => varchar(100)
    [Null] =>
    [Key] =>
    [Default] =>
    [Extra] =>
)

Opmerking: > info.deprecated.alias

mysql_listfields

mysql_field_flags``mysql_info

Vorige ← mysql_list_dbs Volgende mysql_list_processes →

Documentatie