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...
Sur cette page du site, vous pouvez voir la vidéo en ligne MS SQL Server and PHP (Apache) stack setup tutorial (Windows) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Jon Buder 27 décembre 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,027 fois et il a aimé 12 téléspectateurs. Bon visionnage!
