問(wèn)題描述

這不起作用:

  $dbh = new PDO("dblib:host=xxxx;dbname=xxx", "xxxxx", "xxxxx");

  $sth = $dbh->prepare("{exec wcweb_UserInfo(?)}");
  $sth->bindParam(1, $name);
  $sth->execute();

  while($result = $sth->fetch(PDO::FETCH_ASSOC)) {
    var_dump($result);
  }

這也不起作用:

  $dbh = new PDO("dblib:host=xxxxx;dbname=xxxx", "xxxxx", "xxxx");

  $sth = $dbh->prepare("{call wcweb_UserInfo(?)}");
  $sth->bindParam(1, $name);
  $sth->execute();

  while($result = $sth->fetch(PDO::FETCH_ASSOC)) {
    var_dump($result);
  }

這確實(shí)有效:

  $dbh = new PDO("dblib:host=xxxxx;dbname=xxxx", "xxxxx", "xxxx");

  $sth = $dbh->prepare("exec wcweb_UserInfo @userid=?");
  $sth->bindParam(1, $name);
  $sth->execute();

  while($result = $sth->fetch(PDO::FETCH_ASSOC)) {
    var_dump($result);
  }

我使用 2 嘗試了上面的方法，不管有沒(méi)有大括號(hào)，等等.我知道有些人會(huì)說(shuō)，好吧，就按照它的工作方式來(lái)做吧?.. 問(wèn)題是我正在使用 sqlsrv_query 庫(kù)將現(xiàn)有應(yīng)用程序從 IIS 服務(wù)器移植到 Linux 服務(wù)器.

I tried the above using 2 that did not work with and without the curly brackets, etc. I know some would say, well just do it the way it works? .. The problem is I am porting an exising application from an IIS Server using the sqlsrv_query library to a Linux server.

應(yīng)用程序中的所有數(shù)據(jù)庫(kù)調(diào)用都是用使用此方法的函數(shù)編寫(xiě)的:{call wcweb_UserInfo(?)} .. 沒(méi)有指定任何參數(shù)名稱，因此我必須修改每個(gè)數(shù)據(jù)庫(kù)調(diào)用以包含參數(shù)名稱.我的印象是 PHP5 的 PDO 庫(kù)可以執(zhí)行相同類型的調(diào)用?

All of the database calls in the app are written in functions that use this method: {call wcweb_UserInfo(?)} .. None of the parameter names are specified, so I would have to modify every database call to include the parameter names. I was under the impression that the PDO library for PHP5 can do those same kind of calls?

幫助！是我做錯(cuò)了什么還是只是 PDO 無(wú)法進(jìn)行這些類型的調(diào)用?

Help! Is there something I am doing wrong or is it just that PDO can't make those kinds of calls?

推薦答案

出于某種原因，這有效:

For some reason this works:

  $sth = $dbh->prepare("exec wcweb_UserInfo ?");
  $sth->bindParam(1, $name);
  $sth->execute();

  while($result = $sth->fetch(PDO::FETCH_ASSOC)) {
    var_dump($result);
  }

我也許可以忍受這個(gè).有誰(shuí)知道為什么其他方法不起作用?圖書(shū)館有區(qū)別嗎?

I might be able to live with this. Anyone know why the other methods do not work? Is it a difference in the libraries?

這篇關(guān)于使用 PDO 從 PHP 調(diào)用存儲(chǔ)過(guò)程到使用 INPUT 參數(shù)的 MSSQL Server的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！