Hi,
I am pretty new to PHP and am a bit stuck.
I am working on calling a stored procedure in MSSQL using PHP. My PHP is running on Linux and my MSSQL database is running on Windows. I am using php_odbc to connect. I need to fix the obdc_execute commands in my script. I don't have them right.
Here is my old call that worked with mssql:
$sp = mssql_init("sp_encrypt_text"); // stored proc name
mssql_bind($sp, "@unencrypted", ($extpassword), SQLVARCHAR, false, false, 255);
mssql_bind($sp, "@return_encrypted", ($extpassword), SQLVARCHAR, true, false, 255);
mssql_execute($sp);
How do I change the mssql_init, mssql_bind and mssql_execute statements into odbc_execute statements?
Does anyone know?