mssql_query(3) [php man page]

MSSQL_QUERY(3)															    MSSQL_QUERY(3)

mssql_query - Send MS SQL query

SYNOPSIS

       mixed mssql_query (string  $query, [resource  $link_identifier], [int  $batch_size])

DESCRIPTION

       mssql_query(3) sends a query to the currently active database on the server that's associated with the specified link identifier.

PARAMETERS

	      o $query
		- An SQL query.

	      o $link_identifier
		-  A  MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3).  If the link identifier isn't specified, the last
		opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect(3) was called, and use it.

	      o $batch_size
		- The number of records to batch in the buffer.

RETURN VALUES

	Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.

EXAMPLES

       Example #1

	      mssql_query(3) example

	      <?php
	      // Connect to MSSQL
	      $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');

	      if (!$link || !mssql_select_db('php', $link)) {
		  die('Unable to connect or select database!');
	      }

	      // Do a simple query, select the version of
	      // MSSQL and print it.
	      $version = mssql_query('SELECT @@VERSION');
	      $row = mssql_fetch_array($version);

	      echo $row[0];

	      // Clean up
	      mssql_free_result($version);
	      ?>

NOTES

       Note

	       If the query returns multiple results then it is necessary to fetch all results by mssql_next_result(3)	or  free  the  results	by
	      mssql_free_result(3) before executing next query.

SEE ALSO

       mssql_select_db(3), mssql_connect(3).

PHP Documentation Group 													    MSSQL_QUERY(3)

MSSQL_FETCH_FIELD(3)													      MSSQL_FETCH_FIELD(3)

mssql_fetch_field - Get field information

SYNOPSIS

       object mssql_fetch_field (resource  $result, [int  $field_offset = -1])

DESCRIPTION

       mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.

PARAMETERS

	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

	      o $field_offset
		-  The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
		retrieved. The $field_offset starts at 0.

RETURN VALUES

	Returns an object containing field information.

	The properties of the object are:

	      o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.

	      o column_source - the table from which the column was taken

	      o max_length - maximum length of the column

	      o numeric - 1 if the column is numeric

	      o type - the column type.

EXAMPLES

       Example #1

	      mssql_fetch_field(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information
		  $field = mssql_fetch_field($query, $i);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';
	      }

	      echo '</tbody>';
	      echo '</table>';

	      // Free the query result
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_field_seek(3).

PHP Documentation Group 												      MSSQL_FETCH_FIELD(3)