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
sqlsrv_fetch(3) - php
db2_num_fields(3) - php
mssql_free_statement(3) - php
mssql_init(3) - php
sqlsrv_num_fields(3) - php
Similar Topics in the Unix Linux Community
DB2 stored procedure (with input parameters) from script
Help in extracting only certain elements in file
How to call sqlloader from stored procedure!!! Advise
file content as a part of an if-statement
How to pass date to SQL server SP?