example

"weblogin", //or sa "PWD" => "password", //or sa's password but not recommended "Database" => "sample" ); $conn = sqlsrv_connect($server, $options); if ($conn === false) die("

". print_r(sqlsrv_errors(), true));
	print "Successfully connected!

";

//create sample.domains table first
//can add code here to check if a row exists first 
$sql = "UPDATE domains SET domain='xyz.com' WHERE domain='123xyz.com'";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
  exit("".print_r(sqlsrv_errors(), true));
} else {
	print sqlsrv_rows_affected($query)." row affected";
}
	
sqlsrv_free_stmt($query);
sqlsrv_close($conn);
//checking: select * from domains
?>