MySQL Verbindung klappt. (habe testausgaben machen lassen)
Daten in Datenbank stimmen auch. (Mehrmals überprüft)
Allerding loggts mich nie ein [Falsche Angaben wird ausgegeben]
Weiß jemand warum?
Hier Code:
PHP
<span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /><br /> </span><span class="syntaxcomment">/*------datenbank zugriff-----*/<br /> </span><span class="syntaxkeyword">include( </span><span class="syntaxstring">"include/db-zugriff_xampp.php" </span><span class="syntaxkeyword">);<br /><br /> </span><span class="syntaxdefault">$db_link </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_BENUTZER</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">$db_sel </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_select_db</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">MYSQL_DATENBANK </span><span class="syntaxkeyword">) OR die(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">$SQL </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"SELECT * FROM `logindaten`;"</span><span class="syntaxkeyword">;<br /> </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$SQL </span><span class="syntaxkeyword">);<br /><br /> if ( ! </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">)<br /> {<br /> die( </span><span class="syntaxstring">'Ungültige Abfrage: ' </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">mysql_error</span><span class="syntaxkeyword">( ) );<br /> }<br /><br /> </span><span class="syntaxdefault">$zeile </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">);<br /><br /><br /><br /> </span><span class="syntaxcomment">/*-----------LOGIN-SCRIPT------------*/<br /><br /> //session wurde hier schon auf der index gestartet<br /><br /> </span><span class="syntaxkeyword">if( </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Button'</span><span class="syntaxkeyword">] != </span><span class="syntaxstring">"" </span><span class="syntaxkeyword">)<br /> {<br /><br /> if( </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Benutzername'</span><span class="syntaxkeyword">] != </span><span class="syntaxstring">"" </span><span class="syntaxkeyword">AND </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Passwort'</span><span class="syntaxkeyword">] != </span><span class="syntaxstring">"" </span><span class="syntaxkeyword">)<br /> </span><span class="syntaxcomment">//wenn beides ausgefüllt ist<br /> </span><span class="syntaxkeyword">{<br /> </span><span class="syntaxdefault">$Benutzername </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Benutzername'</span><span class="syntaxkeyword">];<br /> </span><span class="syntaxdefault">$Passwort </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Passwort'</span><span class="syntaxkeyword">];<br /> </span><span class="syntaxdefault">$Passwort </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">md5</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$Passwort</span><span class="syntaxkeyword">);<br /> }<br /><br /> if( </span><span class="syntaxdefault">$Benutzername </span><span class="syntaxkeyword">== </span><span class="syntaxdefault">$zeile</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Benutzername'</span><span class="syntaxkeyword">] AND </span><span class="syntaxdefault">$Passwort </span><span class="syntaxkeyword">== </span><span class="syntaxdefault">$zeile</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Passwort'</span><span class="syntaxkeyword">] )<br /> {<br /> </span><span class="syntaxdefault">$_SESSION</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eingeloggt'</span><span class="syntaxkeyword">] = </span><span class="syntaxdefault">TRUE</span><span class="syntaxkeyword">;<br /> </span><span class="syntaxdefault">header</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Location: http://localhost/in_development/p-schuster.sarkkan.de/cms/index.php'</span><span class="syntaxkeyword">);<br /> die();<br /> </span><span class="syntaxcomment">//muss immer angepasst werden; entweder XAMPP oder WWW<br /> </span><span class="syntaxkeyword">}<br /> else<br /> {<br /> echo </span><span class="syntaxstring">"Falsche angaben"</span><span class="syntaxkeyword">;<br /> }<br /> }<br /><br /> </span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">?><br /></span><form action="<span class="syntaxdefault"><?php </span><span class="syntaxkeyword">echo </span><span class="syntaxdefault">$_SERVER</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">]; </span><span class="syntaxdefault">?></span>" method="post"><br /> <fieldset><br /> <legend>Einloggformular</legend><br /> <input type="text" name="Benutzername" id="Benutzername" /><br /> <input type="password" name="Passwort" id="Passwort" /><br /> <input type="submit" name="Button" /><br /> </fieldset><br /></form><br /></span>