Using SQLSRV extension in PHP CLI script

Question

folks!

This is my first experience with big scripts in PHP CLI and I'm facing a 'not found' error when using the sqlsrv_connect function in my script. Running the script in the browser is okay, connects all fine, the queries goes as fine as it could; but when in the CLI, my friend, it shows

Fatal error: Call to undefined function sqlsrv_connect()

What could it be, dark magic or newbie developer?

This is how i use the function:

$_dbip = '127.0.0.1';
$_dbnome = $nome_bd;
$_dbuid = 'sa';
$_dbpwd = 'very_strong_secret_pwd';

$conn = sqlsrv_connect($_dbip, array('Database' => $_dbnome, 'UID' => $_dbuid, 'PWD' => $_dbpwd)) or die( print_r( sqlsrv_errors(), true));

Thanks in advance!

Can you post your PHP code? May help others determine what the issue is. — Haymaker, Jan 05 '16 at 19:58
Just edited the question, adding the code. It's very simple, though. — Ivan Cézanne, Jan 05 '16 at 20:04

score 1 · Answer 1 · answered Jan 05 '16 at 20:05

1

There are two php.ini files , one for the CLI and one for the Web browser.

You need to make sure the extension is enable on both.

You should use PDO if possible, because it is a better extension and it supports SQL server.

answered Jan 05 '16 at 20:05

meda

45,103
14
92
122

Really? I just got one `php.ini` in my installation, is that right? If not, where I should probably find the CLI `php.ini` – Ivan Cézanne Jan 05 '16 at 20:10
@IvanCézanne you running PHP on linux or windows – meda Jan 05 '16 at 20:10
Nope, ain't working out. Just got a single `php.ini` and it got the extensions activated correctly. – Ivan Cézanne Jan 05 '16 at 20:23
@IvanCézanne Im pretty sure you have 2, but you can force it like this http://stackoverflow.com/a/3057474/1880431 – meda Jan 05 '16 at 20:30

score 0 · Accepted Answer · answered Jan 05 '16 at 20:59

0

Just realized that the PDO version of SQLSRV was the one activated. I really just got a single php.ini file and simply added a new line declaring the SQLSRV without the PDO.

Thanks for the help, still!

answered Jan 05 '16 at 20:59

Ivan Cézanne

78
1
11

Using SQLSRV extension in PHP CLI script

2 Answers2