"weblogin", //or sa "PWD" => "password", //or sa's password but not recommended "Database" => "MyDatabase" ); $conn = sqlsrv_connect($server, $options); if ($conn === false) die("
".print_r(sqlsrv_errors(), true));
	print "Successfully connected!

";


$sql = "SELECT * FROM orders";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
  exit("
".print_r(sqlsrv_errors(), true));
}

while ($row = sqlsrv_fetch_array($query))
{
  print "id = ".$row[id]."
";
  print "customer = ".$row[customer]."
";
  print "product = ".$row[product]."
";
  print "quantity = ".$row[quantity]."

";
  
}

$sql="SELECT convert(varchar,day_of_order,101) as mydate FROM orders";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
  exit("
".print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($query))
{
	print "date = ".$row[mydate]."
";
}

print "
";

$sql="SELECT convert(varchar,day_of_order,121) as mydate FROM orders";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
  exit("
".print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($query))
{
	print "date = ".$row[mydate]."
";
}

print "
";

$sql="SELECT customer, convert(varchar,day_of_order,121) as mydate FROM orders";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
{
  exit("
".print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($query))
{
	print "customer = ".$row[customer]."
";
	print "date = ".$row[mydate]."

";
}

sqlsrv_free_stmt($query);
sqlsrv_close($conn);

?>