Collections:
Returning Result from Query with MSSQL Connection
How To Receive Returning Result from a Query?
✍: Guest
When you execute a SQL SELECT statement with the mssql_query() function, you can capture the returning result with a result set object with the following syntax:
$result_set = mssql_query($sql_statement); #- The returning value could be a Boolean value FALSE, #- if the execution failed.
The result set object represents the result in rows and column. The tutorial below shows you how to capture the result set:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = 'SELECT GETDATE()'; $res = mssql_query($sql, $con); $date = mssql_result($res,0,0); print("Database current time: ". $date ."\n"); mssql_close($con); ?>
If you run this script, you will get something like this:
Database current time: Jun 2 2007 4:37PM
⇒ mssql_fetch_array() - Looping through Result Set Objects
⇐ Turning Off PHP Warning Messages for MSSQL Connection
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-03-23, 1264🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...