Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

SQL Sever Connection

To establish SQL Server connection microsoft dirvers are require. Based on the PHP version the supported microsoft drivers are required. Download microsoft drivers.

  
After download, Which files are required?
To know about this, we need php info page. Write a code for display php information.

Open the php file into browser.


Find the required extension files.

Copy the required files into the PHP folder.



Add those file names to configuration setting file.




Write a php code to connect SQL Server.



Place that php file into the database location.



Access that php file from browser to establish connection to SQL Server.



Insert the data into the database using php.
Write a php code to insert the data into the SQL Server database.


Place the php file into the server database location.


Access the file from browser.



Check whether the data is inserted into the database or not.


User credentials validation using php and ms sql.

 Code:

 Login.html

Login.php

Connection.php


Output:





Create a signup page and store the data which was posted by signup page into a database.

 Code:

 Signup.html:

Signup.php:


Output:





Display all users stored in the users table using php and ms sql.

 Code:

Output:





Subscribe to: Posts (Atom)