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...)
- What Are the Requirements to Use ODBC Connections in PHP Scripts?
- What Are Commonly Used ODBC Functions in PHP?
- How To Test ODBC DSN Connection Settings?
- How To Connect to a SQL Server using odbc_connect()?
- How To List All DSN Entries on Your Local Machine using odbc_data_source()?
- How To Execute a SQL Statement using odbc_exec()?
- How To Retrieve Error Messages using odbc_errormsg()?
- How To Turn Off Warning Messages during PHP Execution?
- How To Receive Returning Result from a Query?
- How To Loop through Result Set Objects using odbc_fetch_row()?
- How To Retrieve Field Values using odbc_result()?
- How To List All Tables in the Database using odbc_tables()?
- How To List All Columns in a Table using odbc_columns()?
- How To Create Prepared Statements using odbc_prepare()?
|