/users/patterns/www/schnitte/show_detail.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
<?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($selMYSQLI_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, -33), 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>';    */
?>