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, 1228🔥, 0💬

SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
A collection of 17 FAQs on using PHP MSSQL functions to connect to manage tables and data rows. Clear explanations and tutorial exercises are provided on creating tables; inserting multiple data rows; updating and deleting data rows; searching data from multiple tables; looping through result sets; ... 2024-03-07, 1237🔥, 0💬

mssql_query() - Executing SQL Statements
How To Execute a SQL Statement using mssql_query()? Once you have created a connection object, you can use the mssql_query() function to send a SQL statement to the SQL Server linked to the connection object for execution. Here is a simple PHP script that creates a new schema and a new table: &l... 2024-04-07, 1235🔥, 0💬

mssql_select_db() - Selecting an Exiting Database
How To Select an Exiting Database using mssql_select_db()? The first thing after you have created a connection object to the SQL Server is to select the database where your tables are located, by using the mssql_select_db() function. If your MSSQL server is offered by your Web hosting company, they ... 2024-04-07, 1233🔥, 0💬

Turning Off PHP Warning Messages for MSSQL Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-03-23, 1233🔥, 0💬

mssql_close() - Disconnecting from a SQL Server
How To Disconnect from a SQL Server using mssql_close()? When you call mssql_connect(), it will return an object representing the connection to the SQL Server. This connection object will be used by subsequent MSSQL function calls. When you are done with this connection, you should close it to free ... 2024-04-07, 1232🔥, 0💬

Returning Result from Query with MSSQL Connection
How To Receive Returning Result from a Query? 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 F... 2024-03-23, 1229🔥, 0💬

mssql_field_name() - Retrieve Field Names
How To List All Field Names in the Result Set using mssql_field_name()? The result set object returned by a SELECT statement also contains column (field) names, lengths and types. You can use mssql_field_name(), mssql_field_length() and mssql_field_type() to get those information. The tutorial exerc... 2024-03-23, 1226🔥, 0💬

mssql_fetch_array() - Looping through Result Set Objects
How To Loop through Result Set Objects using mssql_fetch_array()? 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: &... 2024-03-23, 1220🔥, 0💬

mssql_result() - Retrieve Field Values
How To Retrieve Field Values using mssql_result()? Once the result set is captured in an object, you can think of it as a "table" with rows and columns (fields). You can use mssql_result() to retrieve the value of any given row and column (field) with this formats: $value = mssql_result($res, $row, ... 2024-03-23, 1214🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.