Home php make friends MSSQL and PHP 7 +

make friends MSSQL and PHP 7 +

Author

Date

Category

It is necessary to raise the project written in Zendframework (it does not apply to the case, the project will correspond). MSSQL is used as database. Put the driver for PHP (php_sqlsrv_72_ts_x86.dll and php_pdo_sqlsrv_72_ts_x86.dll ). In phpinfo () it is shown that SQLSRV is connected, however:

  1. PHP swears on what does not know the functions MSSQL _ *
  2. via PDO Connect to the server also does not pass (SQLSTATE [08001]: [Microsoft] [ODBC Driver 13 for SQL Server] Provider of the named channels: Unable to open the connection to SQL Server [53] ) . – You can score on it, the main thing is that trying to connect.

Question: how to still improve the functions of MSSQL_ * in php

p.s. Answers about configuring drivers do not need to throw off, in phpinfo driver support is displayed


Answer 1

MSSQL _ * removed from PHP 7+ – https://secure.php.net/manual/en/function.mssql-connect.php

It is recommended to use PDO or SQLSRV _ *

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions