首页 >函数列表 >mssql_bind

mssql_bind

mssql_bind

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

mssql_bindAdds a parameter to a stored procedure or a remote stored procedure

说明

bool mssql_bind ( resource $stmt , string $param_name , mixed &$var , int $type [, bool $is_output = false [, bool $is_null = false [, int $maxlen = -1 ]]] )

Binds a parameter to a stored procedure or a remote stored procedure.

参数

stmt

Statement resource, obtained with mssql_init().

param_name

The parameter name, as a string.

Note:

You have to include the @ character, like in the T-SQL syntax. See the explanation included in mssql_execute().

var

The PHP variable you'll bind the MSSQL parameter to. It is passed by reference, to retrieve OUTPUT and RETVAL values after the procedure execution.

type

One of: SQLTEXT, SQLVARCHAR, SQLCHAR, SQLINT1, SQLINT2, SQLINT4, SQLBIT, SQLFLT4, SQLFLT8, SQLFLTN.

is_output

Whether the value is an OUTPUT parameter or not. If it's an OUTPUT parameter and you don't mention it, it will be treated as a normal input parameter and no error will be thrown.

is_null

Whether the parameter is NULL or not. Passing the NULL value as var will not do the job.

maxlen

Used with char/varchar values. You have to indicate the length of the data so if the parameter is a varchar(50), the type must be SQLVARCHAR and this value 50.

返回值

成功时返回 TRUE, 或者在失败时返回 FALSE.

范例

Example #1 mssql_bind() example

<?php
// Connect to MSSQL and select the database
mssql_connect('KALLESPCSQLEXPRESS''sa''phpfi');
mssql_select_db('php');

// Create a new stored prodecure
$stmt mssql_init('NewUserRecord');

// Bind the field names
mssql_bind($stmt'@username',  'Kalle',  SQLVARCHAR,  false,  false,  60);
mssql_bind($stmt'@name',      'Kalle',  SQLVARCHAR,  false,  false,  60);
mssql_bind($stmt'@age',       19,       SQLINT1,     false,  false,   3);

// Execute
mssql_execute($stmt);

// Free statement
mssql_free_statement($stmt);
?>

参见


  • mssql_bind
  • mssql_close
  • mssql_connect
  • mssql_data_seek
  • mssql_execute
  • mssql_fetch_array
  • mssql_fetch_assoc
  • mssql_fetch_batch
  • mssql_fetch_field
  • mssql_fetch_object
  • mssql_fetch_row
  • mssql_field_length
  • mssql_field_name
  • mssql_field_seek
  • mssql_field_type
  • mssql_free_result
  • mssql_free_statement
  • mssql_get_last_message
  • mssql_guid_string
  • mssql_init
  • mssql_min_error_severity
  • mssql_min_message_severity
  • mssql_next_result
  • mssql_num_fields
  • mssql_num_rows
  • mssql_pconnect
  • mssql_query
  • mssql_result
  • mssql_rows_affected
  • mssql_select_db
  • PHP MySQL HTML CSS JavaScript MSSQL AJAX .NET JSP Linux Mac ASP 服务器 SQL jQuery C# C++ java Android IOS oracle MongoDB SQLite wamp 交通频道