[Solved] How to convert mysql function into sqlsrv? [closed]

by


You are missing the connection parameter to sqlsrv_query. While you’re at it, you might as well use bind variables instead of string substitution to help guard against SQL-Injection attacks.

$serverName = "serverName\instancename";
$connectionInfo = 
    array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);

$params = array($username, $password);
$stmt = sqlsrv_query
            ($conn, 
            'select * from sessions where password=? AND  username=?', 
            $params);

solved How to convert mysql function into sqlsrv? [closed]