Link to home
Create AccountLog in
Avatar of AccessYourBiz_Com
AccessYourBiz_ComFlag for United States of America

asked on

PHP and SQL Server

I am new to PHP programming and have traditionally worked with Microsoft Access and Microsoft SQL. However when reading information on PHP development using NetBeans of Zend or Eclipse PDT they all seem to mention MySQL and not Microsoft SQL. I like the idea of using Microsoft SQL because I am familiar with it and it enterprise features. Is it not recommended to use Microsoft SQL with PHP? Will NetBeans IDE support it?
ASKER CERTIFIED SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Don't know about NetBeans, but there is no reason you cannot use MS SQL.  It is supported with a rich collection of functions:
http://us.php.net/manual/en/ref.mssql.php
Interesting sidebar notes here:
http://us.php.net/manual/en/mssql.installation.php
http://us.php.net/manual/en/mysql.installation.php

It appears that they both require some effort to install them.
Avatar of AccessYourBiz_Com

ASKER

Thanks Guys.

Olaf, does MySQL have enterprise features like a server cluster that MS SQL has?

Ray, all things being equal, is it really just as simple as a using the MS SQL driver and everything else works that same? There are a bunch of PHP IDEs that mention MySQL by name and how those databases are visible within the IDE, would this be true for MS SQL once the driver is installed...if I was using Eclipse or Zend?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If you're after that kind of features of SQL Server, then PHP isn't your language, use ASP.NET in conjunction with MS SQL Server clusters.

On the other side: Yes, there is database clustering in MySQL - http://www.mysql.com/products/cluster/

Bye, Olaf.
Some NetBeans notes here.  I am not competent to evaluate the quality of the information, but at least the topic has been addressed.
http://wiki.netbeans.org/AccessMssql
Well done guys! Thanks so much!!
Note that Microsoft has produced their own PHP driver for Microsoft SQL :  http://www.microsoft.com/sqlserver/2005/en/us/php-driver.aspx  In other questions here, people have recommended using it because the old php_mssql driver isn't supported anymore.
@DaveBaldwin:  Good catch - I had not seen that!  Thanks, and Happy New Year, ~Ray
Happy New Year to you too Ray!
Good advice, Dave. Thanks.
Yes, Thanks Dave. Happy New Year to all.