3 ms·
I just started a job where mssql is used extensively. They're trying to get a PHP 7 application off the ground and the lack of a mssql driver (non-PDO) for PHP
by arenaninja 11y ago
I just started a job where mssql is used extensively. They're trying to get a PHP 7 application off the ground and the lack of a mssql driver (non-PDO) for PHP 7 is a big pain point. As of Jan 2016, they had released a beta release and were taking a poll on what platform they should support next (I'm not kidding, the entire history is here: https://github.com/Azure/msphpsql/issues/58 https://github.com/Azure/msphpsql/issues/58). Unfortunately it seems support is secondary in this case to Microsoft, as they are unable or unwilling to allocate the necessary resources
- 1812Overture 11y agoWhy are they avoiding PDO? Seems like that's what people should be moving towards in terms of flexibility and security.
- e12e 11y agoThat struck me as odd too (I'm not really up to date on php7, and haven't considered php on windows in at least a decade). But perhaps it's because the PDO-driver is built on the old TSQL-interface, and MS own drivers haven't been ported to php7 yet (not with a stable release, anyway) ? http://php.net/manual/en/ref.pdo-dblib.php http://php.net/manual/en/ref.pdo-dblib.php https://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx https://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx https://github.com/Azure/msphpsql/tree/PHP-7.0 https://github.com/Azure/msphpsql/tree/PHP-7.0
- arenaninja 11y agoI've used and liked PDO myself in the past. The issue is that even though the application would pretty much simply run on PHP7 (since it runs on 5.6 already) if MS had a compatible driver instead of contemplating a re-write