Mssql 函数
php 手册 | 脚本学堂 | 脚本编程 | 网站编程 | 系统管理 | 服务器配置 | 数据库管理 | Php教程 | python教程 | 正则表达式 | 批处理脚本 | Centos教程 | Linux基础教程

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
mssql_connect('KALLESPC\SQLEXPRESS''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 函数
php 手册 | 脚本学堂 | 脚本编程 | 网站编程 | 系统管理 | 服务器配置 | 数据库管理 | Php教程 | python教程 | 正则表达式 | 批处理脚本 | Centos教程 | Linux基础教程