Collections:
odbc_result() - Retrieve Field Values
How To Retrieve Field Values using odbc_result()?
✍: Guest
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
⇒ odbc_tables() - Listing All Tables in the Database
⇐ odbc_fetch_row() - Looping through Result Set Objects
⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution
2024-07-11, 2857🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...