Returning Result from Query with MSSQL Connection

Q

How To Receive Returning Result from a Query?

✍: Guest

A

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

⇑⇑ SQL Server Connection Tutorials

2024-03-23, 1273🔥, 0💬