mssql_bind(3) [php man page]
MSSQL_BIND(3) MSSQL_BIND(3) mssql_bind - Adds a parameter to a stored procedure or a remote stored procedure SYNOPSIS
bool mssql_bind (resource $stmt, string $param_name, mixed &$var, int $type, [bool $is_output = false], [bool $is_null = false], [int $maxlen = -1]) DESCRIPTION
Binds a parameter to a stored procedure or a remote stored procedure. PARAMETERS
o $stmt - Statement resource, obtained with mssql_init(3). o $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(3). o $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. o $type - One of: SQLTEXT, SQLVARCHAR, SQLCHAR, SQLINT1, SQLINT2, SQLINT4, SQLBIT, SQLFLT4, SQLFLT8, SQLFLTN. o $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. o $is_null - Whether the parameter is NULL or not. Passing the NULL value as $var will not do the job. o $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. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 mssql_bind(3) 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); ?> SEE ALSO
mssql_execute(3), mssql_free_statement(3), mssql_init(3). PHP Documentation Group MSSQL_BIND(3)
Check Out this Related Man Page
MAXDB_STMT_PREPARE(3) 1 MAXDB_STMT_PREPARE(3) maxdb_stmt_prepare - Prepare an SQL statement for execution Procedural style SYNOPSIS
bool maxdb_stmt_prepare (resource $stmt, string $query) DESCRIPTION
Object oriented style mixed maxdb_stmt::prepare (string $query) maxdb_stmt_prepare(3) prepares the SQL query pointed to by the null-terminated string query. The statement resource has to be allocated by maxdb_stmt_init(3). The query must consist of a single SQL statement. Note You should not add a terminating semicolon or g to the statement. The parameter $query can include one or more parameter markers in the SQL statement by embedding question mark ( ?) characters at the appropriate positions. Note The markers are legal only in certain places in SQL statements. For example, they are allowed in the VALUES() list of an INSERT statement (to specify column values for a row), or in a comparison with a column in a WHERE clause to specify a comparison value. However, they are not allowed for identifiers (such as table or column names), in the select list that names the columns to be returned by a SELECT statement), or to specify both operands of a binary operator such as the = equal sign. The latter restriction is necessary because it would be impossible to determine the parameter type. In general, parameters are legal only in Data Manipula- tion Languange (DML) statements, and not in Data Defination Language (DDL) statements. The parameter markers must be bound to application variables using maxdb_stmt_bind_param(3) and/or maxdb_stmt_bind_result(3) before exe- cuting the statement or fetching rows. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 Object oriented style <?php $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } $city = "Portland"; /* create a prepared statement */ $stmt = $maxdb->stmt_init(); if ($stmt->prepare("SELECT state FROM hotel.city WHERE name=?")) { /* bind parameters for markers */ $stmt->bind_param("s", $city); /* execute query */ $stmt->execute(); /* bind result variables */ $stmt->bind_result($district); /* fetch value */ $stmt->fetch(); printf("%s is in district %s ", $city, $district); /* close statement */ $stmt->close(); } /* close connection */ $maxdb->close(); ?> Example #2 Procedural style <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s ", maxdb_connect_error()); exit(); } $city = "Portland"; /* create a prepared statement */ $stmt = maxdb_stmt_init($link); if (maxdb_stmt_prepare($stmt, "SELECT state FROM hotel.city WHERE name=?")) { /* bind parameters for markers */ maxdb_stmt_bind_param($stmt, "s", $city); /* execute query */ maxdb_stmt_execute($stmt); /* bind result variables */ maxdb_stmt_bind_result($stmt, $district); /* fetch value */ maxdb_stmt_fetch($stmt); printf("%s is in district %s ", $city, $district); /* close statement */ maxdb_stmt_close($stmt); } /* close connection */ maxdb_close($link); ?> The above example will output something similar to: Portland is in district OR SEE ALSO
maxdb_stmt_init(3), maxdb_stmt_execute(3), maxdb_stmt_fetch(3), maxdb_stmt_bind_param(3), maxdb_stmt_bind_result(3), maxdb_stmt_close(3). PHP Documentation Group MAXDB_STMT_PREPARE(3)