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...
In questa pagina del sito puoi guardare il video online MS SQL Server and PHP (Apache) stack setup tutorial (Windows) della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Jon Buder 27 dicembre 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,027 volte e gli è piaciuto 12 spettatori. Buona visione!
