PHP 使用 PDO 方式连接 sqlserver ,拼接的 sql 命令总是报错

onlyhotv2ex 2016-12-12 05:05:29

$sql = "Declare @v1 varchar(5000)";
$sql .= "Declare @v2 varchar(5000)";
$sql .= "Set @v1 = '";
$sql .= "<?xml version = \"1.0\"?>";
$sql .= "<Var1Data>";
$sql .= "<BodoOrder>";
$sql .= "<OrderNo>2016121201380</OrderNo>";
$sql .= "<Bodtype>订单</BodType>";
$sql .= "<xdate>2016-12-12</xdate>";
$sql .= "<DID>00</DID>";
$sql .= "<CID>104179</CID>";
$sql .= "<Contacter>111</Contacter>";
$sql .= "<Tel>13707165174</Tel>";
$sql .= "<address>测试地址</address>";
$sql .= "<BodNote>测试</BodNote>";
$sql .= "</BodoOrder>";
$sql .= "</Var1Data>'";
$sql .= "Set @v2 = '";
$sql .= "<?xml version = \"1.0\"?>";
$sql .= "<Var2Data>";
$sql .= "<BodoOrderDetails>";
$sql .= "<PID>14241</PID>";
$sql .= "<Color>金色</Color>";
$sql .= "<Size>90C</Size>";
$sql .= "<nQty>1</nQty>";
$sql .= "<nPrice>188.00</nPrice>";
$sql .= "</BodoOrderDetails>";
$sql .= "</Var2Data>'";
$sql .= "Exec LW2DRP @v1,@v2";

try {
$stmt = $dbh->prepare($sql);
$stmt->execute();
} catch (Exception $e) {
echo $e->getMessage();
}
这是报错：
Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[42000]: Syntax error or access violation: 102 [Microsoft][SQL Server Native Client 11.0][SQL Server]'' 附近有语法错误。

但是我把命令输出以后直接放到数据库是可以执行的。

...全文