Problem beim auslesen aus db in eine tabelle

    Hallo Leute,


    Ich kann meine Ergebnisse leider nicht in eine Tabelle einlesen :/
    Meine SQL-Anweisung ist richtig (im phpmyadmin überprüft) und außerdem stimmt auch die ganze mysql anweisung. ($return kann ich nähmlich mit dem gewünschten inhalt ausgeben lassen :P)


    PHP
    <span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /></span><span class="syntaxkeyword">if(</span><span class="syntaxdefault"> $_SERVER</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'SERVER_ADDR'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> </span><span class="syntaxstring">"127.0.0.1"</span><span class="syntaxdefault"> OR $_SERVER</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'SERVER_ADDR'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> </span><span class="syntaxstring">"::1"</span><span class="syntaxdefault"> </span><span class="syntaxcomment">/* localhost */</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'localhost'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_USER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'root'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_PASS'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">''</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_NAME'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'p-schuster.sarkkan.de'</span><span class="syntaxkeyword">);</span><span class="syntaxdefault"> </span><span class="syntaxcomment">#DATENBANKname!<br /></span><span class="syntaxkeyword">}<br />else<br /></span><span class="syntaxcomment">//mein webserver<br /></span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'***'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_USER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'***'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_PASS'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'***'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    define</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_NAME'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'***'</span><span class="syntaxkeyword">);</span><span class="syntaxdefault"> </span><span class="syntaxcomment">#Datenbankname!<br /></span><span class="syntaxkeyword">}<br /></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_USER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_PASS</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">//verbindung zu MySQL wird hergestellt<br /></span><span class="syntaxdefault">mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_NAME</span><span class="syntaxkeyword">);<br /></span><span class="syntaxcomment">//datenbank wird ausgewählt<br /><br />//im beispiel wollen wir etwas aus der datenbank heraushohlen<br /></span><span class="syntaxdefault">$SQL </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT `page`, `inhalt`, `zugehoerigkeit` FROM `phip-tutorial`;"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$query </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $SQL </span><span class="syntaxkeyword">);<br /></span><span class="syntaxcomment">// sql-code wird an mysql übergeben<br /><br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">'<table border="1">'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<tr>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<td>PAGE</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<td>INHALT</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<td>ZUGE&Ouml;RIGKEIT</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"</tr>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$return </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$query</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">));<br />{<br /></span><span class="syntaxdefault">  echo </span><span class="syntaxstring">"<tr>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">  echo </span><span class="syntaxstring">"<td>"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $return</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'page'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">  echo </span><span class="syntaxstring">"<td>"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $return</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'inhalt'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">  echo </span><span class="syntaxstring">"<td>"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $return</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'zugehoerigkeit'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"</td>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">  echo </span><span class="syntaxstring">"</tr>"</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"</table>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">?><br /></span></span>


    Ergebnis im Browser:

    Code
    <table border="1"><tr><td>PAGE</td><td>INHALT</td><td>ZUGE&Ouml;RIGKEIT</td></tr><tr><td></td><td></td><td></td></tr></table>


    Nochmals:
    Am Ende kann ich via

    PHP
    <span class="syntaxdefault"><br />print_r</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$result</span><span class="syntaxkeyword">);</span><span class="syntaxdefault"> ausgeben lassen und der inhalt stimmt auch</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">habe da die while</span><span class="syntaxkeyword">-</span><span class="syntaxdefault">schleife weggelassen</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span>


    Außerdem sage ich hier an der stelle einfach nochmal das die SQL-anweisung im php my admin gut funktioniert.


    Danke für antworten,
    Gruß
    Phip

    PHP
    <span class="syntaxdefault"></span><span class="syntaxkeyword">while (</span><span class="syntaxdefault">$return </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$query</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">)); </span><span class="syntaxdefault"></span>


    Man kann auch mal ein Semikolon zu viel setzen ;)


    richtig wäre:


    PHP
    <span class="syntaxdefault"></span><span class="syntaxkeyword">while (</span><span class="syntaxdefault">$return </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$query</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">)) </span><span class="syntaxdefault"></span>


    Grüße


    PS: Bei Sachen mit Datenbanken immer mal nen SQL-Dump der entsprechenden Tabelle mit posten bitte, damit man ausprobieren kann!

    Kleinigkeit, aber falls es doch wichtig ist und dir noch nicht aufgefallen:


    Code
    echo "<td>ZUGE&Ouml;RIGKEIT</td>";


    in

    Code
    echo "<td>ZUGEH&Ouml;RIGKEIT</td>";


    ändern...


    Gruß :)

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!

Benutzerkonto erstellen Anmelden