Kann man an der Geschwindigkeit irgendetwas optimieren?
Mein Script schaut ja nur, ob der gewünschte Eintrag vorhanden ist und wenn ja, dann "zieht" es den in meine Seite rein.
Ich habe gehört, dass das MEGA-CMS mit Template-Engine in Dustins Agentur in einer Sekunde alle schafft....da kann es doch nicht so bleiben, dass mein Miniscript auch eine Sekunde Laufzeit hat (Xampp).
Schaut euch bitte einfach mal den Code an und sagt mir bitte, wie man ihn schneller machen/optimieren könnte.
PHP
<span class="syntaxhtml"><br /><section><br /> <span class="syntaxdefault"><?php<br /> </span><span class="syntaxcomment">//Datenbankszugriffsdaten auswählen<br /></span><span class="syntaxdefault"> include</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">"include/xampp_www.php"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> $pageID </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> htmlentities</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $_GET</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'pageID'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">#bereinigen<br /><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">//variablenzuweisung via MySQL<br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'error'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> false</span><span class="syntaxkeyword">;</span><span class="syntaxdefault"> </span><span class="syntaxcomment"># kein Fehler<br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'connection'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </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_USER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_PASS </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'database'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_NAME </span><span class="syntaxkeyword">);<br /><br /><br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">$mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'connection'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> OR </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">$mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'database'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'error'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> true</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># MySQL Fehler<br /><br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'error_mes'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">'<p><strong>'</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_errno</span><span class="syntaxkeyword">()</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">': </strong>'</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">()</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">'</p>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /><br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault">$mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'error'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'query'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT `ID` , `Inhalt` FROM `cms_daten` WHERE<br /> `ID` = '"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $pageID </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"'<br /> LIMIT 1;"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'return'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'query'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'num_rows'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'return'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># mysql_num_rows zählt die anzahl<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># der zurückgegebenen zeilen,<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># da wir "LIMIT 1" angaben gilt:<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># 1 = daten stimmen<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># 0 = daten stimmen nicht<br /><br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 1 </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'num_rows'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">#wenn 'datei' vorhanden ist<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $rückgabewert </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_assoc</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'return'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> echo $rückgabewert</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Inhalt'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">#betreffende spalte<br /><br /></span><span class="syntaxdefault"> mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'return'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">#speicher wird freigegeben<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else<br /> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">//404 includen<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment"># 404 nicht in datenbank nehmen<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Datei nicht vorhanden"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else<br /> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> print </span><span class="syntaxstring">'<p>Leider gab es einen internen Fehler: '</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $mysql</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'error_mes'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">'</p>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /><br /></span><span class="syntaxdefault"> ?><br /></span> </section><br /></span>
MfG Phip S.