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, 1437🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...