Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To Loop through Result Set Objects using odbc_fetch_row()?

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('ggl_SQL_SERVER','sa','GlobalGuideLine');

$sql = "SELECT * FROM sys.objects"

. " WHERE type_desc='USER_TABLE'";

$res = odbc_exec($con, $sql);

print("User Tables: ");

while (odbc_fetch_row($res)) {

print(" ".odbc_result($res,'name')." ");

}

odbc_free_result($res);

odbc_close($con);

?>

If you run this script, you will get something like:

User Tables:

ggl_rates

ggl_team

ggl_random

ggl_links_indexed

ggl_links

ggl_links_copy

tipBackup2

 134 views

More Questions for you: