mssql_result(3) [php man page]
MSSQL_RESULT(3) MSSQL_RESULT(3) mssql_result - Get result data SYNOPSIS
string mssql_result (resource $result, int $row, mixed $field) DESCRIPTION
mssql_result(3) returns the contents of one cell from a MS SQL result set. PARAMETERS
o $result - The result resource that is being evaluated. This result comes from a call to mssql_query(3). o $row - The row number. o $field - Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), it uses the alias instead of the column name. Note Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu- ment. RETURN VALUES
Returns the contents of the specified cell. EXAMPLES
Example #1 mssql_result(3) example <?php // Send a select query to MSSQL $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]'); // Check if there were any records if (!mssql_num_rows($query)) { echo 'No records found'; } else { for ($i = 0; $i < mssql_num_rows($query); ++$i) { echo mssql_result($query, $i, 'username'), PHP_EOL; } } // Free the query result mssql_free_result($query); ?> The above example will output something similar to: Kalle Felipe Emil Ross Example #2 Faster alternative to above example <?php // Send a select query to MSSQL $query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]'); // Check if there were any records if (!mssql_num_rows($query)) { echo 'No records found'; } else { while ($row = mssql_fetch_array($query)) { echo $row['username'], PHP_EOL; } } // Free the query result mssql_free_result($query); ?> NOTES
Note When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3). SEE ALSO
Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3). PHP Documentation Group MSSQL_RESULT(3)
Check Out this Related Man Page
INGRES_UNBUFFERED_QUERY(3) 1 INGRES_UNBUFFERED_QUERY(3) ingres_unbuffered_query - Send an unbuffered SQL query to Ingres SYNOPSIS
mixed ingres_unbuffered_query (resource $link, string $query, [array $params], [string $types]) DESCRIPTION
ingres_unbuffered_query(3) sends the given $query to the Ingres server. The query becomes part of the currently open transaction. If there is no open transaction, ingres_unbuffered_query(3) opens a new transac- tion. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use ingres_autocommit(3) before opening a new transaction to have every SQL query immediately committed. Ingres allows only a single unbuffered statement to be active at any one time. The extension will close any active unbuffered statements before executing any SQL. In addition you cannot use ingres_result_seek(3) to position the row before fetching. Note Related Configurations See also the ingres.describe and ingres.utf8 directives in Runtime Configuration. PARAMETERS
o $link - The connection link identifier o $query - A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3) for a list of SQL statements that cannot be executed via ingres_unbuffered_query(3). Data inside the query should be properly escaped. o $params - An array of parameter values to be used with the query o $types - A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list of type codes. RETURN VALUES
ingres_unbuffered_query(3) returns a query result identifier when there are rows to fetch; else it returns FALSE when there are no rows, as is the case of an INSERT, UPDATE, or DELETE statement. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsql- state(3). EXAMPLES
Example #1 Issue a simple un-buffered select <?php $link = ingres_connect("demodb"); $result = ingres_unbuffered_query($link, "select * from user_profile"); while ($row = ingres_fetch_row($result)) { echo $row[1]; echo $row[2]; } ?> Example #2 Passing query parameters to ingres_unbuffered_query(3) <?php $link = ingres_connect("demodb"); $params[] = "Emma"; $query = "select * from user_profile where up_first = ?"; $result = ingres_unbuffered_query($link, $query, $params); while ($row = ingres_fetch_row($result)) { echo $row[1]; echo $row[2]; } ?> Example #3 Inserting a BLOB with parameter types <?php $link = ingres_connect("demodb"); //Open a photo $fh = fopen("photo.jpg","r"); $blob_data = stream_get_contents($fh); fclose($fh); //Prepare parameters $params[] = $blob_data; $params[] = 1201; //Define parameter types $param_types = "Bi"; $query = "update user_profile set up_image = ? where up_id = ?"; $result = ingres_unbuffered_query($link, $query , $params, $param_types); if (ingres_errno()) { echo ingres_errno() . "-" . ingres_error() . " "; } ?> SEE ALSO
ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_roll- back(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3). PHP Documentation Group INGRES_UNBUFFERED_QUERY(3)