php man page for mssql_execute

Query: mssql_execute

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MSSQL_EXECUTE(3)														  MSSQL_EXECUTE(3)

mssql_execute - Executes a stored procedure on a MS SQL server database

SYNOPSIS
mixed mssql_execute (resource $stmt, [bool $skip_results = false])
DESCRIPTION
Executes a stored procedure on a MS SQL server database
PARAMETERS
o $stmt - Statement handle obtained with mssql_init(3). o $skip_results - Whenever to skip the results or not.
EXAMPLES
Example #1 mssql_execute(3) example <?php // Create a new statement $stmt = mssql_init('NewBlogEntry'); // Some data strings $title = 'Test of blogging system'; $content = 'If you can read this, then the new system is compatible with MSSQL'; // Bind values mssql_bind($stmt, '@author', 'Felipe Pena', SQLVARCHAR, false, false, 60); mssql_bind($stmt, '@date', '08/10/2008', SQLVARCHAR, false, false, 20); mssql_bind($stmt, '@title', $title, SQLVARCHAR, false, false, 60); mssql_bind($stmt, '@content', $content, SQLTEXT); // Execute the statement mssql_execute($stmt); // And we can free it like so: mssql_free_statement($stmt); ?>
NOTES
Note If the stored procedure returns parameters or a return value these will be available after the call to mssql_execute(3) unless the stored procedure returns more than one result set. In that case use mssql_next_result(3) to shift through the results. When the last result has been processed the output parameters and return values will be available.
SEE ALSO
mssql_bind(3), mssql_free_statement(3), mssql_init(3). PHP Documentation Group MSSQL_EXECUTE(3)
Related Man Pages
mssql_execute(3) - php
db2_result(3) - php
mssql_init(3) - php
sqlsrv_free_stmt(3) - php
sqlsrv_has_rows(3) - php
Similar Topics in the Unix Linux Community
DB2 stored procedure (with input parameters) from script
how to pass the values to unix shell from the oracle stored procedure.
how to call oracle stored procedure from unix shell
Execute stored procedure through script in sybase database and store the output in a .csv file
How to pass date to SQL server SP?