<?php
     if(isset($_POST['update'])) {
        $server = "WIN-2012SRV-BK";
        $user = "sa";
        $pass = "";
        $db = "UTSMSVFT_LIVE";
        $connInfo = array("Database"=>$db, "UID"=>$user, "PWD"=>$pass);
        $conn = sqlsrv_connect($server, $connInfo) or die( print_r( sqlsrv_errors(), true));



        //$pin = $_POST['pin'];
        $phone = $_POST['phone'];

        $sql = "UPDATE UTSMSVFT_LIVE.switch.Subscriptions SET pin='*',status='pending' WHERE phone = ?" ;
        //$sqlsrv_select_db('test');
        $params = array($_POST['phone']);
        //$sqlsrv_query($conn, $sql, $params);
        $stmt = sqlsrv_query($conn, $sql, $params);

        //$stmt = sqlsrv_query( $conn, $sql, $params);

    if( $stmt === false ) {

        die( print_r( sqlsrv_errors(), true));

    }
        else

    {

        echo "Record update successfully";

    }
     }