PHP : Function Reference : ODBC Functions (Unified) : odbc_field_precision PHP Examples Tutorials References

Examples ( Source code ) » odbc_field_precision


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

?>

odbc_field_precision

Synonym for odbc_field_len (PHP 4, PHP 5)
int odbc_field_precision ( resource result_id, int field_number )

Change Language

odbc_field_precision

Synonym for odbc_field_len (PHP 4, PHP 5) int odbc_field_precision ( resource result_id, int field_number )

Change Language

Synonym for odbc_field_len (PHP 4, PHP 5)
int odbc_field_precision ( resource result_id, int field_number )