PHP and SQL express 2005

[tefnut]

I'm in the embryonic stages of learning PHP and have been used to ASP and SQL 2005 express for data driven stuff. My question is can you create SQL Express 2005 driven PHP pages?

[chazzy]

I think you have to do it very similar to how you do it w/ ASP. It still needs to be running over IIS, with IIS providing the data source (or configure apache to use the SQL server as a data source). it might be best to use the pear libraries to connect to the data source. There are built in sql server functions as well, if you want to use them: http://www.php.net/manual/en/ref.mssql.php but the bare minimum is to set it up as a data source - it'll work so much easier.

[rch10007]

The recently released SQL Server 2005 Express will work with MSSQL functions:

http://us2.php.net/manual/en/function.mssql-connect.php