Collections:
odbc_fetch_row() - Looping through Result Set Objects
How To Loop through Result Set Objects using odbc_fetch_row()?
✍: Guest
If the returning output of a query statement is captured in a result set object, you can use odbc_fetch_row() to loop through each row in the output.
The tutorial PHP script below shows you how to list tables in the database:
<?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,'name')."\n");
}
odbc_free_result($res);
odbc_close($con);
?>
If you run this script, you will get something like:
User Tables: fyi_rates fyi_team fyi_random fyi_links_indexed fyi_links fyi_links_copy tipBackup2
⇒ odbc_result() - Retrieve Field Values
⇐ Returning Result from Query with ODBC Connection
⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution
2024-06-30, 2965🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...