Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Using PHP with MySQL Querying the Database with PHP Querying the Database

Posted by Daniel Boyd
Daniel Boyd
3,662 Points

If you had to use a MS SQL database instead of My Sql, what would the connection line be?

I am struggling to work out how to use PHP to connect instead to an MS SQL database.

1 Answer

Gareth Borcherds
Gareth Borcherds
9,372 Points
Gareth Borcherds
Gareth Borcherds
9,372 Points

You're going to use a different command. Take a look at http://php.net/manual/en/function.sqlsrv-connect.php to help get you started.

I'd also recommend looking at some classes that help you do this a little easier than trying to manually write all the connection and everything each time you need. But the link above should help you get started with connecting to a sql server.

Daniel Boyd
Daniel Boyd
3,662 Points

Thanks for the heads up Gareth. I will have a look through there.