-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbestaetigung.php
219 lines (204 loc) · 13.4 KB
/
bestaetigung.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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
<?php
require_once('initialisierung.php');
if( !isset( $_SESSION['Kunde'] ) ) header('location: index.php');
if( count( $_SESSION['Warenkorb'] ) == 0 ) header('location: produkte_secured.php');
if( isset( $_POST['AGB']) ) {
// Neue Bestellung anlegen
$Bestellung = $Verbindung->stmt_init() ;
$Bestellung->prepare('
INSERT INTO bestellung ( Kunde, Zahlungsart, Lieferadresse )
VALUES ( ?, ?, ? ) ;
');
$Bestellung->bind_param('iss', $_SESSION['Kunde'], $_POST['Zahlungsart'], $_POST['Lieferadresse'] );
$Bestellung->execute() ;
$BestellNr = $Verbindung->insert_id ;
// Alle zugehörigen Posten eintragen
$Posten = $Verbindung->stmt_init() ;
$Posten->prepare('
INSERT INTO posten ( Bestellung, Artikel, Menge, Preis )
VALUES ( ?, ?, ?, ? ) ;
') ;
$Posten->bind_param('iiid', $BestellNr, $Artikel, $Menge, $Preis );
foreach( $_SESSION['Warenkorb'] as $Eintrag ) {
$Artikel = $Eintrag->ArtNr ;
$Menge = $Eintrag->Mng ;
$Preis = $Eintrag->Prs ;
$Posten->execute() ;
}
// Warenkorb nach Postenübertragung löschen
unset( $_SESSION['Warenkorb']);
// Kontrollabfrage zur Anzeige der Bestellung
$Ergebnis = $Verbindung->query('
SELECT BestellNr, Datum, Bezeichnung, Menge, posten.Preis
FROM bestellung INNER JOIN (
posten INNER JOIN artikel ON posten.Artikel = artikel.ArtikelNr)
ON bestellung.BestellNr = posten.Bestellung
WHERE bestellung.BestellNr = "'.$BestellNr.'";
');
} else die('Ohne AGB läuft nix!');
$posten = $_SESSION['Posten'];
?>
<!-- Wir über Uns - Pop-Up-Fenster -->
<div id="myModal2" class="modal fade register" role="dialog">
<div class="modal-dialog">
<!-- Wir über uns content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h2 class="modal-title">Wir über uns</h2>
</div>
<div class="modal-body">
<?php echo(ueberuns());?>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Warenkorb - Pop-Up-Fenster -->
<div id="myModal3" class="modal fade register" role="dialog">
<div class="modal-dialog">
<!-- Warenkorb content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h2 class="modal-title">Warenkorb</h2>
</div>
<div class="modal-body">
<div class="table-responsive">
<?php echo(wk_zeigen());?>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Kontakt und Impressum - Pop-Up-Fenster -->
<div id="myModal8" class="modal fade register" role="dialog">
<div class="modal-dialog">
<!-- Kontakt und Impressum content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h2 class="modal-title">Kontakt und Impressum</h2>
</div>
<div class="modal-body">
<div class="table-responsive">
<?php echo(kontakt());?>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Kontakt und Impressum - Pop-Up-Fenster -->
<div id="myModal9" class="modal fade register" role="dialog">
<div class="modal-dialog">
<!-- Kontakt und Impressum content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h2 class="modal-title">Datenschutz</h2>
</div>
<div class="modal-body">
<div class="table-responsive">
<?php echo(datenschutz());?>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Pejo Falaffel</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" type="text/css" href="css/pejo_style.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
</head>
<body>
<div class="wrapper container">
<!-- Header -->
<div class="blog-masthead container-fluid">
<div class="siegel row">
<div class="col-md-4 col-xs-2 col-sm-6 col-lg-3 col-xl-6 col-md-offset-4 col-xs-offset-5 col-sm-offset-3 col-lg-offset-0 col-xl-offset-0">
<div><a href="index_secured.php"><img class="img-responsive img img-circle col-md-4 col-lg-4 col-xs-4 col-sm-4 col-xl-4" src="./img/logo.jpg"></a></div>
<div><img src="./img/siegel2.jpg" class="img img-circle img-responsive col-md-4 col-lg-4 col-xs-4 col-sm-4 col-xl-4" alt="Placeholder image"></div>
<div><img src="./img/siegel1.jpg" class="img img-circle img-responsive col-md-4 col-lg-4 col-xs-4 col-sm-4 col-xl-4" alt="Placeholder image"></div>
</div>
<div class="col-md-8 col-xs-2 col-sm-10 col-lg-8 col-xl-6 col-md-offset-2 col-xs-offset-5 col-sm-offset-1 col-lg-offset-0 col-xl-offset-0 text-center">
<nav class="blog-nav topnav">
<nav class="blog-nav ">
<a href="logout.php" class="btn btn-default btn-sm"><span class="glyphicon glyphicon-log-out"></span> Log Out</a>
<button id="WK" type="button" data-toggle="modal" data-target="#myModal3" class="btn btn-default btn-sm">
<span class="glyphicon glyphicon-shopping-cart"></span> Warenkorb (<?php echo( $posten ) ; ?>)
</button>
</nav>
</nav>
</div>
</div>
<div class="row">
<nav class="col-md-12 col-xs-2 col-sm-4 col-lg-8 col-xl-10 col-md-offset-0 col-xs-offset-5 col-sm-offset-4 col-lg-offset-2 col-xl-offset-1 text-center">
<p><?php if( isset($Meldung) ) echo( $Meldung ) ; ?></p>
</nav>
</div>
<div class="row text-center">
<div class="col-md-8 col-xs-2 col-sm-10 col-lg-8 col-xl-10 col-md-offset-2 col-xs-offset-5 col-sm-offset-1 col-lg-offset-2 col-xl-offset-1 text-center">
<nav class="blog-nav">
<a href="index_secured.php" class="blog-nav-item btn btn-default btn-sm">Home</a>
<a href="produkte_secured.php" class="blog-nav-item btn btn-default btn-sm">Produkte</a>
<a href="#" data-toggle="modal" data-target="#myModal2" class="blog-nav-item btn btn-default btn-sm">Wir über uns</a>
<a href="#" class="blog-nav-item btn btn-default btn-sm">Messetermine</a>
<button id="LI" type="button" data-toggle="modal" data-target="#myModal8" name="Aktion" value="einloggen" class="blog-nav-item btn btn-default btn-sm">
<span class="glyphicon"></span> Kontakt und Impressum
</button>
</nav>
</div>
</div>
</div>
<div class="container-fluid main">
<div class="row ">
<div class="text-center col-md-12 col-xs-2 col-sm-12 col-lg-12 col-xl-10 col-md-offset-0 col-xs-offset-5 col-sm-offset-0 col-lg-offset-0 col-xl-offset-1 blog-main">
<section>
<h1>Sie haben soeben bei uns folgende Bestellung aufgegeben:</h1>
</section>
</div>
</div>
<div class="row">
<div class="text-center col-md-12 col-xs-2 col-sm-12 col-lg-12 col-xl-10 col-md-offset-0 col-xs-offset-5 col-sm-offset-0 col-lg-offset-0 col-xl-offset-1 blog-main">
<?php echo( zeigeSelect($Ergebnis) );?>
</div>
</div>
<!--Main-Content-->
<div class="row">
<div class="blog-sidebar text-center col-md-12 col-xs-2 col-sm-12 col-lg-12 col-xl-12 col-md-offset-0 col-xs-offset-5 col-sm-offset-0 col-lg-offset-0 col-xl-offset-1">
<section >
<strong>Hossam Ekkawi & Joachim Winkler</strong><br>
Nierlochstraße 2<br>
D-72379 Hechingen<br>
<abbr title="Telefonnummer">Tel.:</abbr> +49 7471 - 871 931
<abbr title="Fax">Fax.:</abbr> +49 7471 - 871 910 <br>
<h3>Peijo GbR</h3>
<a href="index.php"><img class="img-responsive img img-rounded center-block" src="./img/logo.jpg"></a>
</section>
<br>
<a href="#" data-toggle="modal" data-target="#myModal9" class="blog-nav-item btn btn-default
btn-sm">
<span class="glyphicon"></span> Datenschutz
</a>
</div>
</div>
</div>
<script src="js/jquery-1.11.2.min.js" type="text/javascript"></script>
<script src="js/bootstrap.js" type="text/javascript"></script>
</body>
</html>