|
|
| Microsoft Drivers for PHP for SQL Server version 2.0 and 3.0 |
| PDOStatement::bindValue |
| Example See Also Send Feedback |
Binds a value to a named or question mark placeholder in the SQL statement.
Syntax
bool PDOStatement::bindValue( $parameter, $value [,$data_type] ); |
Parameters
$parameter: A (mixed) parameter identifier. For a statement using named placeholders, a parameter name (:name). For a prepared statement using the question mark syntax, this will be the 1-based index of the parameter.
$value: The (mixed) value to bind to the parameter.
$data_type: The optional (integer) data type represented by a PDO::PARAM_* constant. The default is PDO::PARAM_STR.
Return Value
TRUE on success, otherwise FALSE.
Remarks
Support for PDO was added in version 2.0 of the Microsoft Drivers for PHP for SQL Server.
Example
This example shows that after the value of $contact is bound, changing the value does not change the value passed in the query.
|
Copy Code
|
|
|---|---|
<?php
$database = "AdventureWorks";
$server = "(local)";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");
$contact = "Sales Agent";
$stmt = $conn->prepare("select * from Person.ContactType where name = ?");
$stmt->bindValue(1, $contact);
$contact = "Owner";
$stmt->execute();
while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ){
print "$row[Name]\n\n";
}
$stmt = null;
$contact = "Sales Agent";
$stmt = $conn->prepare("select * from Person.ContactType where name = :contact");
$stmt->bindValue(':contact', $contact);
$contact = "Owner";
$stmt->execute();
while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ){
print "$row[Name]\n\n";
}
?>
|
|
