Ampersand in password problem - php

Question

Pretty much what the title says. I am trying to connect to a Microsoft SQL Server database with a password that contains an ampersand:

<?php
    $mssqlHost = "Reports.autotask.net,1433"; 
    $mssqlUser = 'NetworkROI';
    $mssqlPass = 'Rosdcpe7&Essdcscpalda'; //has been changed
    $mssqlATDB = 'TF_3745000_WH';
    $SQLConnect = mssql_connect($mssqlHost,$mssqlUser,$mssqlPass) 
        or die('Could not connect to SQL Server on '.$mssqlHost
        .' '. mssql_get_last_message());
?>

For a possibly related question: I get error 101 (net :: ERR_CONNECTION_RESET): Unknown error. "when I try to connect.

How can I avoid this?

Jonesi

Answer 1

HTTP-, GET, , URL-. POST HTTPS.

SQL-. SQL:

SELECT ... FROM Accounts WHERE user = 'Jonesy' AND password = 'M&Ms are tasty'

:

SELECT ... FROM Accounts WHERE username = ? AND password = ?

, . SQL- - .

---

:

, Google Chrome -, , -, - .

, , , .