// $sql = <<<EOD UPDATE {$options['table_prefix']}{$tableName} SET password = md5(concat(salt, ?)) WHERE username = ?; EOD; $db->execute($sql, ['doe', 'doe']); $db->execute($sql, ['admin', 'admin']); // // Check whats in the db // $db->select("*")->from($tableName); $res = $db->executeFetchAll(); echo "<pre>" . print_r($res, 1) . "</pre>"; // // Check password for each user // $db->select("username")->from($tableName)->where("username = ?")->andWhere("password = md5(concat(salt, ?))"); $res = $db->executeFetchAll(['doe', 'doe']); echo "<pre>" . print_r($res, 1) . "</pre>"; // // Check password for each user // $db->select("username")->from($tableName)->where("username = ?")->andWhere("password = md5(concat(salt, ?))"); $res = $db->executeFetchAll(['admin', 'admin']); echo "<pre>" . print_r($res, 1) . "</pre>"; // // Check (wrong) password for user