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, 1251🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...