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Ö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Ö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