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
|
<?php session_start(); echo('<div class="flex-showdetail"'); $itemnr = $_SESSION['itemnr'];
include 'connect.php'; global $sel; $sel=MYSQLI_QUERY($link, "SELECT bezeichnung, bezeichnung_en, image, image_alt, description, description_long, description_en, description_en_long, skill, id, preis, size, DLCount, split, verbrauch, yardage FROM $tabelle WHERE (id = '$itemnr')"); global $row; $row = mysqli_fetch_array($sel, MYSQLI_BOTH); if($_SESSION['lang'] == 'de'){ echo '<div style="justify-content: center;"><h1>'.$row['bezeichnung']."</h1>"; if(is_null($row['image_alt'])){ echo '<img src="../schnitte/img/'.$row['image'].'" class="flex-item-detail" style="object-fit: contain;" alt="'.$row['bezeichnung'].'">'; } else { echo '<img src="../schnitte/img/'.$row['image_alt'].'" class="flex-item-detail" style="object-fit: contain;" alt="'.$row['bezeichnung'].'">'; } if(is_null($row['description_long'])){ echo '<div>'.$row['description'].'</div>'; } else { $string = '<div>'.$row['description_long'].'</div>'; echo nl2br($string);} echo '</div>'; switch ($row['skill']){ case 0: echo '<br/><div style="margin-left: 3em"><b>Schwierigkeit: </b><span style="background-color: #00cc00">Anfänger</div>'; break; case 1: echo '<br/><div style="margin-left: 3em"><b>Schwierigkeit: </b><span style="background-color: yellow">Fortgeschritten</span></div>'; break; case 2: echo '<br/><div style="margin-left: 3em"><b>Schwierigkeit: </b><span style="background-color: #e08e23">Profi</div>'; break; case 3: echo '<br/><div style="margin-left: 3em"><b>Schwierigkeit: </b><span style="background-color: #ff0000">sehr anspruchsvoll</div>'; break; default: echo '<br/><div style="margin-left: 3em"><b>Schwierigkeit: </b> nicht kategorisiert</div>'; break; } echo '<br/><div style="margin-left: 3em"><b>Größe: </b>'.$row['size'].'</div>'; echo '<br/><div style="margin-left: 3em"><b>Stoffverbrauch: </b>'.$row['verbrauch'].'</div>'; switch ($row['preis']){ case '0.00': if ($row['split'] == FALSE){ echo '<p class="flex-showdetail"><br style="clear:both;"><div style="width:150px; margin: 0 auto"><h3>Preis: kostenlos</h3></div><div class="flex-showdetail"><a href="download.php?file='.$row['image'].'&itemnr='.$row['id'].'" style="float:right"> <img src="http://patterns.bplaced.net/img/DL_Button.png"></a></div></p> '; } else { echo '<p class="flex-showdetail"><br style="clear:both;"><div style="width:150px; margin: 0 auto"><h3>Preis: kostenlos</h3></div><div class="flex-showdetail"><a href="download_select_size.php?file='.$row['image'].'&itemnr='.$row['id'].'" style="float:right"> <img style="float:center" src="http://patterns.bplaced.net/img/DL_Button.png"></a></div></p> '; } break; default: /*if ($row['DLCount'] >= 100)*/{ echo '<p class="flex-showdetail"><br style="clear:both;"> <div class="flex-showdetail"><a href="//de.etsy.com/shop/BlackSnailPatterns?ref=offsite_badges&utm_source=sellers&utm_medium=badges&utm_campaign=de_isell_1"><img width="200" height="200" src="//img0.etsystatic.com/site-assets/badges/de/de_isell_1.png"></a> </div>'; echo '<br style="clear:both">'; } break; } } else { /* HIER ENGLISCH BZW ANDERE SPRACHE */ echo '<div style="justify-content: center;"><h1>'.$row['bezeichnung_en']."</h1>"; if(is_null($row['image_alt'])){ echo '<img src="../schnitte/img/'.$row['image'].'" class="flex-item-detail" style="object-fit: contain;" alt="'.$row['bezeichnung_en'].'">'; } else { echo '<img src="../schnitte/img/'.$row['image_alt'].'" class="flex-item-detail" style="object-fit: contain;" alt="'.$row['bezeichnung_en'].'">'; } if(is_null($row['description_en_long'])){ echo '<div>'.$row['description_en'].'</div>'; } else { $string = '<div>'.$row['description_en_long'].'</div>'; echo nl2br($string);} echo '</div>'; switch ($row['skill']){ case 0: echo '<br/><div style="margin-left: 3em"><b>Skill: </b><span style="background-color: #00cc00">Novice</div>'; break; case 1: echo '<br/><div style="margin-left: 3em"><b>Skill: </b><span style="background-color: yellow">Intermediate</span></div>'; break; case 2: echo '<br/><div style="margin-left: 3em"><b>Skill: </b><span style="background-color: #e08e23">Pro</div>'; break; case 3: echo '<br/><div style="margin-left: 3em"><b>Skill: </b><span style="background-color: #ff0000">very professional</div>'; break; default: echo '<br/><div style="margin-left: 3em"><b>Skill: </b> not classified</div>'; break; } echo '<br/><div style="margin-left: 3em"><b>Size: </b>'.$row['size'].'</div>'; echo '<br/><div style="margin-left: 3em"><b>Yardage: </b>'.$row['yardage'].'</div>'; switch ($row['preis']){ case '0.00': if ($row['split'] == FALSE){ echo '<p class="flex-showdetail"><br style="clear:both;"><div style="width:150px; margin: 0 auto"><h3>Price: free</h3></div><div class="flex-showdetail"><a href="download.php?file='.$row['image'].'&itemnr='.$row['id'].'" style="float:right"> <img src="http://patterns.bplaced.net/img/DL_Button.png"></a></div></p> '; } else { echo '<p class="flex-showdetail"><br style="clear:both;"><div style="width:150px; margin: 0 auto"><h3>Price: free</h3></div><div class="flex-showdetail"><a href="download_select_size.php?file='.$row['image'].'&itemnr='.$row['id'].'" style="float:right"> <img style="float:center" src="http://patterns.bplaced.net/img/DL_Button.png"></a></div></p> '; } break; default: /*if ($row['DLCount'] >= 100)*/{ echo '<p class="flex-showdetail"><br style="clear:both;"> <div class="flex-showdetail"><a href="//de.etsy.com/shop/BlackSnailPatterns?ref=offsite_badges&utm_source=sellers&utm_medium=badges&utm_campaign=de_isell_1"><img width="200" height="200" src="//img0.etsystatic.com/site-assets/badges/en/en_isell_1.png"></a> </div>'; echo '<br style="clear:both">'; } break; } }
// Ausgabe DE und EN echo('<div class="flex-showdetail"'); /* echo '<br style="clear:both">'; */ $filename = $row['image']; $path = explode(".",$filename); $verzeichnis = "img/".$path[0]."/"; /*$verzeichnis = 'img/';*/ if (file_exists($verzeichnis)) {
foreach (array_slice(scanDir($verzeichnis), 2) as $datei) { if (in_array(substr($datei, -3, 3), array('gif','png','jpg'))) { /* echo '<br style="clear:both">'; echo '<div style="width:500px; margin-left:30px">';*/ echo '<img class="flex-item-detail" src="' . $verzeichnis . $datei . ' " align="center" style="border-radius:10px; object-fit: contain; " >'; /*echo '</div>';*/ } } } echo '</div>'; /* echo '<br style="clear:both"></div>'; */ ?>
|