PHP : Function Reference : Microsoft SQL Server Functions : mssql_field

Examples ( Source code ) » mssql_field_name


<?php

// Send a select query to MSSQL

$query = mssql_query('SELECT [username], [name], [email] FROM [php].[dbo].[userlist]');


echo 'Result set contains the following field(s):', PHP_EOL;


// Dump all field names in result

for($i = 0; $i < mssql_num_fields($query); ++$i)

{

    echo ' - ' . mssql_field_name($query, $i), PHP_EOL;

}


// Free the query result

mssql_free_result($query);

?>



The above example will output something similar to:


Result set contains the following field(s):

 - username

 - name

 - email

A simple script to walk through an MSSQL server. I'm using PHP 4.06 and Freetds 5.1 on Solaris 2.7 and Apache 1.3 Several of the msql_ functions seem to be broken/missing. This is what I found to work. <?php // -------------------------------------------------------- // URL http://server/mssqltest.php?DB=Database&table=TableName // -------------------------------------------------------- // Default settings: edit to meet your needs if (!($user)) $user=sa; if (!($pass)) $pass="password"; if (!($host)) $host="acer900"; // -------------------------------------------------- // connect to mssql server $connect = mssql_connect($host,$user,$pass) or die ($host." not accessible."); // select the database if ($DB) mssql_select_db($DB)or die('USE '.$DB.' failed!'); if (!($table)) { $query="EXEC sp_tables \"%\",\"%\",\"".$DB."\",\"'TABLE'\""; $linkcol=2; $linkcol="TABLE_NAME"; $linkformat=" <a href=\"%s?DB=".$DB."&table=%s\">%s</a> "; }else{ // tables and DB - Get DATA $query="SELECT * FROM ".$table; $linkformat=" <a href=\"%s\">%s</a> "; } if (!($DB)) { $query="EXEC sp_databases"; $linkcol=0; $linkcol="DATABASE_NAME"; $linkformat="<a href=\"%s?DB=%s\">%s</a>"; } // run query echo $query." "; $result = mssql_query( $query) or die('Query failed!'); $fields = mssql_num_fields ($result) or die("Num Fields Failed"); $rows = mssql_num_rows ($result); echo " Rows ".$rows." Fields ".$fields." "; echo "<TABLE border=1><tr>"; // get field names for ( $f = 0 ; $f < $fields ; $f++ ){ $name = mssql_fetch_field($result, $f); echo "<td>".$f.$name->name."</td>"; // Strange here.. without the "X"'s the () is always TRUE?? if ($name->name."X" == $linkcol."X") $linkcol = $f; } echo "</tr>"; //Display Data for ($i = 0; $i < $rows ; $i =$i +1){ for ($f = 0; $f<$fields ; $f++){ $name=mssql_result($result,$i,$f); if ($f == $linkcol){ printf("<td>".$linkformat."</td>\n",$PHP_SELF, $name , $name ); } else{ echo "<td>". $name . "</td>"; } } echo "</tr>"; } echo "</TABLE> "; // close connection mssql_close ($connect); ?>

mssql_field_name

Get the name of a field (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
string mssql_field_name ( resource result [, int offset] )

Code Examples / Notes » mssql_field_name

Change Language

mssql_field_name

Get the name of a field (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4) string mssql_field_name ( resource result [, int offset] )

Code Examples / Notes » mssql_field_name

Change Language

Get the name of a field (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
string mssql_field_name ( resource result [, int offset] )