PHP sqlsrv_query select statement not working

Question

I want to make a consult to the MSSQLSERVER with a SELECT STATEMENT but the sqlsrv_query is returning FALSE to me.

I already tested the query and its working fine, am I passing the parameters correctly?

Here is my code:

    if($conn === false)
    {
        die(print_r(sqlsrv_errors()));
    }


     try
        {
$email = "[email protected]";
            $sql = "select Usuario.Email, Usuario.Senha FROM Usuario WHERE Usuario.Email = (?)";

            $params = array($email);

        $stmt = sqlsrv_query( $conn, $sql, $params);

if($stmt != False)
        {
            if($row = sqlsrv_fetch_Array($stmt))
            {
                $email_Con = $row['Email'];
                $psw_Con = $row['Senha'];
            }
            else
            {
                echo "alguma coisa";
            }


        }
else
{
   echo "It always enters here!";
}

"SQLSTATE: IMSSP<br />code: -14<br />message: An invalid parameter was passed to sqlsrv_query.<br /> — Fred Novack
– Fred Novack, Commented Jan 28, 2015 at 18:18

Jeremy Harris · Accepted Answer · 2015-01-28 18:29:45Z

1

Two possible problems.

The first is the format of your query. You are using:

select Usuario.Email, Usuario.Senha FROM Usuario WHERE Usuario.Email = (?)

Where I think you should be doing:

select Usuario.Email, Usuario.Senha FROM Usuario WHERE Usuario.Email = ?

The second is that the An invalid parameter was passed to sqlsrv_query() message is common when the connection is not correct (Reference). So double check that your connection is a valid resource.

edited Jan 28, 2015 at 18:29

answered Jan 28, 2015 at 18:20

Jeremy Harris

24.7k13 gold badges84 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Fred Novack Over a year ago

Done that... didn't work and received the same error

Fred Novack Over a year ago

even if I try $sql = "select Usuario.Email, Usuario.Senha FROM Usuario WHERE Usuario.Email = '[email protected]'"; // $params = array($email); $stmt = sqlsrv_query( $conn, $sql); I get the same error.

Fred Novack Over a year ago

Its not the connection because i have $server = "[SERVER]"; $user = "[USER]"; $pwd = "PSW"; $db = "DB"; if($conn === false) { die(print_r(sqlsrv_errors())); }

Fred Novack Over a year ago

I was wrong, my connection string was quite wrong. Thank you for giving me these options... I tough the error was the parameters of the QUERY, not the SQLSRV_QUERY parameters...

Collectives™ on Stack Overflow

PHP sqlsrv_query select statement not working

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related