コード例 #1
0
ファイル: AddCreditWithCode.php プロジェクト: kostya1017/our
 	`user_id`,`edition_id`, `package_id`, `quantite`, `date`)
 	VALUES (
 	:user_id, :edition_id, :package_id, :quantite, :date)
 	");
 
 	//print_r($json);
 	$achatEkCreditClass = new InsertAchatEkCreditClass($user_id, $edition_id, NULL, $quantite, $dateheure);
 	$STH->execute((array)$achatEkCreditClass);
 
 	$achatEkCreditClass_affected = $STH->rowCount();
 	*/
 /*
 updater le membre
 */
 $quantite_au_compte = $functionObject->getQuantiteFromMember($user_id);
 $arrayCode = $functionObject->getIdAndQuantiteFromCode($code);
 if ($arrayCode == null) {
     echo json_encode(array("resultat" => "false", "data" => "Code invalide"));
     exit;
 }
 if (!$arrayCode['subscription']) {
     $nouveau_total = $quantite_au_compte + $arrayCode['quantite'];
     $STH = $DBH->prepare("\n\t\tUPDATE `member`\n\t\tSET `ek_credit` = :total\n\t\tWHERE `id` = :user_id\n\t\tLIMIT 1\n\t\t");
     $STH->bindParam(':total', $nouveau_total);
     $STH->bindParam(':user_id', $user_id);
     $STH->execute();
     $updateMemberClass_affected = $STH->rowCount();
 } else {
     $updateSubscriptionClass_affected = 0;
     foreach ($arrayCode['id'] as $id) {
         // Getting # of days of this subscription