[PHP] PHP MS Sequel Server
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? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MS Sequel Server
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
Re: [PHP] PHP MS Sequel Server
On Jan 17, 2010, at 11:06 AM, Ashley Sheridan wrote: 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 so much Ashley for the clear - quick response!!! The project in question is a pre existing site in .asp and MS SQL Server . The owner was inquiring as to adding additional modules (and small satellite websites) - most of which will not intersect with .asp but might use the MS SQL Server database... I suggested they find an .asp programmer but they might want PHP ... Thanks, deal...@gmail.com [db-10] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MS Sequel Server
you can use php with mssql2005. But infact that mysql is more suit than mssql in php environment. 2010/1/18 deal...@gmail.com deal...@gmail.com: On Jan 17, 2010, at 11:06 AM, Ashley Sheridan wrote: 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 so much Ashley for the clear - quick response!!! The project in question is a pre existing site in .asp and MS SQL Server . The owner was inquiring as to adding additional modules (and small satellite websites) - most of which will not intersect with .asp but might use the MS SQL Server database... I suggested they find an .asp programmer but they might want PHP ... Thanks, deal...@gmail.com [db-10] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MS Sequel Server
I use PHP with MSSQL right now. PHP is on Linux, MSSQL is on Windows. Just use the FreeTDS libraries to connect. On Sun, Jan 17, 2010 at 10:47 AM, dealtek deal...@gmail.com 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? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MS Sequel Server
Asp blows chunks when compared to php. Poor array handling, no built in image handling etc. Better to rewrite the site than to keep using 15 year old tech that is not really being supported by Microsoft. Bastien Sent from my iPod On Jan 17, 2010, at 2:27 PM, deal...@gmail.com deal...@gmail.com wrote: On Jan 17, 2010, at 11:06 AM, Ashley Sheridan wrote: 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 so much Ashley for the clear - quick response!!! The project in question is a pre existing site in .asp and MS SQL Server . The owner was inquiring as to adding additional modules (and small satellite websites) - most of which will not intersect with .asp but might use the MS SQL Server database... I suggested they find an .asp programmer but they might want PHP ... Thanks, deal...@gmail.com [db-10] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
