Auf Thema antworten 2026

Beitrag

<blockquote data-quote="karina06" data-source="post: 1641125" data-attributes="member: 249321">AW: Sql/phpFreu über eure Antworten,hier die beiden Klassen.class artikel[PHP]&lt;?phprequire_once (&quot;class_sitzungsSeite.php&quot;);class artikel extends sitzungsSeite{&nbsp; private $artikelArray = array();&nbsp; private $DB = array(&#039;database&#039; =&gt; &#039;u12345678&#039;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#039;user&#039;&nbsp; &nbsp;&nbsp; =&gt; &#039;abc&#039;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#039;password&#039; =&gt; &#039;geheim&#039;);&nbsp; protected $dbh;&nbsp; # Database-Handle&nbsp; public function __construct()&nbsp; {&nbsp; &nbsp; parent::__construct();&nbsp; &nbsp; if(!is_array($this-&gt;DB) &amp;&amp; empty($this-&gt;DB[&#039;database&#039;]))&nbsp; &nbsp; &nbsp; throw new Exception(&quot;Daten für Datenbankverbindung fehlen!&quot;);&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $connectString = &quot;mysql:dbname=&quot;.$this-&gt;DB[&#039;database&#039;].&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;;host=localhost&quot;;&nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;dbh = new PDO($connectString, $this-&gt;DB[&#039;user&#039;], &nbsp; &nbsp; &nbsp; $this-&gt;DB[&#039;password&#039;] );&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;dbh-&gt;setAttribute(PDO::ATTR_ERRMODE,&nbsp; &nbsp; &nbsp; PDO::ERRMODE_EXCEPTION);&nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT a_artikelnr, a_name AS_veranstaltung, a_preis, a_menge&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM ws_artikel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; WHERE a_menge &gt; 0&quot;;&nbsp; &nbsp; &nbsp; &nbsp; $result = $this-&gt;dbh-&gt;query($sql);&nbsp; &nbsp; &nbsp; &nbsp; $tmp = $result-&gt;fetchAll(PDO::FETCH_ASSOC);&nbsp; foreach ($tmp as $key =&gt; $value)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach($value as $k1 =&gt; $v1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $name = split(&quot;_&quot;, $k1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($k1 != &#039;a_artikelnr&#039;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;artikelArray[$value[&#039;a_artikelnr&#039;]][$name[1]] = $v1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; catch(PDOException $e)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo $e-&gt;getMessage();&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; }&nbsp; &nbsp;&nbsp; public function anzeigen()&nbsp; {&nbsp; &nbsp; print &quot; &lt;table cellpadding=\&quot;5\&quot;&gt;\n&quot;;&nbsp; &nbsp; print &quot;&nbsp; &lt;/tr&gt;\n &quot;;&nbsp;#holen des numerischen Indizes&nbsp;$tmp = array_keys($this-&gt;artikelArray);&nbsp;#Durchsuchen nach den assoziativen Schlüsseln&nbsp;foreach($this-&gt;artikelArray[$tmp[0]] as $key =&gt;&nbsp;&nbsp; $value)&nbsp;{&nbsp; #Ersten Buchstabn groß sezen&nbsp; print &quot;&lt;th&gt;&quot;.ucwords($key).&quot;&lt;/th&gt;&quot;;&nbsp;}&nbsp;print &quot;\n&lt;/tr&gt;\n&quot;;&nbsp;#Alle Datenfelder ausgeben&nbsp;foreach($this-&gt;artikelArray as $key =&gt; $value)&nbsp;{&nbsp; print &quot;&lt;tr style=\&quot;text-align: center;\&quot;&gt;\n&quot;;&nbsp; foreach($value as $subKey =&gt; $subVal)&nbsp; {&nbsp;&nbsp; if ($subKey == &quot;preis&quot;) #prüfen, um Euro-Text anzuhängen&nbsp;&nbsp; print &quot;&lt;td align=\right\&quot;&gt;&quot;.$subVal.&quot; Euro&nbsp; &nbsp; &lt;/td&gt;\n&quot;;&nbsp;&nbsp; else&nbsp; &nbsp; print &quot;&lt;td&gt;&quot;.$subVal.&quot;&lt;/td&gt;\n&quot;;&nbsp; }&nbsp; print &quot;&lt;td&gt;&lt;a href=\&quot;&quot;.$_SERVER[&#039;PHP_SELF&#039;].&quot;?id=&quot;.&nbsp; &nbsp; $key.&nbsp; &nbsp; &quot;\&quot;&gt;In den Warenkorb&lt;/a&gt;&lt;/td&gt;\n&quot;;&nbsp; &nbsp; print &quot; &lt;/tr&gt;\n&quot;;&nbsp;}&nbsp;print &quot;&lt;/table&gt;\n&quot;;&nbsp; }&nbsp;&nbsp; public function waehlen($artikelnummer, $kunde)&nbsp; {&nbsp; &nbsp; if(!empty ($artikelnummer) &amp;&amp; !empty($kunde))&nbsp;{&nbsp; try&nbsp; {&nbsp;&nbsp; $sql = &quot;UPDATE ws_warenkorb&nbsp; &nbsp; SET w_menge = w_menge + 1&nbsp; &nbsp;&nbsp; WHERE w_artikelnr = :nummer&nbsp; &nbsp; &nbsp; AND w_kunde = :kunde&quot;;&nbsp; $result = $this-&gt;dbh-&gt;prepare($sql);&nbsp; $result-&gt;bindParam(&#039;:nummer&#039;, $artikelnummer, PDO::PARAM_INT);&nbsp; $result-&gt;bindParam(&#039;:kunde&#039;, $kunde, PDO::PARAM_INT);&nbsp; $result-&gt;execute();&nbsp; if ($result-&gt;rowCount() == 1)&nbsp;&nbsp; return true;&nbsp;&nbsp; &nbsp; $sql =&quot;INSERT INTO ws_warenkorb&nbsp; &nbsp; &nbsp;&nbsp; (w_artikelnr, w_kunde, w_menge)&nbsp; &nbsp; &nbsp; VALUES (:nummer, :kunde, 1)&quot;;&nbsp; $result = $this-&gt;dbh-&gt;prepare($sql);&nbsp; $result-&gt;bindParam(&#039;:nummer&#039;, $artikelnummer, PDO::PARAM_INT);&nbsp; $result-&gt;bindParam(&#039;:kunde&#039;, $kunde, PDO::PARAM_INT);&nbsp; $result-&gt;execute();&nbsp; if($result-&gt;rowCount()== 1)&nbsp; {&nbsp;&nbsp; print &quot;Datensatz wurde eingetragen.&quot;;&nbsp;&nbsp; return true;&nbsp; }&nbsp; return false;&nbsp; }&nbsp; catch(PDOException $e)&nbsp; {&nbsp;&nbsp; echo $e-&gt;getMessage();&nbsp; }&nbsp;}}&nbsp; &nbsp; public function bestellen($kunde){&nbsp; if(!is_integer($kunde))&nbsp; # Gültige Kundennummer?&nbsp; &nbsp; throw new Exception(&#039;Keine Kundennummer&#039;); # Fehler ausgeben&nbsp; else&nbsp; {&nbsp; &nbsp; try&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; #in Datenbank schreiben&nbsp; &nbsp; &nbsp; $sql = &quot;SELECT w_kunde, w_artikelnr, w_menge&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM ws_warenkorb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; WHERE w_kunde = :kunde&quot;;&nbsp; &nbsp; &nbsp; $result = $this-&gt;dbh-&gt;prepare($sql);&nbsp;&nbsp; $result-&gt;bindParam(&#039;:kunde&#039;, $kunde, PDO::PARAM_INT);&nbsp;&nbsp; $result-&gt;execute();&nbsp;&nbsp; $tmp = $result-&gt;fetchAll(PDO::FETCH_ASSOC);&nbsp;foreach($tmp as $key =&gt; $value)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;INSERT INTO ws_bestellung (b_kunde, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; b_artikelnr, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; b_menge)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; VALUES (:kunde, :artikel, :menge)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; $result = $this-&gt;dbh-&gt;prepare($sql);&nbsp; &nbsp; &nbsp; &nbsp; $result-&gt;execute(array(&#039;:kunde&#039; =&gt; (int)$value[&#039;w_kunde&#039;],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &#039;:artikel&#039; =&gt; (int)$value[&#039;w_artikelnr&#039;],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &#039;:menge&#039; =&gt; $value[&#039;w_menge&#039;]));&nbsp; if($result-&gt;rowCount() == 1){&nbsp;$sql1 = &quot;UPDATE ws_artikel &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; SET a_menge = a_menge - :anzahl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE a_artikelnr = :artikel&quot;;$result1 = $this-&gt;dbh-&gt;prepare($sql1);$result1-&gt;bindParam(&#039;:anzahl&#039;, $value[&#039;w_menge&#039;],&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; PDO::PARAM_INT);$result1-&gt;bindParam(&#039;:artikel&#039;, $value[&#039;w_artikelnr&#039;]);$result1-&gt;execute();if ($result1-&gt;rowCount() == 1){$sql2 = &quot;DELETE FROM ws_warenkorb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; WHERE w_kunde = :kunde&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; AND w_artikelnr = :artikel&quot;;$sql2 = $this-&gt;dbh-&gt;prepare($sql2);$sql2-&gt;execute(array(&#039;:kunde&#039; =&gt; (int)$kunde,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#039;:artikel&#039; =&gt; (int)$value[&#039;w_artikelnr&#039;]));&nbsp;}&nbsp; &nbsp;&nbsp; $error = true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; catch(PDOException $e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo $e-&gt;getMessage();&nbsp; &nbsp; }&nbsp; }&nbsp; session_destroy();&nbsp; return $error;}}?&gt;#class webshop&lt;?phprequire_once (&quot;class_artikel.php&quot;);require_once (&quot;class_pdf.php&quot;);require_once (&quot;class_kunde.php&quot;);class webshop extends artikel{&nbsp; private $pdf;&nbsp; private $kunde;&nbsp;&nbsp; public function __construct()&nbsp; {&nbsp; parent::__construct();&nbsp;&nbsp; &nbsp; $this-&gt;pdf = new pdf();&nbsp; &nbsp; $this-&gt;kunde = new kunde($this-&gt;dbh);&nbsp; }&nbsp; &nbsp;&nbsp; public function setKundenNummer($kennung, $passwort)&nbsp; {&nbsp; &nbsp; $this-&gt;KndNr = 1;&nbsp;if(!empty($kennung) &amp;&amp; !empty($passwort))&nbsp;{&nbsp; try&nbsp; {&nbsp;&nbsp; $sql = &quot;SELECT k_kundennummer&nbsp;&nbsp; From ws_kunde&nbsp;&nbsp; WHERE k_kennung = :kennung&nbsp;&nbsp; AND k_passwort = :passwort&quot;;&nbsp;&nbsp; $result = $this-&gt;dbh-&gt;prepare($sql);&nbsp;&nbsp; $result-&gt;bindParam(&#039;:kennung&#039;, $kennung,&nbsp;&nbsp; PDO::PARAM_STR, 20);&nbsp;&nbsp; $result-&gt;bindParam(&#039;:passwort&#039;, $passwort,&nbsp;&nbsp; PDO::PARAM_STR, 32);&nbsp;&nbsp; $result-&gt;execute();&nbsp;&nbsp; &nbsp;&nbsp; $tmp = $result-&gt;fetchAll();&nbsp;&nbsp; if(isset($tmp[0][&#039;k_kundennummer&#039;]) &amp;&amp;&nbsp; &nbsp; !empty($tmp[0][&#039;k_kundennummer&#039;]))&nbsp; &nbsp; {&nbsp; &nbsp;&nbsp; $this-&gt;KndNr = &nbsp; &nbsp;&nbsp; (integer)$tmp[0][&#039;k_kundennummer&#039;];&nbsp; &nbsp; }&nbsp; &nbsp; $_SESSION[&#039;kunde&#039;] = $this-&gt;KndNr;&nbsp; &nbsp; return $this-&gt;KndNr;&nbsp; }&nbsp; catch(PDOException $e)&nbsp; {&nbsp;&nbsp; echo $e-&gt;getMessage();&nbsp; }&nbsp;{&nbsp; return $this-&gt;kunde-&gt;setKundenNummer($kennung,&nbsp; $passwort);&nbsp;}}}&nbsp; public function auswahl($kunde) # zeigt ausgewählte Artikel&nbsp; {&nbsp;$sql = &quot;SELECT a_name, w_menge&nbsp;&nbsp; FROM ws_warenkorb, ws_artikel&nbsp;&nbsp; WHERE w_kunde = $kunde&nbsp;&nbsp; AND w_artikelnr = a_artikelnr&quot;;&nbsp; $result = $this-&gt;dbh-&gt;query($sql);&nbsp; $tmp = $result-&gt;fetchAll(PDO::FETCH_ASSOC);&nbsp; if (count($tmp) &gt; 0)&nbsp; {&nbsp;&nbsp; print &quot;&lt;table&gt;\n&quot;;&nbsp;&nbsp; print &quot;&lt;tr&gt;\n &lt;th&gt;Artikel&lt;/th&gt;&lt;th&gt;Anzahl&lt;/th&gt;\n&nbsp;&nbsp; &lt;/tr&gt;\n&quot;;&nbsp;&nbsp; foreach($tmp as $key)&nbsp;&nbsp; {&nbsp; &nbsp; print &quot;&lt;tr&gt;\n&quot;;&nbsp; &nbsp; print &quot;&lt;td&gt;&quot;.$key[&#039;a_name&#039;].&nbsp; &nbsp;&nbsp; &quot;&lt;/td&gt;&lt;td&gt;&quot;.$key[&#039;w_menge&#039;].&quot;&lt;/td&gt;\n&quot;;&nbsp; &nbsp; print &quot;&lt;/tr&gt;\n&quot;;&nbsp;&nbsp; }&nbsp;&nbsp; print &quot;&lt;/table&gt;\n&quot;;&nbsp; }&nbsp; else&nbsp;&nbsp; print &quot;Keine Artikel im Warenkorb gefunden.&quot;;&nbsp; }&nbsp;&nbsp; private function setArtikel($daten)&nbsp; {&nbsp; &nbsp; $this-&gt;pdf-&gt;SetLeftMargin(35); # Setzt Rand&nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(30,5,&quot;Artikelnummer&quot;,1,0,&#039;C&#039;);&nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(60,5,&quot;Artikel&quot;,1,0,&#039;C&#039;);&nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(30,5,&quot;Preis&quot;,1,0,&#039;R&#039;);&nbsp; &nbsp; foreach ($daten as $key =&gt; $value)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; $this-&gt;pdf-&gt;ln();&nbsp; &nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(30,5,$key,1,0,&#039;C&#039;);&nbsp; &nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(60,5,iconv(&#039;UTF-8&#039;, &#039;ISO-8859-15&#039;, $value[&#039;name&#039;]),1,0);&nbsp; &nbsp; &nbsp; $this-&gt;pdf-&gt;Cell(30,5,$value[&#039;preis&#039;].&quot; Euro&quot;,1,0,&#039;R&#039;);&nbsp; &nbsp; }&nbsp; }&nbsp; public function pdfliste()&nbsp; {&nbsp; &nbsp; $this-&gt;pdf-&gt;setTitel(&quot;Liste bestellbarer Artikel&quot;);&nbsp; &nbsp; $this-&gt;pdf-&gt;AliasNbPages();&nbsp; &nbsp; $this-&gt;pdf-&gt;AddPage();&nbsp; &nbsp; $this-&gt;pdf-&gt;SetFont(&#039;Times&#039;,&#039;&#039;,12);&nbsp; &nbsp; $text = &quot;Sehr geehrter Kunde,\n\nvielen Dank, dass Sie sich&quot;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; für unser Angebot interessieren. Folgende Artikel&quot;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; können Sie in unserem Online-Shop (http://&quot;.$_SERVER[&#039;PHP_SELF&#039;].&quot;) bestellen.\n&quot;;&nbsp; &nbsp; $this-&gt;pdf-&gt;setText($text);&nbsp; &nbsp; $this-&gt;setArtikel($this-&gt;artikelArray);&nbsp; &nbsp; $text = &quot;\n\nVielen Dank für Ihr Interesse.&quot;;&nbsp; &nbsp; $this-&gt;pdf-&gt;setText($text);&nbsp; &nbsp; $this-&gt;pdf-&gt;Output();&nbsp; }&nbsp; }&nbsp;?&gt;[/PHP]</blockquote>

[QUOTE="karina06, post: 1641125, member: 249321"] [b]AW: Sql/php[/b] Freu über eure Antworten, hier die beiden Klassen. class artikel [PHP] <?php require_once ("class_sitzungsSeite.php"); class artikel extends sitzungsSeite { private $artikelArray = array(); private $DB = array('database' => 'u12345678', 'user' => 'abc', 'password' => 'geheim'); protected $dbh; # Database-Handle public function __construct() { parent::__construct(); if(!is_array($this->DB) && empty($this->DB['database'])) throw new Exception("Daten für Datenbankverbindung fehlen!"); else { $connectString = "mysql:dbname=".$this->DB['database']. ";host=localhost"; try { $this->dbh = new PDO($connectString, $this->DB['user'], $this->DB['password'] ); $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT a_artikelnr, a_name AS_veranstaltung, a_preis, a_menge FROM ws_artikel WHERE a_menge > 0"; $result = $this->dbh->query($sql); $tmp = $result->fetchAll(PDO::FETCH_ASSOC); foreach ($tmp as $key => $value) { foreach($value as $k1 => $v1) { $name = split("_", $k1); if ($k1 != 'a_artikelnr') $this->artikelArray[$value['a_artikelnr']][$name[1]] = $v1; } } } catch(PDOException $e) { echo $e->getMessage(); } } } public function anzeigen() { print " <table cellpadding=\"5\">\n"; print " </tr>\n "; #holen des numerischen Indizes $tmp = array_keys($this->artikelArray); #Durchsuchen nach den assoziativen Schlüsseln foreach($this->artikelArray[$tmp[0]] as $key => $value) { #Ersten Buchstabn groß sezen print "<th>".ucwords($key)."</th>"; } print "\n</tr>\n"; #Alle Datenfelder ausgeben foreach($this->artikelArray as $key => $value) { print "<tr style=\"text-align: center;\">\n"; foreach($value as $subKey => $subVal) { if ($subKey == "preis") #prüfen, um Euro-Text anzuhängen print "<td align=\right\">".$subVal." Euro </td>\n"; else print "<td>".$subVal."</td>\n"; } print "<td><a href=\"".$_SERVER['PHP_SELF']."?id=". $key. "\">In den Warenkorb</a></td>\n"; print " </tr>\n"; } print "</table>\n"; } public function waehlen($artikelnummer, $kunde) { if(!empty ($artikelnummer) && !empty($kunde)) { try { $sql = "UPDATE ws_warenkorb SET w_menge = w_menge + 1 WHERE w_artikelnr = :nummer AND w_kunde = :kunde"; $result = $this->dbh->prepare($sql); $result->bindParam(':nummer', $artikelnummer, PDO::PARAM_INT); $result->bindParam(':kunde', $kunde, PDO::PARAM_INT); $result->execute(); if ($result->rowCount() == 1) return true; $sql ="INSERT INTO ws_warenkorb (w_artikelnr, w_kunde, w_menge) VALUES (:nummer, :kunde, 1)"; $result = $this->dbh->prepare($sql); $result->bindParam(':nummer', $artikelnummer, PDO::PARAM_INT); $result->bindParam(':kunde', $kunde, PDO::PARAM_INT); $result->execute(); if($result->rowCount()== 1) { print "Datensatz wurde eingetragen."; return true; } return false; } catch(PDOException $e) { echo $e->getMessage(); } }} public function bestellen($kunde) { if(!is_integer($kunde)) # Gültige Kundennummer? throw new Exception('Keine Kundennummer'); # Fehler ausgeben else { try { #in Datenbank schreiben $sql = "SELECT w_kunde, w_artikelnr, w_menge FROM ws_warenkorb WHERE w_kunde = :kunde"; $result = $this->dbh->prepare($sql); $result->bindParam(':kunde', $kunde, PDO::PARAM_INT); $result->execute(); $tmp = $result->fetchAll(PDO::FETCH_ASSOC); foreach($tmp as $key => $value) { $sql = "INSERT INTO ws_bestellung (b_kunde, b_artikelnr, b_menge) VALUES (:kunde, :artikel, :menge)"; $result = $this->dbh->prepare($sql); $result->execute(array(':kunde' => (int)$value['w_kunde'], ':artikel' => (int)$value['w_artikelnr'], ':menge' => $value['w_menge'])); if($result->rowCount() == 1) { $sql1 = "UPDATE ws_artikel SET a_menge = a_menge - :anzahl WHERE a_artikelnr = :artikel"; $result1 = $this->dbh->prepare($sql1); $result1->bindParam(':anzahl', $value['w_menge'], PDO::PARAM_INT); $result1->bindParam(':artikel', $value['w_artikelnr']); $result1->execute(); if ($result1->rowCount() == 1) { $sql2 = "DELETE FROM ws_warenkorb WHERE w_kunde = :kunde AND w_artikelnr = :artikel"; $sql2 = $this->dbh->prepare($sql2); $sql2->execute(array(':kunde' => (int)$kunde, ':artikel' => (int)$value['w_artikelnr'])); } $error = true; } } } catch(PDOException $e) { echo $e->getMessage(); } } session_destroy(); return $error; } } ?> #class webshop <?php require_once ("class_artikel.php"); require_once ("class_pdf.php"); require_once ("class_kunde.php"); class webshop extends artikel { private $pdf; private $kunde; public function __construct() { parent::__construct(); $this->pdf = new pdf(); $this->kunde = new kunde($this->dbh); } public function setKundenNummer($kennung, $passwort) { $this->KndNr = 1; if(!empty($kennung) && !empty($passwort)) { try { $sql = "SELECT k_kundennummer From ws_kunde WHERE k_kennung = :kennung AND k_passwort = :passwort"; $result = $this->dbh->prepare($sql); $result->bindParam(':kennung', $kennung, PDO::PARAM_STR, 20); $result->bindParam(':passwort', $passwort, PDO::PARAM_STR, 32); $result->execute(); $tmp = $result->fetchAll(); if(isset($tmp[0]['k_kundennummer']) && !empty($tmp[0]['k_kundennummer'])) { $this->KndNr = (integer)$tmp[0]['k_kundennummer']; } $_SESSION['kunde'] = $this->KndNr; return $this->KndNr; } catch(PDOException $e) { echo $e->getMessage(); } { return $this->kunde->setKundenNummer($kennung, $passwort); }}} public function auswahl($kunde) # zeigt ausgewählte Artikel { $sql = "SELECT a_name, w_menge FROM ws_warenkorb, ws_artikel WHERE w_kunde = $kunde AND w_artikelnr = a_artikelnr"; $result = $this->dbh->query($sql); $tmp = $result->fetchAll(PDO::FETCH_ASSOC); if (count($tmp) > 0) { print "<table>\n"; print "<tr>\n <th>Artikel</th><th>Anzahl</th>\n </tr>\n"; foreach($tmp as $key) { print "<tr>\n"; print "<td>".$key['a_name']. "</td><td>".$key['w_menge']."</td>\n"; print "</tr>\n"; } print "</table>\n"; } else print "Keine Artikel im Warenkorb gefunden."; } private function setArtikel($daten) { $this->pdf->SetLeftMargin(35); # Setzt Rand $this->pdf->Cell(30,5,"Artikelnummer",1,0,'C'); $this->pdf->Cell(60,5,"Artikel",1,0,'C'); $this->pdf->Cell(30,5,"Preis",1,0,'R'); foreach ($daten as $key => $value) { $this->pdf->ln(); $this->pdf->Cell(30,5,$key,1,0,'C'); $this->pdf->Cell(60,5,iconv('UTF-8', 'ISO-8859-15', $value['name']),1,0); $this->pdf->Cell(30,5,$value['preis']." Euro",1,0,'R'); } } public function pdfliste() { $this->pdf->setTitel("Liste bestellbarer Artikel"); $this->pdf->AliasNbPages(); $this->pdf->AddPage(); $this->pdf->SetFont('Times','',12); $text = "Sehr geehrter Kunde,\n\nvielen Dank, dass Sie sich". " für unser Angebot interessieren. Folgende Artikel". " können Sie in unserem Online-Shop (http://".$_SERVER['PHP_SELF'].") bestellen.\n"; $this->pdf->setText($text); $this->setArtikel($this->artikelArray); $text = "\n\nVielen Dank für Ihr Interesse."; $this->pdf->setText($text); $this->pdf->Output(); } } ?> [/PHP] [/QUOTE]

Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung

Wenn ★ = 12, ◇ = 4 und die Hälfte von ★ zu ◇ addiert wird, was ist das Ergebnis?