PHP: mysql_field_type - Manual in Deutsh
PHP: mysql_field_type - Manual in French
PHP: mysql_field_type - Manual in Polish

You Are At PHP: mysql_field_type - Manual Area


recent searches:
include functions , variable functions , post functions...




If you are new to PHP or just need to refresh your skills, this is the place to start. This series of tutorials will give you the basic knowledge you will need to create a simple PHP website.

PHP is a reflective programming language originally designed for producing dynamic web pages.[1] PHP is used mainly in server-side scripting, but can be used from a command line interface or in standalone graphical applications. Textual User Interfaces can also be created using ncurses.

PHP Manual
PrevNext

mysql_field_type

(PHP 3, PHP 4, PHP 5)

mysql_field_type -- Get the type of the specified field in a result

Description

string mysql_field_type ( resource result, int field_offset )

mysql_field_type() is similar to the mysql_field_name() function. The arguments are identical, but the field type is returned instead.

Parameters

result

The result resource that is being evaluated. This result comes from a call to mysql_query().

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.

Return Values

The returned field type will be one of "int", "real", "string", "blob", and others as detailed in the MySQL documentation.

Examples

Example 1. mysql_field_type() example

<?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();
?>

The above example will output something similar to:

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

Notes

Note: For downward compatibility, the following deprecated alias may be used: mysql_fieldtype()

See Also

mysql_field_name()
mysql_field_len()

PrevHomeNext
mysql_field_tableUpmysql_free_result

oprogramowanie magazynowe
Najtańszy fotograf lublin na ślub
kody kreskowe paskowe RFID Czytniki mobilne drukarki etykiet termina
Pozycjonowanie stron
Dostawca kas fiskalnych w Białymstoku

Another Useful functions:


ref.pdo-mysql | ref.pdo-mysql.connection | ref.mysqli | ref.mysql | function.mysqli-warning-count | function.mysqli-use-result | function.mysqli-thread-safe | function.mysqli-thread-id | function.mysqli-store-result | function.mysqli-stmt-store-result | function.mysqli-stmt-sqlstate | function.mysqli-stmt-send-long-data | function.mysqli-stmt-result-metadata | function.mysqli-stmt-reset | function.mysqli-stmt-prepare | function.mysqli-stmt-param-count | function.mysqli-stmt-num-rows | function.mysqli-stmt-insert-id | function.mysqli-stmt-init | function.mysqli-stmt-get-warnings | function.mysqli-stmt-free-result | function.mysqli-stmt-field-count | function.mysqli-stmt-fetch | function.mysqli-stmt-execute | function.mysqli-stmt-error | function.mysqli-stmt-errno | function.mysqli-stmt-data-seek | function.mysqli-stmt-close | function.mysqli-stmt-bind-result | function.mysqli-stmt-bind-param | function.mysqli-stmt-attr-set | function.mysqli-stmt-attr-get | function.mysqli-stmt-affected-rows | function.mysqli-stat | function.mysqli-ssl-set | function.mysqli-sqlstate | function.mysqli-slave-query | function.mysqli-set-opt | function.mysqli-set-local-infile-handler | function.mysqli-set-local-infile-default | function.mysqli-set-charset | function.mysqli-server-init | function.mysqli-server-end | function.mysqli-send-query | function.mysqli-send-long-data | function.mysqli-select-db | function.mysqli-rpl-query-type | function.mysqli-rpl-probe | function.mysqli-rpl-parse-enabled | function.mysqli-rollback | function.mysqli-report | function.mysqli-real-query | function.mysqli-real-escape-string | function.mysqli-real-connect | function.mysqli-query | function.mysqli-prepare | function.mysqli-ping | function.mysqli-param-count | function.mysqli-options | function.mysqli-num-rows | function.mysqli-num-fields | function.mysqli-next-result | function.mysqli-multi-query | function.mysqli-more-results | function.mysqli-master-query | function.mysqli-kill | function.mysqli-insert-id | function.mysqli-init | function.mysqli-info | function.mysqli-get-warnings | function.mysqli-get-server-version | function.mysqli-get-server-info | function.mysqli-get-proto-info | function.mysqli-get-metadata | function.mysqli-get-host-info | function.mysqli-get-client-version | function.mysqli-get-client-info | function.mysqli-get-charset | function.mysqli-free-result | function.mysqli-field-tell | function.mysqli-field-seek | function.mysqli-field-count | function.mysqli-fetch | function.mysqli-fetch-row | function.mysqli-fetch-object | function.mysqli-fetch-lengths | function.mysqli-fetch-fields | function.mysqli-fetch-field | function.mysqli-fetch-field-direct | function.mysqli-fetch-assoc | function.mysqli-fetch-array | function.mysqli-execute | function.mysqli-escape-string | function.mysqli-error | function.mysqli-errno | function.mysqli-enable-rpl-parse | function.mysqli-enable-reads-from-master | function.mysqli-embedded-server-start | function.mysqli-embedded-server-end | function.mysqli-dump-debug-info | function.mysqli-disable-rpl-parse | function.mysqli-disable-reads-from-master | function.mysqli-debug | function.mysqli-data-seek | function.mysqli-connect | function.mysqli-connect-error | function.mysqli-connect-errno | function.mysqli-commit | function.mysqli-close | function.mysqli-client-encoding | function.mysqli-character-set-name | function.mysqli-change-user | function.mysqli-bind-result | function.mysqli-bind-param | function.mysqli-autocommit | function.mysqli-affected-rows | function.mysql-unbuffered-query | function.mysql-thread-id | function.mysql-tablename | function.mysql-stat | function.mysql-select-db | function.mysql-result | function.mysql-real-escape-string | function.mysql-query | function.mysql-ping | function.mysql-pconnect | function.mysql-num-rows | function.mysql-num-fields | function.mysql-list-tables | function.mysql-list-processes | function.mysql-list-fields | function.mysql-list-dbs | function.mysql-insert-id | function.mysql-info | function.mysql-get-server-info | function.mysql-get-proto-info | function.mysql-get-host-info | function.mysql-get-client-info | function.mysql-free-result | function.mysql-field-type | function.mysql-field-table | function.mysql-field-seek | function.mysql-field-name | function.mysql-field-len | function.mysql-field-flags | function.mysql-fetch-row | function.mysql-fetch-object | function.mysql-fetch-lengths | function.mysql-fetch-field | function.mysql-fetch-assoc | function.mysql-fetch-array | function.mysql-escape-string | function.mysql-error | function.mysql-errno | function.mysql-drop-db | function.mysql-db-query | function.mysql-db-name | function.mysql-data-seek | function.mysql-create-db | function.mysql-connect | function.mysql-close | function.mysql-client-encoding | function.mysql-change-user | function.mysql-affected-rows |


PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. If you are new to PHP and want to get some idea of how it works, try the introductory tutorial. After that, check out the online manual, and the example archive sites and some of the other resources available in the links section.