MS SQL Server and PHP (Apache) stack setup tutorial (Windows)
In this tutorial, we go into setting up MS SQL Express edition, SQL Server Management Studio, XAMPP (just Apache and PHP), and VS code. Finally, we create configure a sample database and test run some PHP code to connect to it.
This serves as a complete web development workstation VM, DB server and web server. We use an AWS EC2 instance, but the same could easily apply to an on-premises Windows Server, or even Windows 10 or 11 desktop computer. There's nothing discussed here that strictly requires a server version of Windows, although the stability and reliability is likely to be a bit higher compared to the desktop versions.
If you use EC2, there's various considerations regarding cost. You could use instance savings plans or spot instances, etc. According to AWS's calculator today, the on-demand t2.large like I used in the tutorial would cost $90.58 per month with 30GB of EBS storage. I'd highly recommend testing a smaller instance type and using some kind of savings plan.
SQL Server downloads:
https://www.microsoft.com/en-us/sql-s...
Link to the PHP drivers for SQL Server for Windows:
https://learn.microsoft.com/en-us/sql...
XAMPP:
https://www.apachefriends.org/downloa...
Dynamic driver loading string for XAMPP php.ini:
extension=sqlsrv_82_ts_x64
Make sure you turn on SQL Server & Windows Authentication for the instance.
User: tut_user
Password: password
DB name used in video: "tutorial"
Make sure you add at least db_reader access to the "tutorial" DB for the tut_user account.
Table used: "people"
Fields:
ID - int (identity)
FirstName - varchar(50) - not null
LastName - varchar(50) - not null
FavoriteColor - varchar(50) - null
Sample PHP code for connecting to the DB, with the credentials and DB/table names used in the tutorial:
https://github.com/jonbuder/sql-serve...
En esta página del sitio puede ver el video en línea MS SQL Server and PHP (Apache) stack setup tutorial (Windows) de Duración hora minuto segunda en buena calidad , que subió el usuario Jon Buder 27 diciembre 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,027 veces y le gustó 12 a los espectadores. Disfruta viendo!
