PDO Update statement wont execute

[mjahkoh]

the sql statement dont execute: what would be the problem?

 

                                                                         $sql = "UPDATE ".prefix("loanapplication")." SET 

                                                                         firstname = :firstname,

                                                                         secondname = :secondname,

                                                                         surname = :surname,

                                                                         officialworkemail = :officialworkemail";

 

                                                                        $sql.= " WHERE username=:username";

 

                        $sql.= " WHERE username=:username";

               

                        echo "$sql: $sql<br>";

                        //print_r($sql);

                        $stmt = $database->connection->prepare($sql);

                        $stmt->bindParam(':username',$session->username);

                        $stmt->bindParam(':firstname',$firstname);

                        $stmt->bindParam(':secondname',$secondname);

                        $stmt->bindParam(':surname',$surname);

                        $stmt->bindParam(':officialworkemail',$officialworkemail);

                        $stmt->execute();

 

 

 

sql =UPDATE `emr_loanapplication` SET firstname = :firstname, secondname = :secondname, surname = :surname, officialworkemail = :officialworkemail WHERE username=:username

[Ch0cu3r]

To find why your query is failing you need to use $stmt->errorInfo() 

// if the prepared query failed, trigger an error
if(!$stmt->execute())
{
    trigger_error('Update query failed: '  . $stmt->errorInfo(), E_USER_ERROR);
}

[ginerjm]

You have two where clauses in your query

[jazzman1]

 

You have two where clauses in your query

 

Agreed, but the output is very strange:

 

 

sql =UPDATE `emr_loanapplication` SET firstname = :firstname, secondname = :secondname, surname = :surname, officialworkemail = :officialworkemail WHERE username=:username

[ginerjm]

I agree - obviously what is being posted is NOT the actual executed code.