connect xampp to sql server 2020 | how to connect xampp to sql server

you [Music] hello everyone welcome to knowledge extension so today we will see the configuration or we can say that the connection of exam server with the Microsoft SQL Server so let's start first we download the exam server so open your browser and download the local server click on the first link here different versions are available so I'm going to select this one 7.2 and this is my operating system is 64-bit operating system you can find it here so download as per your system requirement yes here our downloading is started now actually the composition of Zam server or any local server with PHP MySQL it is very easy to configure in fact it comes with the built in package that is you can find out in the PHP myadmin there are in big SQL that is a my SQL okay that is very easy process but in the case of ms SQL server we need to install the driver we will see it our download is finished now so open and install it [Music] the installation process is very easy click on the next again this is our part this is beautiful language [Music] next okay guys this is now installing today's Microsoft provide the driver for PHP for SQL Server so we need to download it first after finish this example solution I will show you how to do it with the simple steps so don't worry about that we need to download and install SQL Server also and the most important part is we need the SQL Server management studio which is the most important thing in this part where we can create our database our user and we need to do the permissions we received little after this installation get finished [Music] it is ongoing now [Music] our installation is done click on the finish this is the control panel of zamp server so start the Apache after that open the admin so you will redirect to the local host this is our dashboard click on the PHP info here you will find the version of your PHP that is 7.2 so now we need to download the driver microsoft driver or PHP square search this here you will find the driver this is the SQL server driver actually this is the older version that is 4.0 so we need the different driver scene every second link here you will find the five version five see the 5.8 lettest driver download it and then click on the download file select key s we need to specify the path please play attention on this click on the Browse we need to navigate the exam folder first that is installed in C Drive then find out design folder this is ours am insert design folder click on the PHP then ext4 dot ok then click on it okay [Music] the DLL file automatically copied into that folder PHP then txt see that the NTS 64-year our version is CERN bun - so we need to attention on that the 72 and TS & TS 64 now click on the configure click on the PHP dot ini this is a fine open so simply press the ctrl + f Dave leaky over here it is extension is equal to sea here we are so we need to mention the dl file here copy that file name and paste it here first this 64-bit file copy this file lamp and paste in here best repeat this for another one extension is equal to here is our another file copy the name paste it here here we done our main bodies over now save this file and close it so we start the Apache just check it out it is working or not click on the admin this is our dashboard as I told you before sure now we need to download the SQL Server management studio you will find here you need to pick up the latest version of SQL Server management studio you can download it from here actually in my case I have already this file I have already installed the management studio this is my management studio certified if I'm going to reinstall it let's see I think there is no need to reinstall it okay fine but if you don't have it then you need to install it guys so download and install the management studio and they create the database and simple user I'll say though my database that is the simple test database I have created you need to enter the server name and the user and password expand this database folder you will find out the database here you need to create actually [Music] this is my database so let's check the it's working or not our project is reside in the htdocs folder so open it here we will create the connection file this is our project folder that is the test inside it we will create the connection for file PHP file in the connection file we need to specify the different parameters that is server name database name username use a password this is my password if the connection is successful then this message will be displayed if not then this message will be defied so let's check our connection is not working it is working restart it this is a localhost call our project and I hear your project name in my case there is a test you can copy it from here this is my project name basically you have to enter your project URL and this is my PHP file there is a connection file copy this and paste it here dot PHP extension and then click on that link see you guys the messages appear here so we have successfully configured our exam local server with the Microsoft SQL Server so test again by changing the values so it is not allowing the connection because I'm changing the username here then refresh this page and here is done [Music] okay guys I hope this will help follow you if you like this then don't forget to subscribe this channel thank you thank you so much

Channel: Knowledge Extension

Views: 45,998

Keywords: connect xampp to mssql, connect xampp to sql server, How to configure XAMPP to use with MSSQL, How to connect sql server with php using xampp, Installation of SQL Server drivers in a Xampp, How to connect MS sql database and php using xamp, sql server php xampp, configure xampp with sql server, connect sql server database with xampp, connect local server with sql server, mssql, xampp mssql, xampp sql server, configure xampp sql server, mssql connection with xampp

Id: 4qXXD4C2KSo

Length: 15min 54sec (954 seconds)

Published: Wed Apr 29 2020