-
Notifications
You must be signed in to change notification settings - Fork 0
/
sepeteekle.php
94 lines (86 loc) · 3.51 KB
/
sepeteekle.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?php
if(isset($_SESSION["Kullanici"])){
if(isset($_GET["ID"])){
$GelenID = Guvenlik($_GET["ID"]);
}else{
$GelenID = "";
}
if(isset($_POST["Varyant"])){
$GelenVaryantID = Guvenlik($_POST["Varyant"]);
}else{
$GelenVaryantID = "";
}
if(($GelenID!="") and ($GelenVaryantID!="")){
$KullanicininSepetKontrolSorgu = $VeritabaniBaglantisi->prepare("SELECT * FROM sepet WHERE UyeId = ? ORDER BY id DESC LIMIT 1");
$KullanicininSepetKontrolSorgu->execute([$KullaniciID]);
$KullanicininSepetSayisi = $KullanicininSepetKontrolSorgu->rowCount();
if($KullanicininSepetSayisi>0){
$UrunSepetKontrolSorgusu = $VeritabaniBaglantisi->prepare("SELECT * FROM sepet WHERE UyeId = ? AND UrunId = ? AND VaryantId = ? LIMIT 1");
$UrunSepetKontrolSorgusu->execute([$KullaniciID, $GelenID, $GelenVaryantID]);
$UrunSepetSayisi = $UrunSepetKontrolSorgusu->rowCount();
$UrunSepetKaydi = $UrunSepetKontrolSorgusu->fetch(PDO::FETCH_ASSOC);
if($UrunSepetSayisi>0){
$UrununIDsi = $UrunSepetKaydi["id"];
$UrununSepettekiMevcutAdedi = $UrunSepetKaydi["UrunAdedi"];
$UrununYeniAdedi = $UrununSepettekiMevcutAdedi+1;
$UrunGuncellemeSorgusu = $VeritabaniBaglantisi->prepare("UPDATE sepet SET UrunAdedi = ? WHERE id = ? AND UyeId = ? AND UrunId = ? LIMIT 1");
$UrunGuncellemeSorgusu->execute([$UrununYeniAdedi, $UrununIDsi, $KullaniciID, $GelenID]);
$UrunGuncellemeSayisi = $UrunGuncellemeSorgusu->rowCount();
if($UrunGuncellemeSayisi>0){
header("Location:index.php?SK=94");
exit();
}else{
header("Location:index.php?SK=92");
exit();
}
}else{
$UrunEklemeSorgusu = $VeritabaniBaglantisi->prepare("INSERT INTO sepet (UyeId, UrunId, VaryantId, UrunAdedi) values (?, ?, ?, ?)");
$UrunEklemeSorgusu->execute([$KullaniciID, $GelenID, $GelenVaryantID, 1]);
$UrunEklemeSayisi = $UrunEklemeSorgusu->rowCount();
$SonIdDegeri = $VeritabaniBaglantisi->lastInsertId();
if($UrunEklemeSayisi>0){
$SiparisNumarasiniGuncelleSorgusu = $VeritabaniBaglantisi->prepare("UPDATE sepet SET SepetNumarasi = ? WHERE UyeId = ?");
$SiparisNumarasiniGuncelleSorgusu->execute([$SonIdDegeri, $KullaniciID]);
$SiparisNumarasiniGuncelleSayisi = $SiparisNumarasiniGuncelleSorgusu->rowCount();
if($SiparisNumarasiniGuncelleSayisi>0){
header("Location:index.php?SK=94");
exit();
}else{
header("Location:index.php?SK=92");
exit();
}
}else{
header("Location:index.php?SK=92");
exit();
}
}
}else{
$UrunEklemeSorgusu = $VeritabaniBaglantisi->prepare("INSERT INTO sepet (UyeId, UrunId, VaryantId, UrunAdedi) values (?, ?, ?, ?)");
$UrunEklemeSorgusu->execute([$KullaniciID, $GelenID, $GelenVaryantID, 1]);
$UrunEklemeSayisi = $UrunEklemeSorgusu->rowCount();
$SonIdDegeri = $VeritabaniBaglantisi->lastInsertId();
if($UrunEklemeSayisi>0){
$SiparisNumarasiniGuncelleSorgusu = $VeritabaniBaglantisi->prepare("UPDATE sepet SET SepetNumarasi = ? WHERE UyeId = ?");
$SiparisNumarasiniGuncelleSorgusu->execute([$SonIdDegeri, $KullaniciID]);
$SiparisNumarasiniGuncelleSayisi = $SiparisNumarasiniGuncelleSorgusu->rowCount();
if($SiparisNumarasiniGuncelleSayisi>0){
header("Location:index.php?SK=94");
exit();
}else{
header("Location:index.php?SK=92");
exit();
}
}else{
header("Location:index.php?SK=92");
exit();
}
}
}else{
header("Location:index.php");
exit();
}
}else{
header("Location:index.php?SK=93");
exit();
}
?>