odbc_field_type

Datatype of a field (PHP 4, PHP 5)
string odbc_field_type ( resource result_id, int field_number )

Examples ( Source code ) » odbc_field_type


<?php

    //connect to database

    $Link = odbc_connect("mysql-nav", "phpUser", "");


    //switch to freetrade database

    odbc_do($Link, "USE ft3");


    // execute query

    $Query = "SELECT * " .

    $Query .= "FROM MyTable ";

    $Result = odbc_do($Link, $Query);

    print("<table border=\"1\">\n");

    print("<tr>\n");

    print("<th>Number</th>");

    print("<th>Name</th>");

    print("<th>Type</th>");

    print("<th>Length</th>");

    print("<th>Precision</th>");

    print("<th>Scale</th>");

    print("</tr>\n");


    $cols = odbc_num_fields($Result);

    for($c=1; $c <= $cols; $c++)

    {

        print("<tr>\n");

        print("<td>$c</td>");

        print("<td>".odbc_field_name($Result, $c)."</td>");

        print("<td>".odbc_field_type($Result, $c)."</td>");

        print("<td>".odbc_field_len($Result, $c)."</td>");

        print("<td>".odbc_field_precision($Result, $c)."</td>");

        print("<td>".odbc_field_scale($Result, $c)."</td>");

        print("</tr>\n");

    }

    print("</table>\n");


    //close connection

    odbc_close($Link);

?>

Code Examples / Notes » odbc_field_type

not

Some fields can be of the following type too : REAL

jazper

Returntypes on Access2000 COUNTER - Autoincrement VARCHAR - Text LONGCHAR - Memo INTEGER - Number DATETIME - Date/Time CURRENCY - Currency BIT - TRUE/FALSE LONGBINARY - OLE-Object LONGCHAR - Hyperlink cheers, j.a.z.

jorge dot emailnospam

Here is the complete list! Access 2003 as the following teturntypes: COUNTER - Autoincrement VARCHAR - Text LONGCHAR - Memo INTEGER - Number DATETIME - Date/Time CURRENCY - Currency BIT - TRUE/FALSE LONGBINARY - OLE-Object LONGCHAR - Hyperlink DOUBLE - Double Number BYTE - Byte Number

Change Language

odbc_autocommit
odbc_binmode
odbc_close_all
odbc_close
odbc_columnprivileges
odbc_columns
odbc_commit
odbc_connect
odbc_cursor
odbc_data_source
odbc_do
odbc_error
odbc_errormsg
odbc_exec
odbc_execute
odbc_fetch_array
odbc_fetch_into
odbc_fetch_object
odbc_fetch_row
odbc_field_len
odbc_field_name
odbc_field_num
odbc_field_precision
odbc_field_scale
odbc_field_type
odbc_foreignkeys
odbc_free_result
odbc_gettypeinfo
odbc_longreadlen
odbc_next_result
odbc_num_fields
odbc_num_rows
odbc_pconnect
odbc_prepare
odbc_primarykeys
odbc_procedurecolumns
odbc_procedures
odbc_result_all
odbc_result
odbc_rollback
odbc_setoption
odbc_specialcolumns
odbc_statistics
odbc_tableprivileges
odbc_tables

odbc_field_type

Datatype of a field (PHP 4, PHP 5) string odbc_field_type ( resource result_id, int field_number )

Code Examples / Notes » odbc_field_type

Change Language

Datatype of a field (PHP 4, PHP 5)
string odbc_field_type ( resource result_id, int field_number )