Working with MS SQL SERVER on PHP5.6

Question

So I have a trouble here. Tried use mssql_connect() but interpeter says that function is undefinied. PHP.net advices this, but it suppports only older versions of PHP. Is it possible to connect to MS SQL Server database from PHP5.6? What extensions should I add, what functions can I use?

Configuration details: localhost, Apache 2.4, PHP 5.6, OS Windows 8.

DJ' · Accepted Answer · 2014-09-14 12:13:11Z

1

You need to enable the MSSQL extension in the PHP.ini file.

If this extension is not installed, you need to install it in PHP.

Please tell your server details (OS/WebServer like apache nginx) so that I can explain in detail.

answered Sep 14, 2014 at 12:13

DJ'

1,7781 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Frankie Drake Over a year ago

Generally I know how to add extensions to php.ini, but Microsoft released extensions only for PHP 2.2-2.4. I use Apache 2.4 on localhost

DJ' Over a year ago

localhost? You are using Windows or Linux?

DJ' Over a year ago

XAMPP or WAMP server? or you installed Apache and PHP on your own?

DJ' Over a year ago

First you need to install this extension dll in PHP then enable the extension from php.ini

Frankie Drake Over a year ago

I installed manually PHP and Apache. What extension should I use if Microsoft gives only extensions for PHP5.3 and PHP5.4?

|

RN Kushwaha · Accepted Answer · 2014-09-14 12:28:05Z

0

Use

 <?php phpinfo();?>

to see what are available with your php installation. I advice you to use PDO instead of mysql_* functions. It supports several databases not only MSSQL or MySQL.

answered Sep 14, 2014 at 12:28

RN Kushwaha

2,1343 gold badges30 silver badges41 bronze badges

6 Comments

DJ' Over a year ago

mysql_* functions are not used, mssql_* functions are used.

RN Kushwaha Over a year ago

What do you mean by mysql_* are not used? One who uses mysql use mysql_* functions, mssql users may use mssql_* functions. What is wrong with this answer?

DJ' Over a year ago

He asked in the question Tried use mssql_connect() not mysql

RN Kushwaha Over a year ago

I only suggested to not use mysql_ or mssql_ functions. Instead use pdo which provides support for several databases.

Frankie Drake Over a year ago

Can u give me please the link where I can download the extension?

|

Collectives™ on Stack Overflow

Working with MS SQL SERVER on PHP5.6

2 Answers 2

6 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related