msql_fetch_object(3) [php man page]

MSQL_FETCH_OBJECT(3)													      MSQL_FETCH_OBJECT(3)

msql_fetch_object - Fetch row as object

SYNOPSIS

       object msql_fetch_object (resource  $result)

DESCRIPTION

       msql_fetch_object(3)  is similar to msql_fetch_array(3), with one difference - an object is returned, instead of an array. Indirectly, that
       means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).

	Speed-wise, the function is identical to msql_fetch_array(3), and almost as quick as msql_fetch_row(3) (the difference is insignificant).

PARAMETERS

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

RETURN VALUES

	Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.

EXAMPLES

       Example #1

	      msql_fetch_object(3) example

	      <?php
	      $con = msql_connect();
	      if (!$con) {
		  die('Server connection problem: ' . msql_error());
	      }

	      if (!msql_select_db('test', $con)) {
		  die('Database connection problem: ' . msql_error());
	      }

	      $result = msql_query('SELECT id, name FROM people', $con);
	      if (!$result) {
		  die('Query execution problem: ' . msql_error());
	      }

	      while ($row = msql_fetch_object($result, MSQL_ASSOC)) {
		  echo $row->id . ': ' . $row->name . "
";
	      }

	      msql_free_result($result);
	      ?>

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.0.4	|						    |
       |	|						    |
       |	|  A bug was fixed when retrieving data  from  col- |
       |	| umns	containing  NULL  values. Such columns were |
       |	| not placed into the resulting array.		    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       msql_fetch_array(3), msql_fetch_row(3), msql_data_seek(3), msql_result(3).

PHP Documentation Group 												      MSQL_FETCH_OBJECT(3)

SQLSRV_FETCH_OBJECT(3)													    SQLSRV_FETCH_OBJECT(3)

sqlsrv_fetch_object - Retrieves the next row of data in a result set as an object

SYNOPSIS

       mixed sqlsrv_fetch_object (resource  $stmt, [string  $className], [array  $ctorParams], [int  $row], [int  $offset])

DESCRIPTION

	Retrieves  the	next  row of data in a result set as an instance of the specified class with properties that match the row field names and
       values that correspond to the row field values.

PARAMETERS

	      o $stmt
		- A statement resource created by sqlsrv_query(3) or sqlsrv_execute(3).

	      o $className
		- The name of the class to instantiate. If no class name is specified, stdClass is instantiated.

	      o $ctorParams
		- Values passed to the constructor of the specified class. If the constructor of the specified class takes parameters,	the  ctor-
		Params array must be supplied.

	      o $row
		-  The	row  to  be accessed. This parameter can only be used if the specified statement was prepared with a scrollable cursor. In
		that case, this parameter can take on one of the following values:

		     oSQLSRV_SCROLL_NEXT

		     oSQLSRV_SCROLL_PRIOR

		     oSQLSRV_SCROLL_FIRST

		     oSQLSRV_SCROLL_LAST

		     oSQLSRV_SCROLL_ABSOLUTE

		     oSQLSRV_SCROLL_RELATIVE

	      o $offset
		- Specifies the row to be accessed if the row parameter is set to SQLSRV_SCROLL_ABSOLUTE or SQLSRV_SCROLL_RELATIVE. Note that  the
		first row in a result set has index 0.

RETURN VALUES

	Returns  an  object  on success, NULL if there are no more rows to return, and FALSE if an error occurs or if the specified class does not
       exist.

EXAMPLES

       Example #1

	      sqlsrv_fetch_object(3) example

	       The following example demonstrates how to retrieve a row as a stdClass object.

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);
	      if( $conn === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      $sql = "SELECT fName, lName FROM Table_1";
	      $stmt = sqlsrv_query( $conn, $sql);
	      if( $stmt === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      // Retrieve each row as an object.
	      // Because no class is specified, each row will be retrieved as a stdClass object.
	      // Property names correspond to field names.
	      while( $obj = sqlsrv_fetch_object( $stmt)) {
		    echo $obj->fName.", ".$obj->lName."<br />";
	      }
	      ?>

NOTES

	If a class name is specified with the optional $className parameter and the class has properties whose names match the	result	set  field
       names,  the  corresponding  result  set values are applied to the properties. If a result set field name does not match a class property, a
       property with the result set field name is added to the object and the result set value is applied to the  property.  The  following  rules
       apply when using the $className parameter:

	      oField-property name matching is case-sensitive.

	      oField-property matching occurs regardless of access modifiers.

	      oClass property data types are ignored when applying a field value to a property.

	      oIf the class does not exist, the function returns
		FALSE and adds an error to the error collection.

	Regardless  of	whether  the  $className parameter is supplied, if a field with no name is returned, the field value will be ignored and a
       warning will be added to the error collection.

	When consuming a result set that has multiple columns with the same name, it may be better to use sqlsrv_fetch_array(3) or the combination
       of sqlsrv_fetch(3) and sqlsrv_get_field(3).

SEE ALSO

       sqlsrv_fetch(3), sqlsrv_fetch_array(3).

PHP Documentation Group 												    SQLSRV_FETCH_OBJECT(3)