PDO Update Query

Question

EDIT: Fixed, something went wrong with some variables, works fine now!

Working code:

if($q = $this->pdo->prepare("UPDATE `ba_keys` SET `times_used` = :used WHERE `betacode` = :beta"))
    {
        $q->bindValue(':used', 90);
        $q->bindValue(':beta', $betacode);
        if($q->execute())
        {
            return 'Execution done.';
        } else {
            return 'Execution failed.';
        }
    } else {
        return 'Query preparing failed.';
    }

Try getting the error info: http://stackoverflow.com/questions/8776344/how-to-view-query-error-in-pdo-php — Pitchinnate, Nov 27 '13 at 14:10

score 1 · Answer 1 · answered Nov 27 '13 at 14:00

You do not need single quotes in the Prepared Statement. PDO will handle that for you. Your code should be:

$q = $this->pdo->prepare("UPDATE `ba_keys` SET `times_used` = :used WHERE `betacode` = :beta");
$q->bindValue(':used', 90);
$q->bindValue(':beta', $betacode);
$q->execute();

You might also wish to consider returning the result of $q->execute() from your function, for completeness.

PDO Update Query

EDIT: Fixed, something went wrong with some variables, works fine now!

1 Answers1