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, 1447🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...