Collections:
mssql_fetch_array() - Looping through Result Set Objects
How To Loop through Result Set Objects using mssql_fetch_array()?
✍: Guest
If the returning output of a query statement is captured in a result set object, you can use mssql_fetch_array() to loop through each row in the output.
The tutorial PHP script below shows you how to list tables in the database:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "SELECT * FROM sys.objects" . " WHERE type_desc='USER_TABLE'"; $res = mssql_query($sql, $con); print("User Tables:\n"); while ($row = mssql_fetch_array($res)) { print(" ".$row{'name'}."\n"); } mssql_free_result($res); mssql_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
⇒ mssql_result() - Retrieve Field Values
⇐ Returning Result from Query with MSSQL Connection
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-03-23, 1218🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...