Collections:
PHP ODBC - odbc_fetch_array() - Looping through Returning Rows
PHP ODBC - How To Loop through Returning Rows?
✍: Guest
The best way to query tables and loop through returning rows is to run a SELECT statement with the odbc_exec() function, catch the returning object as a result set, and loop through the result with odbc_fetch_array() function in a while loop as shown in the following sample PHP script:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "SELECT id, url, time FROM fyi_links"; $res = odbc_exec($con, $sql); while ($row = odbc_fetch_array($res)) { print($row['id'].",".$row['url'].",".$row['time']."\n"); } odbc_free_result($res); odbc_close($con); ?>
Using odbc_fetch_array() is better than other fetch functions, because it allows you to access field values by field names. If you run this script, you will see all rows from the fyi_links table are printed on the screen:
101,dev.fyicenter.com, 102,dba.fyicenter.com, 1101,moc.retneciyf.ved, 1102,moc.retneciyf.abd, 2101,dev.fyicenter.com, 2102,dba.fyicenter.com,
Don't forget to call odbc_free_result($res). It is important to free up result set objects as soon as you are done with them.
⇒ PHP ODBC - Updating Existing Rows in a Table
⇐ PHP ODBC - Returning Result Set Objects
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-05-29, 1508🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...