Php datei nur Link und Titel anzeige

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

  • Php datei nur Link und Titel anzeige

    Sorry Jungz wusste nicht wie ich es beschreiben soll gg


    Habe folgendes Problem

    ich möchte das diese Datei die ich hier poste nur den Titel mit Link ausgibt. Was muss ich weglassen bzw was muss übrig bleiben?


    Momentan gibt diese Script mehrere Sachen aus wie: Name, gepostet am, Voten, ID, Beschreibung, Fromat etc.
    Also wie gesagt ich möchte das Sie nur ausgibt

    Titel und LINK

    Quellcode

    1. <?
    2. #################################################
    3. # xLinks 2002 #
    4. #################################################
    5. # © by Robert Klikics | http://x-dev.de #
    6. # eMail: rob@x-dev.de #
    7. #################################################
    8. # License: GPL #
    9. # please don't remove this copyright - thx #
    10. #################################################
    11. # FILE: view.php #
    12. #################################################
    14. // die if !$cat
    15. if(!$cat) die("<h4>Script says: \"I need a category to show!!!\" ");
    16. #======================================================================#
    17. # the includes & mySQL-conn
    18. #======================================================================#
    19. require("./inc/conf.inc.php"); // cfg
    20. require("./inc/connect.php"); // mySQL
    21. require("./lang/$language"); // language-file
    22. include("./inc/head.inc"); // header
    24. //set table-vars
    25. $table_linkdata = $db_prefix."linkdata";
    26. $table_cat = $db_prefix."cat";
    27. $table_votes = $db_prefix."votes";
    28. $table_languages = $db_prefix."languages";
    29. //Connect to mySQL
    30. $conn = @MYSQL_CONNECT($server, $user, $pass);
    31. //Select DB
    32. @MYSQL_SELECT_DB($mydb) or die ("<h1>Database '$mydb' does not exist or mySQL is not connected!<p>Please check your settings ...</h1>");
    33. //Check
    34. if(!$conn) die("<h1>mySQL-Connection-Error<br>Check your settings ...</h1>");
    35. #======================================================================#
    36. # add vote to db & check if already voted
    37. #======================================================================#
    38. if($yourvote)
    39. {
    40. //save vote in db
    41. $sql = "INSERT INTO $table_votes (vote, link_id, cat)";
    42. $sql.= "VALUES ('$yourvote', '$id', '$cat')";
    43. MYSQL_QUERY($sql);
    45. //vote counter +1
    46. MYSQL_QUERY("UPDATE $table_linkdata SET hp_votes = hp_votes + 1 WHERE id = $id");
    48. // generate actual vote-count and put into "LINKDATA-->hp_votes"
    49. $result = MYSQL_QUERY("SELECT vote FROM $table_votes WHERE link_id = $id");
    50. $anzahl = MYSQL_NUM_ROWS($result);
    51. while ($row = MYSQL_FETCH_ARRAY($result)) { $allvotes = $allvotes + $row[vote]; } // summary of votes for an id
    52. if($anzahl == 1) $allvotes = $yourvote; // set $allvotes to 1, if it's the first one
    53. $av_votes = round($allvotes / $anzahl, 1); // get & round the average-votes
    55. // put $av_votes to db
    56. MYSQL_QUERY("UPDATE $table_linkdata SET hp_vote = $av_votes WHERE id = $id");
    59. // show auto-link if vote added
    60. echo <<<end_xx
    61. <meta http-equiv="refresh" content="2; URL=$PHP_SELF?cat=$cat&s=$s">
    62. <table width="100%" border="0" cellspacing="3" cellpadding="3" height="95%">
    63. <tr valign="middle" align="center">
    64. <td>
    65. end_xx;
    66. echo "\n<font size='2'>".VIEW_VOTE_AUTOLINK."</b>\n";
    67. echo "<p>[ <a href='$PHP_SELF?cat=$cat&s=$s'>link</a> ]";
    68. echo <<<end_x
    69. </td>
    70. </tr>
    71. </table>
    72. </body>
    73. </html>
    74. end_x;
    75. exit;
    76. } // endif $yourvote
    78. #======================================================================#
    79. # get data from db by right order ...
    80. #======================================================================#
    81. if(($cat) && (!$yourvote))
    82. {
    83. if($sort == "new" || $incatsort == "id") { $incatsort = "id"; $sortby = "DESC"; $act_sort = VIEW_SORTING_NEW; } // sorting by old/new
    84. if($sort == "old") { $incatsort = "id"; $sortby = "ASC"; $act_sort = VIEW_SORTING_OLD; }
    85. if($sort == "vote" || $incatsort == "hp_vote") { $incatsort = "hp_vote"; $sortby = "DESC"; $act_sort = VIEW_SORT_BY_VOTE; } //sort by rating
    86. if($sort == "hits" || $incatsort == "hp_votes") { $incatsort = "Hits"; $sortby = "DESC"; $act_sort = VIEW_SORT_BY_HITS; } //sort by hits
    87. if($sort == "name" || $incatsort == "name") { $incatsort = "name"; $sortby = "ASC"; $act_sort = VIEW_SORTING_NAME; } //sort by name
    89. //when searching
    90. if($cat == "search") {
    91. $result = MYSQL_QUERY("SELECT * FROM $table_linkdata WHERE name LIKE \"%$q%\" order by $incatsort $sortby LIMIT 0,$max_search "); // get seach-query's to $max_search
    92. $scnt = MYSQL_NUM_ROWS($result);
    93. } else {
    94. if(!$s) { $showfrom = 0; $datasets = $perpage; // params for default--output (on 1 page)
    95. } else {
    96. $showfrom = $s; $datasets = $perpage; } // set params for page--output (multiple pages)
    98. // get total number of links in a cat
    99. $countz = MYSQL_QUERY("SELECT COUNT(id) FROM $table_linkdata WHERE cat = $cat ");
    100. $anz = MYSQL_RESULT($countz,0);
    101. MYSQL_FREE_RESULT($countz); //mem
    103. $result = MYSQL_QUERY("SELECT * FROM $table_linkdata WHERE cat = $cat order by $incatsort $sortby LIMIT $showfrom,$datasets "); //get linkdata
    105. } //endif $search
    106. #======================================================================#
    107. # javascript for jump-menu
    108. #======================================================================#
    109. ?>
    110. <script language='javascript'>
    111. <!--
    112. // jump-menu
    113. function jumper(targ,selObj,restore)
    114. {
    115. eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
    116. if (restore) selObj.selectedIndex=0;
    117. }
    118. //-->
    119. </script>
    120. <p>
    121. <table width="100%" border="0" cellspacing="3" cellpadding="3" height="95%">
    122. <tr valign="middle" align="center">
    123. <td>
    125. <table border='0' cellspacing='1' cellpadding='1' align='center' width='<?=$linkwidth?>'>
    126. <tr>
    127. <td align='center'>
    128. <?
    129. #======================================================================#
    130. # render cat-info & some NAVI-links
    131. #======================================================================#
    132. if($cat != "search") //show not if searching
    133. {
    134. $hello = MYSQL_QUERY("SELECT * FROM $table_cat WHERE id = $cat"); // get cat-info
    135. $world = MYSQL_FETCH_ARRAY($hello);
    136. echo "\n\n<!-- powered by xLinks [ © http://x-dev.de - get it there ] -->\n\n";
    137. echo "<h4>$listname | ".VIEW_BEFORE_CAT_TXT." '$world[name]'</h4>\n"; // print cat-info
    138. echo "</td>\n</tr>\n";
    139. MYSQL_FREE_RESULT($hello); // give memory free
    140. } else {
    141. echo "<h4>$listname | ".SEARCH_RESULTS." $q ($max_search max.)</h4>\n"; } // print search-resluts header
    145. #======================================================================#
    146. # render output-table for each link
    147. #======================================================================#
    148. if(!$scnt && $cat == "search") echo SEARCH_NO_RESULTS; // msg if no search-results found
    150. //function to generate the <select>-field for 'vote'
    151. function VoteSelect()
    152. {
    153. global $PHP_SELF;
    154. global $cat;
    155. global $row;
    156. global $s;
    157. // <select> for vote
    158. echo "\t<select name='a_vote' onchange=\"jumper('self',this,0)\">\n";
    159. echo "\t<option>".VIEW_VOTE_SELECT."\n";
    160. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=1'>1 - ".VIEW_BADDEST_VOTE."\n";
    161. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=2'>2\n";
    162. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=3'>3\n";
    163. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=4'>4\n";
    164. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=5'>5\n";
    165. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=6'>6\n";
    166. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=7'>7\n";
    167. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=8'>8\n";
    168. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=9'>9\n";
    169. echo "\t<option value='$PHP_SELF?cat=$cat&id=$row[id]&s=$s&yourvote=10'>10 - ".VIEW_BEST_VOTE."\n";
    170. echo "\t</select>\n";
    171. }
    173. while ($row = MYSQL_FETCH_ARRAY($result))
    174. {
    175. // get date of posting and format as set
    176. if($timeformat == 1) $pd = strftime("%d.%m.%Y", $row[poster_time]);
    177. elseif($timeformat == 2) $pd = strftime("%A, %d-%m-%Y %R", $row[poster_time]);
    178. elseif($timeformat == 3) $pd = strftime("%d-%m-%Y", $row[poster_time]);
    179. else $pd = strftime("%Y-%d-%m", $row[poster_time]);
    181. //strip-slashes
    182. if($html == "ON")
    183. {
    184. $row[hp_desc] = stripslashes($row[hp_desc]);
    185. $row[name] = stripslashes($row[name]);
    186. $row[url] = stripslashes($row[url]);
    187. $row[poster_name] = stripslashes($row[poster_name]);
    188. $row[poster_email] = stripslashes($row[poster_email]);
    189. }
    191. // include design.inc.php and render table's
    192. include("inc/design.inc.php");
    193. }
    194. MYSQL_FREE_RESULT($result); // give memory free
    195. } //endif $cat
    196. ?>
    198. <br>
    199. <table border='0' align='center' width='<?=$linkwidth?>'>
    200. <tr>
    201. <td align='left'><a href='javascript:scroll(0,0)'><?=VIEW_LINK_TOP;?></a></td>
    202. <td align='right'>
    204. <?
    205. // <select> for catjump
    206. echo VIEW_CATJUMP_SEL."&nbsp;";
    207. echo "<select name='mycatisjumping' onchange=\"jumper('self',this,0)\" onmouseover='this.focus()'>\n";
    208. echo "<option value=''>".ADD_HP_CAT_SELECT."\n";
    209. $sweet = MYSQL_QUERY("SELECT * FROM $table_cat order by $catorder");
    211. while ($cats = MYSQL_FETCH_ARRAY($sweet))
    212. {
    213. if($cats[id] != $cat) echo "<option value='$PHP_SELF?cat=$cats[id]&sort=$sort'>$cats[name]\n"; // render cat-selection
    215. }
    216. MYSQL_FREE_RESULT($sweet); // give memory free
    217. echo "</select>\n";
    218. ?>
    219. </td>
    220. </tr>
    221. </table>
    223. <br>
    224. <table border='0' align='center' width='<?=$linkwidth?>'>
    225. <tr>
    226. <td align='center'>
    227. <?
    228. #======================================================================#
    229. # navigation @ page bottom of the cat-view
    230. # (only if not searching)
    231. #======================================================================#
    232. if($cat != "search")
    233. {
    234. //var's
    235. $ges = $anz / $perpage;
    236. if(is_integer($ges)) $pgcnt = $ges;
    237. else $pgcnt = $ges + 1; // get page-counter in a cat
    238. //$lastpg = $anz - $perpage; // $s of last page
    239. $actpg = $s / $perpage + 1; // get number of actual page
    240. $sh_to = $showfrom + $perpage; // $s for next page
    241. $sh_strt = $showfrom - $perpage; // $s for prev. page
    242. if($sh_to > $anz) $sh_to = $anz; // ---- "" ----
    243. if($sort) $linkvar = "&sort=$sort"; // string for sorting if set
    245. //output
    246. if($s) echo "[ <a href='$PHP_SELF?cat=$cat&s=$sh_strt$linkvar'><</a> ] ::\n";
    248. echo "<b>[</b> ".VIEW_LINKS_PAGE." $actpg ".VIEW_LINKS_FROM." ".sprintf("%d","$pgcnt")." <b>]</b> ";
    250. if($s + $perpage < $anz) echo ":: [ <a href='$PHP_SELF?cat=$cat&s=$sh_to$linkvar'>></a> ]\n";
    252. } //endif $q
    253. // HTML:
    254. ?>
    255. </td>
    256. </tr>
    257. </table>
    259. </td>
    260. </tr>
    261. </table>
    262. <?
    263. #======================================================================#
    264. # footer &
    265. # END OF FILE
    266. #======================================================================#
    267. // PLEASE DONT CHANGE THIS [for dev]
    268. #################################################################################################################
    269. echo "\n<!-- some copyright, please don't remove :: thank you [ http://x-dev.de ] -->\n"; #
    270. echo "\n<p align='center'>&copy; <a href='jump.php?id=x' target='_blank'>xLinks</a> 2002\n"; # #
    271. //disconnect from mySQL #
    272. MYSQL_CLOSE(); #
    273. #################################################################################################################
    274. include("./inc/foot.inc");
    275. ?>
    Alles anzeigen


    Danke für eure Mühe

  • wow, man soll nicht schlecht über Andere reden, aber wenn der Code dir wäre, dann würde ich dir sagen, dass der Code einen extrem schlechten Stil hat!

    das include (in der while Schleife) wird das design enthalten. Da musst du die entsprechenden Ausgaben löschen. Das wirst du vermutlich selbst hinbekommen.

    Generell sollte es dir keine Probleme machen, ausfindig zu machen, wo was ausgeben wird.

  • Ok danke jungz kann mir aber mal jemand sagen wieso es jetzt nur im Internet Explorer korrekt angezeigt wird und im Mozilla Browser nicht

    Im Mozilla springt er nach jedem 12ten Titel Zeichen in die nächst Zeile

    das ist der Code den ich jetzt so bearbeitet habe

    Quellcode

    1. <?
    2. // render output-table
    3. echo "\n<br>\n";
    4. echo "\n<!-- TABLE FOR ID #$row[id] -->\n";
    6. echo "<table border='0' cellspacing='1' cellpadding='1' align='center' width='500' id='view_unique_table'>\n";
    7. echo "\t<tr>\n\t<td colspan='3'>\n\t".NAME_MARKER_FOR_VIEW."<a href='jump.php?id=$row[id]' target='_blank'><font size='2'><b>$row[name]</b></font></a>\n\t</td>\n\t<td align='right'>ID $row[id]\n\t</td>\n\t</tr>\n";
    8. echo "\t<tr>\n\t<td id='view_desc_td' colspan='5'>\n\t$row[hp_desc]\n\t</td>\n\t</tr>\n";
    10. echo "\t<tr>\n";
    11. echo "\t<td width='25%'>".VIEW_HITS_TXT." <b>$row[Hits]</b></td>\n";
    13. echo "\t</td>\n";
    14. echo "\t</tr>\n";
    16. echo "</table>\n";
    17. // end output-table
    19. ?>
    Alles anzeigen



    und das ist der Original Code

    Quellcode

    1. <?
    2. // render output-table
    3. echo "\n<br>\n";
    4. echo "\n<!-- TABLE FOR ID #$row[id] -->\n";
    6. echo "<table border='0' cellspacing='1' cellpadding='1' align='center' width='$linkwidth' id='view_unique_table'>\n";
    7. echo "\t<tr>\n\t<td colspan='3'>\n\t".NAME_MARKER_FOR_VIEW."<a href='jump.php?id=$row[id]' target='_blank'><font size='2'><b>$row[name]</b></font></a>\n\t</td>\n\t<td align='right'>ID $row[id]\n\t</td>\n\t</tr>\n";
    8. echo "\t<tr>\n\t<td colspan='5'>\n\t<b>".URL_MARKER_FOR_VIEW."</b> <a href='jump.php?id=$row[id]' target='_blank'>$row[url]</a> <b>".URL_MARKER_FOR_VIEW."</b> $row[hp_lang] <b>".URL_MARKER_FOR_VIEW."</b> ".VIEW_ADDED_LINK." $pd\n\t</td>\n\t</tr>\n";
    9. echo "\t<tr>\n\t<td id='view_desc_td' colspan='5'>\n\t$row[hp_desc]\n\t</td>\n\t</tr>\n";
    11. echo "\t<tr>\n";
    12. echo "\t<td width='25%'>".VIEW_HITS_TXT." <b>$row[Hits]</b></td>\n";
    13. echo "\t<td width='25%'>".VIEW_VOTE_TXT." <b>$row[hp_vote]</b> ($row[hp_votes] ".VIEW_VOTES_TXT.")</td>\n";
    14. echo "\t<td width='25%'>".VIEW_POSTED_BY." <a href='mailto:$row[poster_email]'>$row[poster_name]</a></td>\n";
    15. echo "\t<td width='25%' align='right'>\n";
    16. VoteSelect(); //function to render <select>
    17. echo "\t</td>\n";
    18. echo "\t</tr>\n";
    20. echo "</table>\n";
    21. // end output-table
    23. ?>
    Alles anzeigen