コード例 #1
0
 $achatItunesClass_affected = $STH->rowCount();
 if ($username == "" || $password == "") {
     $functionObject = new FunctionClass();
     $quantite_a_ajouter = $functionObject->getQuantiteFromIdTransaction($achat_id);
     if ($achatItunesClass_affected == 1) {
         $DBH->query('COMMIT');
         echo json_encode(array("resultat" => "true", "data" => array('total' => $quantite_a_ajouter)));
     } else {
         $DBH->query('ROLLBACK');
         echo json_encode(array("resultat" => "false", "data" => "Erreur d'enregistrement de la transaction sans compte"));
     }
     exit;
 }
 $functionObject = new FunctionClass();
 $user_id = $functionObject->getIdMembre($username, $password);
 $quantite_a_ajouter = $functionObject->getQuantiteFromIdTransaction($achat_id);
 $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);
 $STH->bindParam(':user_id', $user_id);
 $STH->execute();
 $updateMemberClass_affected = $STH->rowCount();
 if ($achatItunesClass_affected == 1 && $updateMemberClass_affected == 1) {
     $DBH->query('COMMIT');
     echo json_encode(array("resultat" => "true", "data" => array('total' => $nouveau_total)));
 } else {
     if ($achatItunesClass_affected == 1) {
         $DBH->query('ROLLBACK');
         echo json_encode(array("resultat" => "false", "data" => "Erreur d'enregistrement de la transaction"));
     } else {