CODEWITHSUNDEEP
phpsqlsqlcmd
Nick
Nick

Reputation: 348

Running sqlcmd from php

I have a pretty complicated bunch of sql calls that I have stored to a .sql file, that I can't call using sqlsrv_query because there are a bunch of GOs.

From the (windows) command line I can run the sql file using 

"path\to\sqlcmd" -U name -P pass -S loc -i "path\to\stuff.sql"

I can also write system( [all that] ) in a php file that I run from the command line using php -f.

However, if I call the same system( [allthat] ) from a php file that I call using ajax on a website, I get no feedback, the sql just doesn't run. I've checked sqlcmd, and it has permissions to allow all users to execute.

Any ideas?

Upvotes: 0

Views: 1245

Answers (2)

aF.
aF.

Reputation: 66727

For that, you may use the shell_exec.

Upvotes: 0

Marc B
Marc B

Reputation: 360782

Permissions issue. If you're running it from the command line, it's running under YOUR permissions. When you invoke it via a webserver, it's running with the webserver's permisisons. The webserver will need execute rights (and permission to REACH the sqlcmd) as well as read rights on the .sql file (and permission to reach it).

Upvotes: 1

Related Questions