SQLITE3 - Paging, Refresh, Alphabetische Reihenfolge, Buchstabenauswahl verbauen

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • SQLITE3 - Paging, Refresh, Alphabetische Reihenfolge, Buchstabenauswahl verbauen

    Hallo zusammen,

    kann mir ein erfahrener PHP Coder die oben beschriebenen Funktionen verbauen? Ich wäre sehr sehr dankbar für Hilfe.
    Das Script sieht folgendermaßen aus:
    Spoiler anzeigen

    PHP-Quellcode

    1. <?php
    2. echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\"\n";
    3. echo " \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n";
    4. echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">\n";
    5. echo "<head>\n";
    6. echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />\n";
    7. echo "<title>Scripte</title>\n";
    8. echo "<link href=\"css/styles.css\" rel=\"stylesheet\" type=\"text/css\" />\n";
    9. echo "</head>\n";
    10. echo "\n";
    11. echo "<body>\n";
    13. function refresh($content="") {
    14. echo "<META HTTP-EQUIV=Refresh CONTENT=\"".$content."\"; URL=\"scripts.php\">";
    15. }
    17. if(!($db=new SQLite3('sqlite/scripts.sqlite3', '0666')))
    18. {
    19. echo "<h2>Fehler</h2>";
    20. die();
    21. }
    23. echo "<table id=\"mytable\" cellspacing=\"0\" summary=\"Scriptauflistung\">\n";
    24. echo " <caption>\n";
    25. echo " <a href=\"scripts.php?action=add\">[Eintragen]</a>\n";
    26. echo " </caption>\n";
    27. echo " <tr>\n";
    28. echo " <th scope=\"col\" abbr=\"Name\" class=\"nobg\">Name</th>\n";
    29. echo " <th scope=\"col\" abbr=\"Version\">Version</th>\n";
    30. echo " <th scope=\"col\" abbr=\"Allinkwith\">Allinkwith</th>\n";
    31. echo " <th scope=\"col\" abbr=\"Boerse\">Boerse</th>\n";
    32. echo " <th scope=\"col\" abbr=\"MyGully\">MyGully</th>\n";
    33. echo " <th scope=\"col\" abbr=\"Leecher\">Leecher</th>\n";
    34. echo " <th scope=\"col\" abbr=\"Aktion\">Aktion</th>\n";
    35. echo " </tr>\n";
    37. $scriptname=$db->escapeString(@$_REQUEST['scriptname']);
    38. $scriptversion=$db->escapeString(@$_REQUEST['scriptversion']);
    39. $up_aiw=$db->escapeString(@$_REQUEST['up_aiw']);
    40. $up_boerse=$db->escapeString(@$_REQUEST['up_boerse']);
    41. $up_mygully=$db->escapeString(@$_REQUEST['up_mygully']);
    42. $up_leecher=$db->escapeString(@$_REQUEST['up_leecher']);
    44. $result=$db->query("SELECT id,scriptname,scriptversion,up_aiw,up_boerse,up_mygully,up_leecher FROM scripts ORDER BY scriptversion;");
    46. $i=0;
    47. while( $row=$result->fetchArray(SQLITE3_ASSOC) )
    48. {
    49. if($i>0)
    50. {
    52. }
    53. echo " <tr>\n";
    54. echo " <th scope=\"row\" abbr=\"Model\" class=\"spec\">".htmlspecialchars($row['scriptname'])."</th>\n";
    55. echo " <td class=\"version\">".htmlspecialchars($row['scriptversion'])."</td>\n";
    56. echo " <td><a href=\"".htmlspecialchars($row['up_aiw'])."\" target=\"_blank\"><img src=\"http://g.etfv.co/".htmlspecialchars($row['up_aiw'])."\" alt=\"n/a\" width=\"16\" height=\"16\" /></a></td>\n";
    57. echo " <td><a href=\"".htmlspecialchars($row['up_boerse'])."\" target=\"_blank\"><img src=\"http://g.etfv.co/".htmlspecialchars($row['up_boerse'])."\" alt=\"n/a\" width=\"16\" height=\"16\" /></a></td>\n";
    58. echo " <td><a href=\"".htmlspecialchars($row['up_mygully'])."\" target=\"_blank\"><img src=\"http://g.etfv.co/".htmlspecialchars($row['up_mygully'])."\" alt=\"n/a\" width=\"16\" height=\"16\" /></a></td>\n";
    59. echo " <td><a href=\"".htmlspecialchars($row['up_leecher'])."\" target=\"_blank\"><img src=\"http://g.etfv.co/".htmlspecialchars($row['up_leecher'])."\" alt=\"n/a\" width=\"16\" height=\"16\" /></a></td>\n";
    60. echo " <td><a href=\"scripts.php?action=del&amp;id=".$row['id']."\"><img src=\"img/delete.png\" alt=\"Del\" title=\"Löschen\" width=\"16\" height=\"16\" /></a> <a href=\"scripts.php?action=edit&amp;id=".$row['id']."\"><img src=\"img/edit.png\" alt=\"Edit\" title=\"Bearbeiten\" width=\"16\" height=\"16\" /></a></td>\n";
    61. echo " </tr>\n";
    63. $i++;
    65. }
    66. echo "</table>";
    68. //START: Eintrag einfügen
    69. if(@$_REQUEST['action']=="add") {
    71. if($scriptname!="") {
    72. $db->query("INSERT INTO scripts (scriptname,scriptversion,up_aiw,up_boerse,up_mygully,up_leecher) VALUES('$scriptname','$scriptversion','$up_aiw','$up_boerse','$up_mygully','$up_leecher')");
    73. }
    74. echo "<h3>Eintrag</h3>\n";
    75. echo "<form action=\"scripts.php\" method=\"get\">\n";
    76. echo "<input type=\"hidden\" name=\"action\" value=\"add\">\n";
    77. echo " <table id=\"mytable\" cellspacing=\"0\" summary=\"Scriptauflistung\">\n";
    78. echo " <tr>\n";
    79. echo " <th class=\"nobg\"><img src=\"img/textfield.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> Scriptname:</th>\n";
    80. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"scriptname\"></th>\n";
    81. echo " </tr>\n";
    82. echo " <tr>\n";
    83. echo " <th class=\"nobg\"><img src=\"img/textfield.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> Version:</th>\n";
    84. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"scriptversion\"></th>\n";
    85. echo " </tr>\n";
    86. echo " <tr>\n";
    87. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> AIW Link:</th>\n";
    88. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_aiw\"></th>\n";
    89. echo " </tr>\n";
    90. echo " <tr>\n";
    91. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> BOERSE Link:</th>\n";
    92. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_boerse\"></th>\n";
    93. echo " </tr>\n";
    94. echo " <tr>\n";
    95. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> MYGULLY Link:</th>\n";
    96. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_mygully\"></th>\n";
    97. echo " </tr>\n";
    98. echo " <tr>\n";
    99. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> LEECHER Link:</th>\n";
    100. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_leecher\"></th>\n";
    101. echo " </tr>\n";
    102. echo " <tr>\n";
    103. echo " <th class=\"nobg\"></th>\n";
    104. echo " <th class=\"nobg\"><input type=\"submit\" border=\"0\" value=\"Eintragen\"></th>\n";
    105. echo " </tr>\n";
    106. echo " </table>\n";
    107. echo "</form>\n";
    108. }
    110. //START: Eintrag Speichern
    111. if(@$_REQUEST['action']=="save")
    112. {
    113. $db->query("UPDATE scripts
    114. SET scriptname = '$scriptname', scriptversion = '$scriptversion', up_aiw = '$up_aiw', up_boerse = '$up_boerse', up_mygully = '$up_mygully', up_leecher = '$up_leecher'
    115. WHERE id=".round($_REQUEST['id']));
    116. refresh("0");
    117. }
    119. //START: Eintrag löschen
    120. if(@$_REQUEST['action']=="del")
    121. {
    122. $result=$db->query("SELECT id,scriptname,scriptversion,up_aiw,up_boerse,up_mygully,up_leecher FROM scripts WHERE id=".round($_REQUEST['id']));
    123. $row=$result->fetchArray(SQLITE3_ASSOC);
    124. echo "<h3>Löschen</h3>\n";
    125. echo "<form action=\"scripts.php\" method=\"post\">\n";
    126. echo "<input type=\"hidden\" name=\"action\" value=\"delok\">\n";
    127. echo "<input type=\"hidden\" name=\"id\" value=\"".$row['id']."\">\n";
    128. echo "<strong>".$row['scriptname']."</strong> wirklich löschen?<br /><input type=\"submit\" border=\"0\" value=\"Ja, löschen!\">";
    129. echo "</form>\n";
    130. }
    132. //START: Eintrag löschen OK
    133. if(@$_REQUEST['action']=="delok")
    134. {
    135. $db->query("DELETE FROM scripts WHERE id=".round($_REQUEST['id']));
    136. echo "<h3>Erolgreich gelösch</h3>\n";
    137. refresh("1");
    138. }
    140. //START: Eintrag editieren
    141. if(@$_REQUEST['action']=="edit")
    142. {
    143. $result=$db->query("SELECT id,scriptname,scriptversion,up_aiw,up_boerse,up_mygully,up_leecher FROM scripts WHERE id=".round($_REQUEST['id']));
    144. $row=$result->fetchArray(SQLITE3_ASSOC);
    145. echo "<h3>Bearbeiten</h3>\n";
    146. echo "<form action=\"scripts.php\" method=\"post\">\n";
    147. echo "<input type=\"hidden\" name=\"action\" value=\"save\">\n";
    148. echo "<input type=\"hidden\" name=\"id\" value=\"".$row['id']."\">\n";
    149. echo " <table id=\"mytable\" cellspacing=\"0\" summary=\"Scriptauflistung\">\n";
    150. echo " <tr>\n";
    151. echo " <th class=\"nobg\"><img src=\"img/textfield.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> Scriptname:</th>\n";
    152. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"scriptname\" value=\"".$row['scriptname']."\"></th>\n";
    153. echo " </tr>\n";
    154. echo " <tr>\n";
    155. echo " <th class=\"nobg\"><img src=\"img/textfield.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> Version:</th>\n";
    156. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"scriptversion\" value=\"".$row['scriptversion']."\"></th>\n";
    157. echo " </tr>\n";
    158. echo " <tr>\n";
    159. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> AIW Link:</th>\n";
    160. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_aiw\" value=\"".$row['up_aiw']."\"></th>\n";
    161. echo " </tr>\n";
    162. echo " <tr>\n";
    163. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> BOERSE Link:</th>\n";
    164. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_boerse\" value=\"".$row['up_boerse']."\"></th>\n";
    165. echo " </tr>\n";
    166. echo " <tr>\n";
    167. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> MYGULLY Link:</th>\n";
    168. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_mygully\" value=\"".$row['up_mygully']."\"></th>\n";
    169. echo " </tr>\n";
    170. echo " <tr>\n";
    171. echo " <th class=\"nobg\"><img src=\"img/link.png\" alt=\"n/a\" width=\"16\" height=\"16\" /> LEECHER Link:</th>\n";
    172. echo " <th class=\"nobg\"><input type=\"text\" size=\"30\" name=\"up_leecher\" value=\"".$row['up_leecher']."\"></th>\n";
    173. echo " </tr>\n";
    174. echo " <tr>\n";
    175. echo " <th class=\"nobg\"></th>\n";
    176. echo " <th class=\"nobg\"><input type=\"submit\" border=\"0\" value=\"Bearbeiten\"></th>\n";
    177. echo " </tr>\n";
    178. echo " </table>\n";
    179. echo "</form>\n";
    180. }
    182. // Schließen
    183. $db->close();
    185. echo "<p><a href=\"index.php\">Startseite</a></p>\n";
    186. echo "</body>\n";
    187. echo "</html>\n";
    188. echo "\n";
    189. echo "</body>\n";
    190. echo "</html>\n";
    191. ?>
    Alles anzeigen


    Refresh:
    [php]if(@$_REQUEST['action']=="add") {[/php]
    Nach dem Eintragen soll ein Refresh erfolgen und somit auf Hauptseite wieder landen.
    Wenn ich das Refresh einbaue, dann fügt er durchgehen Einträge hinzu, dass soll nicht passieren.
    Nach "einem" Eintrag, soll der Refresh erfolgen.

    Paging:
    Eine Paging-Funktion, womit man beispielsweise nur 10 Einträge anzeigt und mit
    << < [1] [2] ......
    Zu vorherigen oder nächsten Einträge springen kann

    Buchstabenauswahl:
    Eine Auswahl der Buchstaben wäre ebenfalls super
    [#] [A] ....
    Somit nur Einträge mit den jeweiligen Buchstabe angezeigt werden

    Alphabetische Reihenfolge
    Eine Alphabetische Reihenfolge für die Einträge wäre auch super