php script with mssql and mysqli - cannot run from command line

[BobJ]

I have a php script that used mysqli and mssql (as in php version 5.6)
When I run the script from a browser it runs fine (WebStation).
But if I run it from either a terminal command line or run it as a user-defined scheduled script (in Task Scheduler) it returns mysqli and mssql not found errors.
I have enabled both of these extensions within the WebStation settings.

I already tried command line running php56 from these directories, but still no luck:
/bin/php
/var/packages/PHP5.6/target/usr/local/bin/php56

I need to run the script periodically using Task Scheduler.

Clearly the script can work, but by running it via the command line must load php in a different way.
How does WebStation run php? and can I reproduce that via command line?

How can I find out the path used to run php from within a browser? If I knew that I could probably replicate it in the command line?

Note - already seen this old post:

Synology Community

Hi! Come and join us at Synology Community. A place to answer all your Synology questions. Ask a question or start a discussion now.

community.synology.com

 

[BobJ]

A reply to my own question! ...
Found a work-around...
run this as bash script in Task Scheduler (e.g.)
curl http://diskstation/folder1/example.php

a bit of a messy solution, but at least it works.

 

[Deleted member 673]

Welcome! Good to meet a fellow PHPer on SynoForum. Thank you for posting the work-around. This will be very useful in an upcoming project.

Just to be clear, does "folder1" refer to an optional sub-folder inside the "web" shared folder required by Web Services?

Is it safe to assume your script updates databases, files, logs, etc. but does not produce any "echo" output?

Best Regards, Ron

 

[BobJ]

Hi Ron
re. question 'folder1' - yes, just a path to a file.
My scripts do have echo statements but they have no affect.
Also, clearly, the 'curl' extension needs to be enabled.
It would be nice to know the 'correct' solution to this problem though,
rather than bypassing it like this (anyone?)

B.

 

[Deleted member 673]

Thanks. Your solution is running just fine here as of this morning. Certainly adequate for a retiree's hobby project. Hope you enjoy the forum. Ron