mysql_field_type

(PHP 4, PHP 5, PECL mysql:1.0)

mysql_field_type — 결과로부터 특정 필드의 데이터 형(type) 정보를 반환

설명

string mysql_field_type ( resource $result , int $field_offset )

mysql_field_type()는 mysql_field_name()와 사용자에게 돌려주는 값의 형태가 비슷하다.

매개변수

result: mysql_query() 호출을 통한 결과 resource.
field_offset: The numerical field offset. The field_offset starts at 0. If field_offset does not exist, an error of level E_WARNING is also issued.

반환값

반환되는 필드 형태는 "int", "real", "string", "blob", 그리고 » MySQL 문서에 설명되어 있는 데이터형 중 하나이다.

예제

Example#1 mysql_field_type() 예제


<?php
mysql_connect("localhost", "mysql_username", "mysql_password");
mysql_select_db("mysql");
$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";
}
mysql_free_result($result);
mysql_close();
?>

위 예제의 출력 예:

Your 'func' table has 4 fields and 1 record(s)
The table has the following fields:
string name 64 not_null primary_key binary
int ret 1 not_null
string dl 128 not_null
string type 9 not_null enum

주의

Note: 하위 호환을 위하여, 다음의 권장하지 않는 alias를 사용할 수 있습니다: mysql_fieldtype()

mysql_free_result

mysql_field_table

Last updated: Sun, 25 Nov 2007

add a note User Contributed Notes
mysql_field_type

fred at dinkler dot com
08-Feb-2007 11:52


In MySQL 4.1.x, the four TEXT types (TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT) return 'blob" as field types, not "string".

c dot futterlieb at bluewin dot ch
10-Dec-2006 06:06


Additional to the note below:

If you're using the "SHOW FIELDS" syntax, be sure that you're adding the table name instead of the db name in the "FROM" parameter:



<?php

$result = mysql_query("SHOW FIELDS FROM table");

?>



Also possible:



<?php

$result = mysql_query("SHOW FIELDS FROM table.db");

?>



or this:



<?php

$result = mysql_query("DESCRIBE table");

?>

http://dev.mysql.com/doc/refman/5.1/en/describe.html

fusionstream at gmail dot com
17-Sep-2006 09:19


krang at krang dot org dot uk

Condensed version of what KRANG said.



To get info on the MYSQL field type, use this code



<?

$result = mysql_query("SHOW FIELDS FROM db_name");



$i = 1;

while ($row = mysql_fetch_array($result)) { //go through one field at a time

  echo "Field $i: ";

  print_r($row) //display all information about A field which can be accessed thru the "$row" array.

  $i++;

}

?>



Will display something like:

Field 1: Array ( [Field] => SN [Type] => mediumint(8) unsigned [Null] => [Key] => PRI [Default] => [Extra] => auto_increment ) , SN, mediumint(8) unsigned

Field 2: Array ( [Field] => ENTITY_ID [Type] => varchar(20) [Null] => [Key] => [Default] => [Extra] => ) , ENTITY_ID, varchar(20)

18-Feb-2006 11:52


This function is broken in 4.4.1 (works fine in 4.3.X).

http://bugs.php.net/35536

harald at weinreichs dot de
06-Jun-2005 10:02


The note blow seems incomplete/incorrect. For php 4.3 and mysql 4.x the returned values are:



CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET: string

TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER, BIGINT: int

FLOAT, DOUBLE, DECIMAL, NUMERIC: real

TIMESTAMP: timestamp

YEAR: year

DATE: date

TIME: time

DATETIME: datetime

TINYBLOB, MEDIUMBLOB, LONGBLOB, BLOB: blob



if mysql-field-type seems to return the wrong values, you may encounter an compatibility problem of mysql, php and the libraries you use. Try reinstalling php and mysql.

mariob at menta dot net
07-Nov-2003 12:21


For version 4.3.4, types returned are:



STRING, VAR_STRING: string

TINY, SHORT, LONG, LONGLONG, INT24: int

FLOAT, DOUBLE, DECIMAL: real

TIMESTAMP: timestamp

YEAR: year

DATE: date

TIME: time

DATETIME: datetime

TINY_BLOB, MEDIUM_BLOB, LONG_BLOB, BLOB: blob

NULL: null

Any other: unknown

swalif_mesa at hotmail dot com
09-Jul-2003 10:38


Hmm for the previous comment, note that SHOW FIELDS is an alias of SHOW COLUMNS. Very useful if you need to search the mysql-documentation. Here is the link anyway...

http://www.mysql.com/doc/en/SHOW_DATABASE_INFO.html

krang at krang dot org dot uk
10-Mar-2002 06:13


The field type returns what PHP classifies the data found in the field, not how it is stored in the database; use the following example to retrieve the MySQL information about the field....



$USERNAME = '';

$PASSWORD = '';



$DATABASE = '';

$TABLE_NAME = '';



mysql_connect('localhost', $USERNAME, $PASSWORD)

    or die ("Could not connect");



$result = mysql_query("SHOW FIELDS FROM $DATABASE.$TABLE_NAME");



$i = 0;



while ($row = mysql_fetch_array($result)) {

  echo $row['Field'] . ' ' . $row['Type'];

}

add a note

mysql_free_result

mysql_field_table

Last updated: Sun, 25 Nov 2007