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...
На этой странице сайта вы можете посмотреть видео онлайн MS SQL Server and PHP (Apache) stack setup tutorial (Windows) длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Jon Buder 27 Декабрь 2023, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 1,027 раз и оно понравилось 12 зрителям. Приятного просмотра!
