WIKI de apuntes de Billy Rondón

Esta página es de solo lectura. Puedes ver la fuente pero no puedes cambiarla. Pregunta a tu administrador si crees que esto es incorrecto.
====== PHP PDO ======

Mi configuración en PHP 8

===== Instalación XAMP ======

Problemas con UAC
  * [[http://cursos15.blogspot.com/2018/01/xampp-desactivar-uac.html]]

==== PDO SQL SERVER en PHP 8.0 ====

  * [[https://stackoverflow.com/questions/65687871/could-not-find-driver-sqlsrv-php-8-0-1]]

Download SQLSRV59.EXE from Microsoft Drivers 5.9 for PHP for SQL Server is the latest general availability (GA) version

You will have to execute the file that you download and later copy the .dll files that correspond to the version you require inside the folder
<code>
C:\xampp\php\ext
</code>
I copy the next files (my windows is x64 and PHP 8.0.3)

<code>
php_pdo_sqlsrv_80_nts_x64.dll
php_pdo_sqlsrv_80_ts_x64.dll
php_sqlsrv_80_nts_x64.dll
php_sqlsrv_80_ts_x64.dll
</code>

In this download you will find .dll x86 and x64

<code>
php_pdo_sqlsrv73
php_pdo_sqlsrv74
php_pdo_sqlsrv80
</code>

I installed the Microsoft SQL Management Studio 18 but in case of not installing it you will need the

Microsoft ODBC Driver 17 for SQL Server

In the window XAMPP Control Panel search the CONFIG button the Apache Module, and select the option PHP (php.ini)

add this lines (according to the names of the .dll files that you copied inside the folder)

SEARCH in php.ini the section EXTENSIONS
<code>
; Mi CONFIGURACIÓN SQL SERVER
extension=php_pdo_sqlsrv_80_nts_x64.dll
extension=php_pdo_sqlsrv_80_ts_x64.dll
extension=php_sqlsrv_80_nts_x64.dll
extension=php_sqlsrv_80_ts_x64.dll
</code>
save the file and restart the apache server. press the stop button and then start