$STH->execute((array) $updateAchatAndroidPayloadClass); $achatAndroidClass_affected = $STH->rowCount(); /* if($achatAndroidClass_affected == 1) { $DBH->query('COMMIT'); echo json_encode(array("resultat" => "true", "data" => array('idachat'=>$idachat))); } else { $DBH->query('ROLLBACK'); echo json_encode(array("resultat" => "false", "data" => "Erreur de consomation de l'achat")); }*/ $functionObject = new FunctionClass(); $idachat = $functionObject->getIdFromPayloadAndSkuTransactionAndroid($payload, $sku); if ($username == "" || $password == "") { $quantite_a_ajouter = $functionObject->getQuantiteFromIdTransactionAndroid($idachat); if ($achatAndroidClass_affected == 1) { $DBH->query('COMMIT'); echo json_encode(array("resultat" => "true", "data" => $quantite_a_ajouter)); } else { $DBH->query('ROLLBACK'); echo json_encode(array("resultat" => "false", "data" => "Erreur d'enregistrement de la transaction sans compte")); } exit; } $user_id = $functionObject->getIdMembre($username, $password); $quantite_a_ajouter = $functionObject->getQuantiteFromIdTransactionAndroid($idachat); $quantite_au_compte = $functionObject->getQuantiteFromMember($user_id); $nouveau_total = $quantite_au_compte + $quantite_a_ajouter; $STH = $DBH->prepare("\n\tUPDATE `member` \n\tSET `ek_credit` = :total \n\tWHERE `id` = :user_id\n\tLIMIT 1\n\t"); $STH->bindParam(':total', $nouveau_total);