mssql_init

(PHP 4 >= 4.0.7, PHP 5, PECL odbtp >= 1.1.1)

mssql_init — Initializes a stored procedure or a remote stored procedure

Warning

This function was REMOVED in PHP 7.0.0.

Alternatives to this function include:

Using an EXEC query issued through PDO_SQLSRV, PDO_ODBC, SQLSRV, or the unified ODBC driver.

说明

mssql_init ( string $sp_name [, resource $link_identifier ] ) : resource

Initializes a stored procedure or a remote stored procedure.

参数

sp_name: Stored procedure name, like ownew.sp_name or otherdb.owner.sp_name.
link_identifier: A MS SQL link identifier, returned by mssql_connect().

返回值

Returns a resource identifier "statement", used in subsequent calls to mssql_bind() and mssql_execute(), or FALSE on errors.

范例

Example #1 mssql_init() example


<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPC\SQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);

// Create a new statement
$stmt = mssql_init('StatementTest', $link);

// Bind values here

// Once values are binded we execute our statement 
// using mssql_execute:
mssql_execute($stmt);

// And we can free it like so:
mssql_free_statement($stmt);
?>

参见

mssql_bind() - Adds a parameter to a stored procedure or a remote stored procedure
mssql_execute() - Executes a stored procedure on a MS SQL server database
mssql_free_statement() - Free statement memory