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
2023-12-31, 1205🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...