如何在Windows上集成PHP和R


How to integrate PHP and R on Windows?

在集成PHP和r时遇到一些问题:

http://www.r-bloggers.com/integrating-php-and-r/

R已经安装并被验证与我们的R脚本一起工作:

Rscript C:'inetpub'wwwroot'client'includes'decisionTreePredictor.R 20 10 O 1000 10000 5000 0.2 10.2

打印其计算结果的单个值:

[1] "0"

(Rscript.exe的路径在Windows环境变量中设置)

我有一个PHP脚本,使用exec()成功测试命令,如:

$result = exec('dir',$output,$returnVar);
echo "<br>result ". print_r($result,true);
echo "<br>output <pre>". print_r($output,true) , "</pre>";
echo "<br>return ". print_r($returnVar,true);
返回:

result 2 Dir(s) 117,749,354,496 bytes free
output 
Array
(
    [0] =>  Volume in drive C is C_DRIVE
    [1] =>  Volume Serial Number is 7EB2-A074
    [2] => 
    [3] =>  Directory of C:'inetpub'wwwroot'client'temp
    [4] => 
    [5] => 05/17/2014  10:29 PM              .
    [6] => 05/17/2014  10:29 PM              ..
    [7] => 05/16/2014  09:24 AM             5,181 dbimporttest.php
    [8] => 05/17/2014  10:29 PM                 0 routput.txt
    [9] => 05/17/2014  11:42 PM               701 rscripttest.php
    [10] => 05/16/2014  04:59 PM               425 whoami.php
    [11] =>                4 File(s)          6,307 bytes
    [12] =>                2 Dir(s)  117,749,354,496 bytes free
)

return 0

当我尝试在exec命令中运行R脚本时,它失败了:

$result = exec('Rscript.exe C:'inetpub'wwwroot'client'includes'decisionTreePredictor.R 20 10 O 1000 10000 5000 0.2 10.2',$output,$returnVar);
echo "<br>result ". print_r($result,true);
echo "<br>output <pre>". print_r($output,true) , "</pre>";
echo "<br>return ". print_r($returnVar,true);
返回:

result 
output 
Array
(
)

return 1

I am running:

  • Windows Server 8 R2
  • php 5.5 3.1 R

无法使exec()工作或输出可用的错误,我决定寻找另一种途径。使用COM类似乎给了我我一直在寻找的东西。

这是最终的操作代码:

$command = 'C:'Program Files'R'R-3.1.0'bin'Rscript.exe C:'inetpub'wwwroot'client'includes'decisionTreePredictor.R 20 10 O 1000 10000 5000 0.2 10.2';
$pCom = new COM("WScript.Shell");
$pShell = $pCom->Exec($command);
$sStdOut = $pShell->StdOut->ReadAll;    # Standard output
$sStdErr = $pShell->StdErr->ReadAll;    # Error
echo "<pre>$sStdOut</pre>";

奇怪的是,我不能让exec()做这项工作,因为这似乎是大多数讨论R/PHP集成的博主首选的解决方案。

无论如何,我希望这个解决方案能帮助到任何和我一样的人!

注:您需要确保扩展在php.ini中打开(安装时默认关闭):extension=php_com_dotnet.dll