On Sun, 2010-01-17 at 10:47 -0800, dealtek wrote: > http://www.aspfree.com/c/a/MS-SQL-Server/Using-PHP-with-MS-SQL-Server/ > > This article seems to sate that PHP can interface with MS Sequel Server > ? If so, is it about the same level of complexity as working with PHP & > MySQL? If one was to choose php & one DB over the other in a general > comparison (not cost): any preferences? > You can use PHP and MSSQL quite happily together on either Apache or IIS. I've found a few disadvantages to MSSQL other than the cost factor though: * MySQL is faster in the main for the sorts of things I've thrown at it * I've not found a phpMyAdmin equivalent, which means you'd have to use the non-web interface that MS gives you unless you want to open all sorts of ports to connect remotely * Depending on the version you may be missing out on certain features. I had to use a version of MSSQL once that had no LIMIT capabilities, only TOP, which made things a lot more difficult * PHP doesn't have a mysql_real_escape_string equivalent for MSSQL, which is used to sanitise data for insertion based on the character set being used. * MSSQL doesn't allow you to use different database engines for different tables, it only has the JET engine as far as I know, so you wouldn't be able to optimise on a table-by-table basis by using different storage engines. Thanks, Ash http://www.ashleysheridan.co.uk
