Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - odbc_result() - Retrieve Field Values

By: FYIcenter.com

(Continued from previous topic...)

How To Retrieve Field Values using odbc_result()?

After calling odbc_fetch_row(), the field values of the fetched row are available in the result set object. You can use odbc_result() to retrieve the value of any given field with two syntax formats:

$value = odbc_result($field_name);
#- Retrieving value by field name

$value = odbc_result($field_index);
#- Retrieving value by field index.
#- The index of the first field is 1.

The tutorial PHP script below shows you how to list tables in the database with multiple field values:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  $sql = "SELECT * FROM  sys.objects"
     . " WHERE type_desc='USER_TABLE'";
  $res = odbc_exec($con, $sql);
  print("User Tables:\n");
  while (odbc_fetch_row($res)) {
     print("   ".odbc_result($res,1));
     print(", ".odbc_result($res,'object_id'));
     print(", ".odbc_result($res,7)."\n");
  }
  odbc_free_result($res);

  odbc_close($con); 
?>

If you run this script, you will get something like:

User Tables:
   fyi_rates, 85575343, USER_TABLE
   fyi_team, 165575628, USER_TABLE
   fyi_random, 821577965, USER_TABLE
   fyi_links_indexed, 1061578820, USER_TABLE
   fyi_links, 1093578934, USER_TABLE
   fyi_links_copy, 1253579504, USER_TABLE
   tipBackup2, 2121058592, USER_TABLE

(Continued on next topic...)

1. What Are the Requirements to Use ODBC Connections in PHP Scripts?
2. What Are Commonly Used ODBC Functions in PHP?
3. How To Test ODBC DSN Connection Settings?
4. How To Connect to a SQL Server using odbc_connect()?
5. How To List All DSN Entries on Your Local Machine using odbc_data_source()?
6. How To Execute a SQL Statement using odbc_exec()?
7. How To Retrieve Error Messages using odbc_errormsg()?
8. How To Turn Off Warning Messages during PHP Execution?
9. How To Receive Returning Result from a Query?
10. How To Loop through Result Set Objects using odbc_fetch_row()?
11. How To Retrieve Field Values using odbc_result()?
12. How To List All Tables in the Database using odbc_tables()?
13. How To List All Columns in a Table using odbc_columns()?
14. How To Create Prepared Statements using odbc_prepare()?