Posts

Showing posts with the label Ms SQL Server

Use Sql server With php

            To connect Ms SQL Server  In PhP Note: This is working in the Go-daddy  windows server No setting Required       if  use in the local they are some setting required in Php.ini and add  mssql.dll in  xamp or wamp server. Connect.Php <?php $server = Server Name/IP; $options = array( "UID" => "Username",  "PWD" => "Password",  "Database" => "DbName"); $conn = sqlsrv_connect($server, $options); ?> Note: Can't Close The Connection At Last.                   To Execute the Store Procedure In Php Web services Web_services.php <?php include("connect.php");     // Connection File Include Here     header('Content-Type:application/json;charset=utf8');   header('Access-Control-Allow-Origin: *');   header('Access-Control-Allow-Methods:GET,PUT,POST,DELETE,OPTIONS');   head

create table type in sql server and insert Update data using store procedure

Demo.aspx  < html > < head > < title > Pass Data Table </ title > < script src ="js/jquery-1.3.2.min.js" type ="text/javascript"></ script >     < script type ="text/javascript">         $(document).ready( function () {             $( '# <% =dropproduct.ClientID %> ' ).change( function () {                 var result = $( '# <% =dropproduct.ClientID %> ' ).val().split( ',' );                  if ($( '# <% =dropproduct.ClientID %> ' ).val() == "---Select---" ) {                 }                 else {                     $( '#detail' ).html( '' );                     var str = "" ;                     str = str + "<div style=\"margin-top: -200px;border-radius: 0.5em;font-size: 14px;background-color: aliceblue;margin-bottom: 100px;width:400px \"><table style=\"