SQL Server and PHP

[gregor7777]

Hey all,

So I'm running on a windows server box. It has SQL Server installed and I want to use PHP.

Now I'm used to programming with PHP/MySQL, using MySQL Front as a graphical database tool and so on.

I have no choice but to use SQL Server now though, and I'm wondering what I might need to know. I have no control over the box from a config standpoint, but as far as I know there hasn't been an issue with the PHP/SQL Server combo on this server in the past.

Anyone have any tips/suggestions? Bascially just looking for some good info to get me started as far as setting up the DB and so on. Most google results talk about server config options.

tia

 

[joshg]

For PHP MS SQL functions:

http://www.php.net/manual/en/ref.mssql.php

For managing SQL database folks usually use the "Query Analyzer" tool. There's a new tool that came out but I don't remember what it is called... SQL Server Manager? Not really but it is ok too...

Also some folks use this, but I've never tried it

http://www.microsoft.com/downl...cb7f959&displaylang=en

 

[gregor7777]

Originally posted by: joshg
For PHP MS SQL functions:

http://www.php.net/manual/en/ref.mssql.php

For managing SQL database folks usually use the "Query Analyzer" tool. There's a new tool that came out but I don't remember what it is called... SQL Server Manager? Not really but it is ok too...

Also some folks use this, but I've never tried it

http://www.microsoft.com/downl...cb7f959&displaylang=en

Cool, thanks. I found that VS 2005 has a little tool in there as well. Though it sucks compared to MY SQL Front.


Having issues connecting to my SQL Server database, but I think it may be a config issue.

 

[Beau]

Originally posted by: gregor7777

Originally posted by: joshg
For PHP MS SQL functions:

http://www.php.net/manual/en/ref.mssql.php

For managing SQL database folks usually use the "Query Analyzer" tool. There's a new tool that came out but I don't remember what it is called... SQL Server Manager? Not really but it is ok too...

Also some folks use this, but I've never tried it

http://www.microsoft.com/downl...cb7f959&displaylang=en

Cool, thanks. I found that VS 2005 has a little tool in there as well. Though it sucks compared to MY SQL Front.


Having issues connecting to my SQL Server database, but I think it may be a config issue.

Toad for SQL Server is a much better tool, though it's a little slow.

 

[BChico]

I actually was working on a small web app recently where I wasn't able to connect to a SQL Server DB using PHP due to the way the security was setup on our domain. I ended up using ASP with Integrated Secuirty setup on the IIS, and it actually worked pretty well. Downside, ASP is not even close to as versatile as PHP, and ASP does not natively run on Apache.