<?php
$database = "AdventureWorks";
$server = "(local)";
$dbh = new PDO( "sqlsrv:server=$server ; Database = $database", "", ""); $dbh->query("IF OBJECT_ID('dbo.sp_ReverseString', 'P') IS NOT NULL DROP PROCEDURE dbo.sp_ReverseString");
$dbh->query("CREATE PROCEDURE dbo.sp_ReverseString @String as VARCHAR(2048) OUTPUT as SELECT @String = REVERSE(@String)");
$stmt = $dbh->prepare("EXEC dbo.sp_ReverseString ?");
$string = "123456789";
$stmt->bindParam(1, $string, PDO::PARAM_STR | PDO::PARAM_INPUT_OUTPUT, 2048);
$stmt->execute();
print $string; // Expect 987654321
?>只找了一个调用输出的
我有一个储存过程LD3_ArrangeCar_GO 有两个输入参数@BeginDat(开始日期)和@EnDat(结束日期)和一个输出参数@OutPutMsg
想在PHP中调用它,应该如何操作,下面无输出,无报错
$serverName = "(LOCAL)";
$database = "test_sql";
$dbh= new PDO( "sqlsrv:server=$serverName;Database = $database", "sa", "2010");
$sth=$dbh->prepare("EXEC dbo.LD3_ArrangeCar_GO ?");
$BeginDate="2010-07-10";
$EndDate="2010-08-11";
$Null1="";
$str_select=$sth->bindParam(1, $BeginDate,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->bindParam(2, $EndDate,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->bindParam(3, $Null1,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->execute();
$result = $sth->fetchAll();
$database = "AdventureWorks";
$server = "(local)";
$dbh = new PDO( "sqlsrv:server=$server ; Database = $database", "", ""); $dbh->query("IF OBJECT_ID('dbo.sp_ReverseString', 'P') IS NOT NULL DROP PROCEDURE dbo.sp_ReverseString");
$dbh->query("CREATE PROCEDURE dbo.sp_ReverseString @String as VARCHAR(2048) OUTPUT as SELECT @String = REVERSE(@String)");
$stmt = $dbh->prepare("EXEC dbo.sp_ReverseString ?");
$string = "123456789";
$stmt->bindParam(1, $string, PDO::PARAM_STR | PDO::PARAM_INPUT_OUTPUT, 2048);
$stmt->execute();
print $string; // Expect 987654321
?>只找了一个调用输出的
我有一个储存过程LD3_ArrangeCar_GO 有两个输入参数@BeginDat(开始日期)和@EnDat(结束日期)和一个输出参数@OutPutMsg
想在PHP中调用它,应该如何操作,下面无输出,无报错
$serverName = "(LOCAL)";
$database = "test_sql";
$dbh= new PDO( "sqlsrv:server=$serverName;Database = $database", "sa", "2010");
$sth=$dbh->prepare("EXEC dbo.LD3_ArrangeCar_GO ?");
$BeginDate="2010-07-10";
$EndDate="2010-08-11";
$Null1="";
$str_select=$sth->bindParam(1, $BeginDate,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->bindParam(2, $EndDate,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->bindParam(3, $Null1,PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,TRUE,50);
$str_select=$sth->execute();
$result = $sth->fetchAll();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货