execute R script from php

Question

I am trying to execute R script from Php. It works fine with the command prompt with this :

 Documents\R\R-3.5.0\bin\R.exe Desktop\my_script.R

But the same is not working from PHP call using exec. Any suggestion please!

<?php 
   exec("Documents\R\R-3.5.0\bin\R.exe Desktop\my_script.R", $output);
   print_r($output);
?>

print_r($output) displays only "Array()" no correct result ;

place ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(-1); before the exec() and see if it outputs any errors — treyBake
– treyBake, Commented Nov 6, 2018 at 12:36
Thanks! I get an error saying "The system cannot find the path specified." I am using this below C\Users\"myName"\Documents\R\R-3.5.0\bin\R.exe Desktop\my_script.R may be it might need pwd? same path is what I am getting a result in cmd prompt — user3280899
– user3280899, Commented Nov 6, 2018 at 12:44
not sure with Windows machines ... see if it works if the .R script is in the same place as the exec script (and change path accordingly) — treyBake
– treyBake, Commented Nov 6, 2018 at 12:45

Theo Emms · Accepted Answer · 2018-11-06 13:14:00Z

1

Those paths must be relative to the php working directory. Otherwise they must be fully specified:

Try:

$cmd = "C:\Users\YOURNAME\Documents\R\R-3.5.0\bin\Rscript.exe C:\Users\YOURNAME\Desktop\my_script.R";
exec($cmd, $output);

edited Nov 6, 2018 at 13:14

answered Nov 6, 2018 at 12:49

Theo Emms

3021 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

user3280899 Over a year ago

I get this error with the proper path now: Array ( [0] => ARGUMENT 'Desktop\my_script.R' ignored [1] => [2] => [3] => R version 3.5.0 (2018-04-23) --

Theo Emms Over a year ago

Do you have a program called Rscript in C:\Users\YOURNAME\Documents\R\R-3.5.0\bin\?

user3280899 Over a year ago

Yes, I do have RScript in the same path. I use the same from cmd prompt and I get answer correctly..

Theo Emms Over a year ago

Try the updated answer - if it still doesn't work let me know

user3280899 Over a year ago

I get nothing. No error message in php error_log file. my_script.R file creates two files 1.Rdata 2. plot png file Also I tried to keep this my_script.R file from different folders like Desktop folder, document folders also used C:\wamp64\www\my_script.R.... all produces nothing.... but works fine from cmd prompt. But i need to execute this script from php. Thanks for your time.

|

Collectives™ on Stack Overflow

execute R script from php

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related