PHP & MS Sequel Server

http://www.aspfree.com/c/a/MS-SQL-Server/Using-PHP-with-MS-S QL-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 & MS Sequel Server

--=-uXo3EFUrA8ISaw6J6qb3
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Sun, 2010-01-17 at 10:47 -0800, dealtek wrote:

> http://www.aspfree.com/c/a/MS-SQL-Server/Using-PHP-with-MS-S QL-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



--=-uXo3EFUrA8ISaw6J6qb3--

Re: 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-S QL-
>> 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,
dealtek@gmail.com
[db-10]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: 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 dealtek@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-S QL-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,
> dealtek@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 & 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 wrote:
> http://www.aspfree.com/c/a/MS-SQL-Server/Using-PHP-with-MS-S QL-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 & 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, "dealtek@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-S QL-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,
> dealtek@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