"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
$sql = "INSERT INTO domains (domain, sex, mail) values('123xyz.com', 'F', 'sharp@adomain.com')";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
exit("".print_r(sqlsrv_errors(), true));
} else {
print "1 row inserted";
}
sqlsrv_free_stmt($query);
sqlsrv_close($conn);
//checking: select * from domains
?>