Gegen Bilderklau - Das Original | Homepagehilfe - Archiv | [PHP & MySQL] html tags verbietn hilfe! :[

<?php include("rheader.php"); ?> <?php if ($_REQUEST['searchingred']) { $searchingred = $_REQUEST['searchingred']; } if ($_REQUEST['pagenum']) {$pagenum = $_REQUEST['pagenum'];} $searchingred = mysql_real_escape_string($searchingred); $pagenum = mysql_real_escape_string($pagenum); $sql = "select * from search_terms where term = '$searchingred'"; $result = mysql_query($sql ,$db); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_row($result); $count = $row[1]; $newcount = $count + 1; $sql = "update search_terms set count = $newcount where term = '$searchingred'"; } else { $sql = "insert into search_terms (term, count) values ('$searchingred', 1)"; } $result = mysql_query($sql ,$db); ?> <TD VALIGN=top width="60%" BGCOLOR="000000"> <TABLE BORDER=0 WIDTH=99% ALIGN=CENTER> <TR> <TD VALIGN=top> <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% BGCOLOR=000000> <TR><TD align=center><FONT SIZE=2 FACE="Verdana,arial,helvetica" color=white><B>Gefunden</B></FONT></TD></tR> </TABLE> <FONT SIZE=2> <p><center> <img src="suche2.jpg"></font><FONT face=arial size=2 color=0099CC></b></br><b><FONT face=arial size=8><?php printf($searchingred); ?></font><FONT face=arial size=8></font></center></p> <table cellspacing=0 cellpadding=2 border=0> <tr> <th width=300 bgcolor=#0099CC align=center><FONT face=arial size=2><b>Wallpaper</font></th> <th width=85 bgcolor=#0099CC align=center><FONT face=arial size=2><b<Datum</font></th> <th width=75 bgcolor=#0099CC align=center><FONT face=arial size=2><b>Bewertung</font></th> </tr> <?php $sql = "select distinct wallpaperid from wallpaper where title like '%$searchingred%'"; $result = mysql_query($sql ,$db); $numrows = mysql_numrows($result); $lastpage = false; if ($pagenum == 0) { $startrow = 0; } else { $startrow = 25 * $pagenum; } if ($numrows < $startrow + 25) { $endrow = $numrows; $lastpage = true; } $sql = "select distinct wallpaperid from wallpaper where title like '%$searchingred%' limit $startrow,25"; $result = mysql_query($sql ,$db); $wallpapercount = 1; if ($myrow = mysql_fetch_array($result)) { do { $wallpaperid[$wallpapercount] = $myrow["wallpaperid"]; $wallpapercount++; } while ($myrow = mysql_fetch_array($result)); } if (count($wallpaperid) == 0) { printf("<tr><td colspan=3><p><center><FONT face=arial size=3><b>Es wurde leider nichts gefunden.</b></font></center></p></td></tr>"); } else { $rowcolor = 1; for ($d = 1; $d <= count($wallpaperid); $d++) { $sql = "select wallpaperid, title, date, rating, status from wallpaper where wallpaperid = $wallpaperid[$d]"; $result = mysql_query($sql ,$db); if ($myrow = mysql_fetch_array($result)) { do { if ($myrow["status"] == "L") { if ($rowcolor == 1) { $rowcolorhex = "#ffffff"; $rowcolor = 0; } else { $rowcolorhex = "#ffffff"; $rowcolor = 1; } printf("<tr>"); printf("<td width=300 bgcolor=%s align=center><FONT face=arial size=2><a href=wallpaper.php?wallpaperid=%s>%s</a></font></td>", $rowcolorhex, $myrow["wallpaperid"], $myrow["title"]); printf("<td width=80 bgcolor=%s align=center><FONT face=arial size=2>%s</font></td>", $rowcolorhex, $myrow["date"]); printf("<td width=75 bgcolor=%s><table bgcolor=%s border=0 cellspacing=0 cellpadding=0><tr>", $rowcolorhex, $rowcolorhex); $onstars = round($myrow["rating"]); $offstars = 5 - $onstars; for ($i = 1; $i <= $onstars; $i++) { printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staron2.gif></font></td>", $rowcolorhex); } for ($f = 1; $f <= $offstars; $f++) { printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staroff2.gif></font></td>", $rowcolorhex); } printf("</tr></table></td>"); printf("</tr>"); } } while ($myrow = mysql_fetch_array($result)); } } } printf("<tr>"); if ($startrow > 0) { printf("<td align=left><FONT face=arial size=2><a href=results.php?pagenum=%s&searchingred=%s>Previous Page</a></font></td>", $pagenum-1, $searchingred); } else { printf("<td> </td>"); } printf("<td> </td>"); if ($lastpage == false) { printf("<td align=left><FONT face=arial size=2><a href=results.php?pagenum=%s&searchingred=%s>Next Page</a></font></td>", $pagenum+1, $searchingred); } else { printf("<td> </td>"); } printf("</tr>"); ?> </table> <br><center><font size=8 face='Arial'><b>Weiter Suchen</b></font> <br></br></br><form action=results.php method=post><input type=text name=searchingred size=40> <input type=submit value=Los!></form> </center> </FONT> </TD></TR></TABLE> </TD> <?php include("rfooter.php"); ?>

php:

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:

<?php include("rheader.php"); ?>


<?php

   if ($_REQUEST['searchingred']) { $searchingred = $_REQUEST['searchingred']; }
   if ($_REQUEST['pagenum']) {$pagenum = $_REQUEST['pagenum'];}

   $searchingred = mysql_real_escape_string($searchingred);
   $pagenum = mysql_real_escape_string($pagenum);

   $sql = "select * from search_terms where term = '$searchingred'";

   $result = mysql_query($sql ,$db);

   if (mysql_num_rows($result) > 0) {

      $row = mysql_fetch_row($result);
      $count = $row[1];
      $newcount = $count + 1;
      $sql = "update search_terms set count = $newcount where term = '$searchingred'";

   } else {

      $sql = "insert into search_terms (term, count) values ('$searchingred', 1)";

   }

   $result = mysql_query($sql ,$db);
     
?>

<TD VALIGN=top width="60%" BGCOLOR="000000">

<TABLE BORDER=0 WIDTH=99% ALIGN=CENTER>
<TR>

<TD VALIGN=top>

<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% BGCOLOR=000000>
<TR><TD align=center><FONT SIZE=2 FACE="Verdana,arial,helvetica" color=white><B>Gefunden</B></FONT></TD></tR>
</TABLE>

<FONT SIZE=2>

                   <p><center> <img src="suche2.jpg"></font><FONT face=arial size=2 color=0099CC></b></br><b><FONT face=arial size=8><?php printf($searchingred); ?></font><FONT face=arial size=8></font></center></p>

                  <table cellspacing=0 cellpadding=2 border=0>
                     <tr>
                        <th width=300 bgcolor=#0099CC align=center><FONT face=arial size=2><b>Wallpaper</font></th>
                        <th width=85 bgcolor=#0099CC align=center><FONT face=arial size=2><b<Datum</font></th>
                        <th width=75 bgcolor=#0099CC align=center><FONT face=arial size=2><b>Bewertung</font></th>
                     </tr>

                     <?php

                        $sql = "select distinct wallpaperid from wallpaper where title like '%$searchingred%'";

                        $result = mysql_query($sql ,$db);
                        $numrows = mysql_numrows($result);

                        $lastpage = false;

                        if ($pagenum == 0) {
                           $startrow = 0;
                        } else {
                           $startrow = 25 * $pagenum;
                        }

                        if ($numrows < $startrow + 25) {
                           $endrow = $numrows;
                           $lastpage = true;
                        }

                        $sql = "select distinct wallpaperid from wallpaper where title like '%$searchingred%' limit $startrow,25";

                        $result = mysql_query($sql ,$db);

                        $wallpapercount = 1;

                        if ($myrow = mysql_fetch_array($result)) {

                           do {

                              $wallpaperid[$wallpapercount] = $myrow["wallpaperid"];
                              $wallpapercount++;

                           } while ($myrow = mysql_fetch_array($result));

                        }

                        if (count($wallpaperid) == 0) {

                           printf("<tr><td colspan=3><p><center><FONT face=arial size=3><b>Es wurde leider nichts gefunden.</b></font></center></p></td></tr>");

                        } else {

                           $rowcolor = 1;

                           for ($d = 1; $d <= count($wallpaperid); $d++) {

                                 $sql = "select wallpaperid, title, date, rating, status from wallpaper where wallpaperid = $wallpaperid[$d]";

                              $result = mysql_query($sql ,$db);

                              if ($myrow = mysql_fetch_array($result)) {

                                 do {

                                    if ($myrow["status"] == "L") {

                                       if ($rowcolor == 1) {
                                          $rowcolorhex = "#ffffff";
                                          $rowcolor = 0;
                                       } else {
                                          $rowcolorhex = "#ffffff";
                                          $rowcolor = 1;
                                       }


                                       printf("<tr>");
                                       printf("<td width=300 bgcolor=%s align=center><FONT face=arial size=2><a href=wallpaper.php?wallpaperid=%s>%s</a></font></td>", $rowcolorhex, $myrow["wallpaperid"], $myrow["title"]);
                                       printf("<td width=80 bgcolor=%s align=center><FONT face=arial size=2>%s</font></td>", $rowcolorhex, $myrow["date"]);
                                       printf("<td width=75 bgcolor=%s><table bgcolor=%s border=0 cellspacing=0 cellpadding=0><tr>", $rowcolorhex, $rowcolorhex);

                                       $onstars = round($myrow["rating"]);
                                       $offstars = 5 - $onstars;

                                       for ($i = 1; $i <= $onstars; $i++) {
                                          printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staron2.gif></font></td>", $rowcolorhex);
                                       }

                                       for ($f = 1; $f <= $offstars; $f++) {
                                          printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staroff2.gif></font></td>", $rowcolorhex);
                                       }

                                       printf("</tr></table></td>");
                                       printf("</tr>");

                                    }

                                 } while ($myrow = mysql_fetch_array($result));

                              }

                           }
                        }

                        printf("<tr>");
                        if ($startrow > 0) {
                           printf("<td align=left><FONT face=arial size=2><a href=results.php?pagenum=%s&searchingred=%s>Previous Page</a></font></td>", $pagenum-1, $searchingred);
                        } else {
                           printf("<td>&nbsp;</td>");
                        }
                           printf("<td>&nbsp;</td>");
                        if ($lastpage == false) {
                           printf("<td align=left><FONT face=arial size=2><a href=results.php?pagenum=%s&searchingred=%s>Next Page</a></font></td>", $pagenum+1, $searchingred);
                        } else {
                           printf("<td>&nbsp;</td>");
                        }
                        printf("</tr>");



                     ?>
                  </table>

                  <br><center><font size=8 face='Arial'><b>Weiter Suchen</b></font>
                  <br></br></br><form action=results.php method=post><input type=text name=searchingred size=40>&nbsp;<input type=submit value=Los!></form>
                  </center>

</FONT>

</TD></TR></TABLE>

</TD>


<?php include("rfooter.php"); ?>

addwallpaper.php bannerclick.php category.php common.php config.php creatuser.php dbx.php dlwallpaper.php forgot.php index.php listuserwallpaper.php login.php logout.php newuser.php results.php footer.php header.php savewallpaper.php search.php senddetails.php subscribe.php unsubscribe.php wallpaper.php