How to connect to SQL Server database through PHP?

Question

I'm building a web-service for an Android application that needs to connect to a SQL Server database. I'm trying to connect through PHP (WAMP) on my home computer to the SQL Server database.

However, I don't have experience SQL Server and don't know how to proceed. For SQL Server, I'm using default settings and Windows Authentication, so I'm not sure what to type into the connection string.

Below you have my connection:

$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB; 
$conn->open($connStr); //Open the connection to the database

I haven't found a concrete example anywhere so far, so I need to know what the variables $myServer, $myUser etc. need to be in the case of Windows Authentication.

Alternatively, how can I switch to a User-Name and Password Authentication in SQL Server?

LE: Using Microsoft SQL Server 2008 and SQL Server Management Studio

Dmitry Kudryavtsev · Accepted Answer · 2012-02-12 14:55:28Z

4

PDO is the accepted way to connected to different databases in PHP. It also have a driver for MS-SQL

Here is an example (From PDO MSSQL)

$con = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

answered Feb 12, 2012 at 14:55

Dmitry Kudryavtsev

17.7k4 gold badges27 silver badges32 bronze badges

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

3 Comments

Eugen Over a year ago

I'm sorry...I'm quite the noob when it comes to these. So...I'll ditch my current attempt and go with PDO. And for that I'll need to install another driver for PHP, just like I installed the Microsoft one, right? :D

Dmitry Kudryavtsev Over a year ago

First of all check for support by running phpinfo(); You should see something like "PDO support enabled" "PDO drivers dblib, mysql, odbc, pgsql, sqlite, sqlite2" Now Im not sure but you need either dblib or sqlsrv (one of them is for *nix and one for windows afaik), if its there you can just use it, if its not then you need to add the appropriate .dll to php.ini in you server (wamp), look for something like: extension=php_pdo_mssql.dll (should be commented I guess) I work with linux so can't help you with the exact location of the files and extensions under windows. Good Luck :)

Dmitry Kudryavtsev Over a year ago

Here is a thread from wamp's server site this might be a good starting point. Also feel free to move this discussion to chat I can try to help you there

Kenny Linsky · Accepted Answer · 2012-10-02 17:30:14Z

2

Microsoft made a driver for PHP, but I think it's better to go with PDO.

You can use PDO_SQLSRV:

$dbh = new PDO("sqlsrv:Server=$hostdb;Database=$dbname", $usr, $psw);

Or use PDO_DBLIB (not available on Windows since PHP 5.3):

$dbh = new PDO("dblib:host=$hostdb;dbname=$dbname", $usr, $psw);

edited Oct 2, 2012 at 17:30

Kenny Linsky

1,7963 gold badges17 silver badges42 bronze badges

answered Feb 12, 2012 at 14:57

iDifferent

2,2101 gold badge15 silver badges19 bronze badges

Comments

karthik · Accepted Answer · 2013-10-08 11:21:05Z

0

In a related note, the same fate awaits the mysql* extensions if people will ever stop insisting on using them (and the terrible "tutorial" sites stop advocating them) instead of the vastly superior PDO extension. – rdlowrey Feb 12 '12 at 14:58

answered Oct 8, 2013 at 11:21

karthik

111 bronze badge

Comments

kleopatra · Accepted Answer · 2013-10-08 11:25:37Z

0

$dbh = new PDO("sqlsrv:Server=$hostdb;Database=$dbname", $usr, $psw);

edited Oct 8, 2013 at 11:25

kleopatra

51.6k28 gold badges103 silver badges220 bronze badges

answered Oct 8, 2013 at 11:24

karthik

111 bronze badge

Comments

Kenny Linsky · Accepted Answer · 2012-10-02 17:28:36Z

-1

According to: http://www.php.net/manual/en/function.mssql-connect.php,

mssql_connect($servername, $username, $password)

is how you connect to a Microsoft SQL database.

edited Oct 2, 2012 at 17:28

Kenny Linsky

1,7963 gold badges17 silver badges42 bronze badges

answered Feb 12, 2012 at 14:53

AMayer

3351 silver badge7 bronze badges

3 Comments

iDifferent Over a year ago

This extension is not available anymore on Windows with PHP 5.3 or later. php.net/manual/en/intro.mssql.php

user895378 Over a year ago

RTFM answers should be comments, not answers.

user895378 Over a year ago

In a related note, the same fate awaits the mysql* extensions if people will ever stop insisting on using them (and the terrible "tutorial" sites stop advocating them) instead of the vastly superior PDO extension.

Collectives™ on Stack Overflow

How to connect to SQL Server database through PHP?

5 Answers 5

3 Comments

Comments

Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related