Kein Insert / Keine Fehlermeldung – SELFHTML-Forum Forum als Ergänzung zum SELFHTML-Wiki und zur Dokumentation SELFHTML https://forum.selfhtml.org/self Kein Insert / Keine Fehlermeldung Tue, 16 Apr 19 07:50:01 Z https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746827#m1746827 https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746827#m1746827 <p>Hallo,</p> <p>ich habe folgendes Insert und Update. Wenn ich einen neuen Eintrag erstellt passiert nichts, auch wird mir keine Fehlermeldung ausgegeben wenn ich</p> <pre><code class="block language-php"><span class="token function">error_reporting</span><span class="token punctuation">(</span><span class="token constant">E_ALL</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token function">ini_set</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'display_errors'</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">)</span><span class="token punctuation">;</span> </code></pre> <p>eingeschalten habe. Seht ihr vielleicht ein Fehler? Anzumerken ist noch ich habe in der Datenbank mehr Felder wie ich sie per Insert befülle, dieses muss ich doch nicht beachten? Wenn ein Wert nicht da ist wird dieser einfach übersprungen?</p> <pre><code class="block language-php"> <span class="token keyword">if</span><span class="token punctuation">(</span><span class="token keyword">isset</span><span class="token punctuation">(</span><span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'abschicken'</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">{</span> <span class="token variable">$artikelCode</span> <span class="token operator">=</span> <span class="token function">md5</span><span class="token punctuation">(</span><span class="token function">uniqid</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token keyword">if</span><span class="token punctuation">(</span><span class="token keyword">empty</span><span class="token punctuation">(</span><span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'a_titel'</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token variable">$errors</span><span class="token punctuation">[</span><span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"Bitte geben Sie einen Titel ein"</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token keyword">if</span><span class="token punctuation">(</span><span class="token keyword">isset</span><span class="token punctuation">(</span><span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'abschicken'</span><span class="token punctuation">]</span><span class="token punctuation">)</span> <span class="token operator">&&</span> <span class="token keyword">empty</span><span class="token punctuation">(</span><span class="token variable">$errors</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">if</span><span class="token punctuation">(</span><span class="token keyword">isset</span><span class="token punctuation">(</span><span class="token variable">$_GET</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'artikel'</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token variable">$stmt</span> <span class="token operator">=</span> <span class="token variable">$mysqli</span><span class="token operator">-></span><span class="token function">prepare</span><span class="token punctuation">(</span><span class="token string double-quoted-string">"Update artikel SET a_lager=?, a_lagerflaeche=?, a_titel=?, a_beschreibung=?, a_massel=?, a_masseb=?, a_tiefeb=?, a_masseinklverpackungl=?, a_masseinklverpackungb=?, a_tiefeinklverpackungb=?, a_gewicht=?, a_gewichtinklverpackung=?, a_sollbestand=?, a_istbestand=?, a_bestandgestohlen=?, a_status=?, a_hinzugefuegt=?, a_bearbeitet=?, a_istunterwegs=?, a_produzierterBestand=?, a_anummer=?, a_katID=?, a_zusatz=?, a_farbe=?, a_preis=?, a_was=? WHERE a_code = ?"</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token variable">$a_lager</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_lager"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_lagerflaeche</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_lagerflaeche"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_titel</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_titel"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_beschreibung</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_beschreibung"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_massel</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_massel"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_tiefeb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_tiefeb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseinklverpackungl</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseinklverpackungl"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseinklverpackungb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseinklverpackungb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_tiefeinklverpackungb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_tiefeinklverpackungb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_gewicht</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_gewicht"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_gewichtinklverpackung</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_gewichtinklverpackung"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_sollbestand</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_sollbestand"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_istbestand</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_bestandgestohlen</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_status</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_status"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_hinzugefuegt</span> <span class="token operator">=</span> <span class="token variable">$a_hinzugefuegt</span><span class="token punctuation">;</span> <span class="token variable">$a_bearbeitet</span> <span class="token operator">=</span> <span class="token function">time</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token variable">$a_istunterwegs</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_produzierterBestand</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_produzierterBestand"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_anummer</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_anummer"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_katID</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_katID"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_zusatz</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_zusatz"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_farbe</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_farbe"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_preis</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_preis"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_was</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"Möbel"</span><span class="token punctuation">;</span> <span class="token variable">$stmt</span><span class="token operator">-></span><span class="token function">bind_param</span><span class="token punctuation">(</span><span class="token string double-quoted-string">"sssssssssssssssssssssssssss"</span><span class="token punctuation">,</span> <span class="token variable">$a_lager</span><span class="token punctuation">,</span> <span class="token variable">$a_lagerflaeche</span><span class="token punctuation">,</span> <span class="token variable">$a_titel</span><span class="token punctuation">,</span> <span class="token variable">$a_beschreibung</span><span class="token punctuation">,</span> <span class="token variable">$a_massel</span><span class="token punctuation">,</span> <span class="token variable">$a_masseb</span><span class="token punctuation">,</span> <span class="token variable">$a_tiefeb</span><span class="token punctuation">,</span> <span class="token variable">$a_masseinklverpackungl</span><span class="token punctuation">,</span> <span class="token variable">$a_masseinklverpackungb</span><span class="token punctuation">,</span> <span class="token variable">$a_tiefeinklverpackungb</span><span class="token punctuation">,</span> <span class="token variable">$a_gewicht</span><span class="token punctuation">,</span> <span class="token variable">$a_gewichtinklverpackung</span><span class="token punctuation">,</span> <span class="token variable">$a_sollbestand</span><span class="token punctuation">,</span> <span class="token variable">$a_istbestand</span><span class="token punctuation">,</span> <span class="token variable">$a_bestandgestohlen</span><span class="token punctuation">,</span> <span class="token variable">$a_status</span><span class="token punctuation">,</span> <span class="token variable">$a_hinzugefuegt</span><span class="token punctuation">,</span> <span class="token variable">$a_bearbeitet</span><span class="token punctuation">,</span> <span class="token variable">$a_istunterwegs</span><span class="token punctuation">,</span> <span class="token variable">$a_produzierterBestand</span><span class="token punctuation">,</span> <span class="token variable">$a_anummer</span><span class="token punctuation">,</span> <span class="token variable">$a_katID</span><span class="token punctuation">,</span> <span class="token variable">$a_zusatz</span><span class="token punctuation">,</span> <span class="token variable">$a_farbe</span><span class="token punctuation">,</span> <span class="token variable">$a_preis</span><span class="token punctuation">,</span> <span class="token variable">$a_was</span><span class="token punctuation">,</span> <span class="token variable">$a_code</span> <span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span><span class="token punctuation">}</span> <span class="token comment">// Ende $_GET['artikel']</span> <span class="token keyword">else</span> <span class="token punctuation">{</span> <span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token variable">$stmt</span> <span class="token operator">=</span> <span class="token variable">$mysqli</span><span class="token operator">-></span><span class="token function">prepare</span><span class="token punctuation">(</span><span class="token string double-quoted-string">"INSERT INTO artikel ( a_code, a_lager, a_lagerflaeche, a_titel, a_beschreibung, a_massel, a_masseb, a_tiefeb, a_masseinklverpackungl, a_masseinklverpackungb, a_tiefeinklverpackungb, a_gewicht, a_gewichtinklverpackung, a_sollbestand, a_istbestand, a_bestandgestohlen, a_status, a_hinzugefuegt, a_bearbeitet, a_istunterwegs, a_produzierterBestand, a_anummer, a_katID, a_zusatz, a_farbe, a_preis, a_was) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token variable">$a_code</span> <span class="token operator">=</span> <span class="token variable">$artikelCode</span><span class="token punctuation">;</span> <span class="token variable">$a_lager</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_lager"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_lagerflaeche</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_lagerflaeche"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_titel</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_titel"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_beschreibung</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_beschreibung"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_massel</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_massel"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_tiefeb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_tiefeb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseinklverpackungl</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseinklverpackungl"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_masseinklverpackungb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_masseinklverpackungb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_tiefeinklverpackungb</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_tiefeinklverpackungb"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_gewicht</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_gewicht"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_gewichtinklverpackung</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_gewichtinklverpackung"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_sollbestand</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_sollbestand"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_istbestand</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_bestandgestohlen</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_status</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_status"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_hinzugefuegt</span> <span class="token operator">=</span> <span class="token variable">$a_hinzugefuegt</span><span class="token punctuation">;</span> <span class="token variable">$a_bearbeitet</span> <span class="token operator">=</span> <span class="token function">time</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token variable">$a_istunterwegs</span> <span class="token operator">=</span> <span class="token string double-quoted-string">""</span><span class="token punctuation">;</span> <span class="token variable">$a_produzierterBestand</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_produzierterBestand"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_anummer</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_anummer"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_katID</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_katID"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_zusatz</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_zusatz"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_farbe</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_farbe"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_preis</span> <span class="token operator">=</span> <span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string double-quoted-string">"a_preis"</span><span class="token punctuation">]</span><span class="token punctuation">;</span> <span class="token variable">$a_was</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"Möbel"</span><span class="token punctuation">;</span> <span class="token variable">$stmt</span><span class="token operator">-></span><span class="token function">bind_param</span><span class="token punctuation">(</span><span class="token string double-quoted-string">"sssssssssssssssssssssssssss"</span><span class="token punctuation">,</span> <span class="token variable">$a_code</span><span class="token punctuation">,</span> <span class="token variable">$a_lager</span><span class="token punctuation">,</span> <span class="token variable">$a_lagerflaeche</span><span class="token punctuation">,</span> <span class="token variable">$a_titel</span><span class="token punctuation">,</span> <span class="token variable">$a_beschreibung</span><span class="token punctuation">,</span> <span class="token variable">$a_massel</span><span class="token punctuation">,</span> <span class="token variable">$a_masseb</span><span class="token punctuation">,</span> <span class="token variable">$a_tiefeb</span><span class="token punctuation">,</span> <span class="token variable">$a_masseinklverpackungl</span><span class="token punctuation">,</span> <span class="token variable">$a_masseinklverpackungb</span><span class="token punctuation">,</span> <span class="token variable">$a_tiefeinklverpackungb</span><span class="token punctuation">,</span> <span class="token variable">$a_gewicht</span><span class="token punctuation">,</span> <span class="token variable">$a_gewichtinklverpackung</span><span class="token punctuation">,</span> <span class="token variable">$a_sollbestand</span><span class="token punctuation">,</span> <span class="token variable">$a_istbestand</span><span class="token punctuation">,</span> <span class="token variable">$a_bestandgestohlen</span><span class="token punctuation">,</span> <span class="token variable">$a_status</span><span class="token punctuation">,</span> <span class="token variable">$a_hinzugefuegt</span><span class="token punctuation">,</span> <span class="token variable">$a_bearbeitet</span><span class="token punctuation">,</span> <span class="token variable">$a_istunterwegs</span><span class="token punctuation">,</span> <span class="token variable">$a_produzierterBestand</span><span class="token punctuation">,</span> <span class="token variable">$a_anummer</span><span class="token punctuation">,</span> <span class="token variable">$a_katID</span><span class="token punctuation">,</span> <span class="token variable">$a_zusatz</span><span class="token punctuation">,</span> <span class="token variable">$a_farbe</span><span class="token punctuation">,</span> <span class="token variable">$a_preis</span><span class="token punctuation">,</span> <span class="token variable">$a_was</span> <span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span><span class="token punctuation">}</span> <span class="token variable">$stmt</span><span class="token operator">-></span><span class="token function">execute</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'abschicken'</span><span class="token punctuation">]</span> <span class="token operator">==</span> <span class="token string single-quoted-string">'Artikel speichern'</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token variable">$targetURL</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"artikel-uebersicht.php"</span><span class="token punctuation">;</span> <span class="token comment">//header("Location: $targetURL");</span> <span class="token punctuation">}</span> <span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token variable">$_POST</span><span class="token punctuation">[</span><span class="token string single-quoted-string">'abschicken'</span><span class="token punctuation">]</span> <span class="token operator">==</span> <span class="token string single-quoted-string">'auf Seite bleiben'</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token variable">$targetURL</span> <span class="token operator">=</span> <span class="token string double-quoted-string">"artikel-insert.php?artikel=<span class="token interpolation"><span class="token variable">$artikelCode</span></span>"</span><span class="token punctuation">;</span> <span class="token function">header</span><span class="token punctuation">(</span><span class="token string double-quoted-string">"Location: <span class="token interpolation"><span class="token variable">$targetURL</span></span>"</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token keyword">else</span> <span class="token punctuation">{</span> <span class="token keyword">echo</span> <span class="token variable">$mysqli</span> <span class="token operator">-></span> <span class="token property">error</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span><span class="token punctuation">;</span> </code></pre> Kein Insert / Keine Fehlermeldung Tue, 16 Apr 19 08:21:28 Z https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746839#m1746839 https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746839#m1746839 <p>Tach!</p> <blockquote> <p>ich habe folgendes Insert und Update. Wenn ich einen neuen Eintrag erstellt passiert nichts, auch wird mir keine Fehlermeldung ausgegeben wenn ich</p> <pre><code class="block language-php"><span class="token function">error_reporting</span><span class="token punctuation">(</span><span class="token constant">E_ALL</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token function">ini_set</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'display_errors'</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">)</span><span class="token punctuation">;</span> </code></pre> <p>eingeschalten habe.</p> </blockquote> <p>Datenbank-Fehler sind keine PHP-Fehler. Die PHP-Meldungen zu konfigurieren bringt dafür nichts. Man kann DBMS-Fehlermeldungen einerseits händisch holen, so wie du es bereits für das Prepare gemacht hast. Das Execute lässt du aber unbeachtet. Auch das meldet, wenn Fehler beim Ausführen auftraten, über seinen Rückgabewert. Andererseits kann man zumindest, wenn man PDO verwendet, konfigurieren, dass für DBMS-Fehler PHP-Exceptions geworfen werden. Ob mysqli das auch kann, weiß ich grad nicht.</p> <blockquote> <p>Anzumerken ist noch ich habe in der Datenbank mehr Felder wie ich sie per Insert befülle, dieses muss ich doch nicht beachten? Wenn ein Wert nicht da ist wird dieser einfach übersprungen?</p> </blockquote> <p>Kommt darauf an, was für das Feld konfiguriert ist. Wenn NULL erlaubt ist, wird das eingetragen, wenn nicht, gibt es einen Fehler. Es sei denn, es ist ein Default-Wert konfiguriert, dann wird der genommen.</p> <p>dedlfix.</p> Kein Insert / Keine Fehlermeldung Tue, 16 Apr 19 08:30:36 Z https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746841#m1746841 https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746841#m1746841 <p>Hallo,</p> <blockquote> <p>Das Execute lässt du aber unbeachtet. Auch das meldet, wenn Fehler beim Ausführen auftraten, über seinen Rückgabewert.</p> </blockquote> <p>Danke für den Hinweis. Hab es nun so gemacht</p> <pre><code class="block language-php"><span class="token variable">$FehlerExecute</span> <span class="token operator">=</span> <span class="token variable">$stmt</span><span class="token operator">-></span><span class="token function">execute</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token constant boolean">false</span><span class="token operator">===</span><span class="token variable">$FehlerExecute</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">die</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'Fehler beim execute: '</span> <span class="token operator">.</span> <span class="token function">htmlspecialchars</span><span class="token punctuation">(</span><span class="token variable">$stmt</span><span class="token operator">-></span><span class="token property">error</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> </code></pre> <p>Jetzt erhalte ich folgende Meldung</p> <blockquote> <p>Fehler beim execute: Column 'a_hinzugefuegt' cannot be null</p> </blockquote> <p>Das heißt, das Feld a_hinzugefuegt darf nicht leer sein, richtig?</p> <p><strong>Nachtrag, sollte man</strong></p> <ol> <li>stmt</li> <li>bind_param</li> </ol> <p>auch auf Fehler abfragen oder reicht execute=</p> Kein Insert / Keine Fehlermeldung Tue, 16 Apr 19 09:19:05 Z https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746855#m1746855 https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746855#m1746855 <p>Hallo Bernd,</p> <p>jeder mysqli-Aufruf, bei dem in der Doku steht, dass er im Fehlerfall einen speziellen Wert liefert, kann auch auf einen Fehler laufen. Ob Du sinnvoll aus dem Fehler herauskannst, oder nur loggen und abbrechen, ist natürlich eine andere Frage.</p> <p>Also: Prepare, Bind und Execute müssen allesamt überprüft werden.</p> <p>Um deinen Code übersichtlicher zu machen, könntest Du das Befüllen der gebundenen Variablen vorziehen (a_lager bis a_was). Wenn Du den Insert etwas änderst, so dass a_code als letztes in der Column-Liste steht (das geht, auch wenn die Table ein anderes Layout hat), dann sollten auch beide Parameter-Binds identisch sein und du brauchst den Bind nicht zu doppeln.</p> <p><em>Rolf</em></p> <div class="signature">-- <br> sumpsi - posui - clusi </div> Kein Insert / Keine Fehlermeldung Tue, 16 Apr 19 13:33:17 Z https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746884#m1746884 https://forum.selfhtml.org/self/2019/apr/16/kein-insert-strich-keine-fehlermeldung/1746884#m1746884 <blockquote> <blockquote> <p>Fehler beim execute: Column 'a_hinzugefuegt' cannot be null</p> </blockquote> <p>Das heißt, das Feld a_hinzugefuegt darf nicht leer sein, richtig?</p> </blockquote> <p>Nein das ist falsch geschlussfolget. Denn: Null und Leer(string) sind nicht dasselbe. Wenn Du bei der Datenerfassung nicht sicherstellen kannst daß für alle Felder Daten geliefert werden, ist ggf. ein default sinnvoll. MFG</p>