CODEWITHSUNDEEP
phpsql-server-2008pdoodbc
Theodore R. Smith
Theodore R. Smith

Reputation: 23231

ODBC and SQL Server 2008: Can't use prepared statements?

OK, so I cannot get this to work (either):

$stmt = odbc_prepare($conn, "SELECT * FROM Users WHERE username=?");
odbc_execute($stmt, array($username));
$user = odbc_fetch_object($stmt);


$stmt = $pdo->prepare("SELECT * FROM Users WHERE username=?");
$stmt->execut(array($username));
$user = $stmt->fetchObject();

Both return the same errors:

Warning: odbc_execute(): SQL error: Failed to fetch error message, SQL state HY000 in SQLExecute in user.php on line 24

Anyone know if it's possible to solve this, or are prepared statements off the table? If so, how should guard against SQL injections?

Upvotes: 2

Views: 1143

Answers (1)

Benny Hill
Benny Hill

Reputation: 6240

I never use the fetchObject method but how about this:

$stmt = $pdo->prepare("SELECT * FROM Users WHERE username=?");
$stmt->bindValue(1, $username);
try{
    $stmt->execute();
    while ($row = $stmt->fetch()){
       // Do whatever.
    }
}catch(PDOException $e){
    echo($e->getMessage());
}

I also notice the single quotes around your question mark ('?'), they shouldn't be there.

In order to use the try/catch stuff you'll need to include this when you create your PDO connection:

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

And you might want to add this as well:

$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); // Try to use the driver's native prepared statements.

Upvotes: 1

Related Questions