-
Notifications
You must be signed in to change notification settings - Fork 7
/
browse-results.html
82 lines (77 loc) · 3.66 KB
/
browse-results.html
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
<?php
include_once("config.inc.php");
$start = $_REQUEST['start'];
$perpage = $_REQUEST['perpage'];
$w = $_REQUEST['w'];
if((!$start || ($start < 0))) $start = 0;
if(!$perpage) $perpage = 30;
if(!$w) $w = "A";
elseif($perpage > 50) $perpage = 50;
elseif($perpage < 1) $perpage = 1;
$htmlpage = 2;
$ptitle = $w." Font Category";
include_once("header.php");
?>
<table width="500" cellpadding="3" cellspacing="0" align="center" style="margin-top:5px;"><tr height="25"><td align="center">
<?php
for ($i=65; $i<=90; $i++) {
$x = chr($i);
echo "<a href=\"b-$x.html\">$x</a> ";
}
echo "<a href=\"b-num.html\">#</a> ";
?>
</td></tr>
<tr><td align="center">
<?php
if($w == "num") $search = "name LIKE '0%' || name LIKE '1%' || name LIKE '2%' || name LIKE '3%' || name LIKE '4%' || name LIKE '5%' || name LIKE '6%' || name LIKE '7%' || name LIKE '8%' || name LIKE '9%'";
else $search = "name LIKE '$w%'";
$temp = mysql_query("SELECT id, name, fontfilename, downloads, rating FROM tblfonts WHERE $search ORDER BY name");
$totalresults = mysql_numrows($temp);
$temp = mysql_query("SELECT id, name, fontfilename, downloads, rating FROM tblfonts WHERE $search ORDER BY name LIMIT $start, $perpage");
if($start < $perpage) {
if($start > 0) echo "<a href=\"b-$w.html?start=0\"><< previous</a> ";
else echo "<font class=\"smallora2\"><< previous</font> ";
}
else {
echo "<a href=\"b-$w.html?start=".($start - $perpage)."\"><< previous</a> ";
}
if(($start+$perpage) < $totalresults) $tovalue = $start+$perpage;
else $tovalue = $totalresults;
echo "results ".($start+1)." to ".($tovalue)." of $totalresults";
if(($start + $perpage) > $totalresults) {
echo " <font class=\"smallora2\">next >></font> ";
}
else echo " <a href=\"b-$w.html?start=".($start + $perpage)."\">next >></a>";
?>
</td></tr></table><hr>
<table width="100%" cellpadding="3" cellspacing="0">
<?php
while($row = mysql_fetch_array($temp)) {
echo "<tr><td height='90' onClick=\"parent.location='font-$row[id]-".createhtmlname($row[name]).".html'\" style='background: white url(images/sample-bg.jpg) repeat-x bottom;'><table width='100%' cellpadding='0' cellspacing='0' height='100%'><tr><td style=\"background-image: url(get-thumb.php?thumbid=$row[id]);background-repeat: no-repeat; cursor: hand;\" height='100%'> </td></tr></table></td><td width=\"130\" height=\"90\" style=\"padding-left:10px;\" style='background: white url(images/sample-bg.jpg) repeat-x bottom;'><b>$row[name]</b><br>Rating: ";
echo $row[rating]/10;
echo "/10<br>Downloads: $row[downloads]<br><a href=\"font-$row[id]-".createhtmlname($row[name]).".html\">details</a> <font class=\"smallora\">|</font> <a href=\"download-$row[id]-".createhtmlname($row[name]).".zip\">download</a></td></tr>";
echo "<tr><td colspan=\"3\" height=\"1\" background=\"images/lines.gif\"></td></tr>";
}
?>
</table>
<table width="100%" cellpadding="3" cellspacing="0"><tr><td align="center">
<?php
if($start < $perpage) {
if($start > 0) echo "<a href=\"b-$w.html?start=0\"><< previous</a> ";
else echo "<font class=\"smallora2\"><< previous</font> ";
}
else {
echo "<a href=\"b-$w.html?start=".($start - $perpage)."\"><< previous</a> ";
}
if(($start+$perpage) < $totalresults) $tovalue = $start+$perpage;
else $tovalue = $totalresults;
echo "results ".($start+1)." to ".($tovalue)." of $totalresults";
if(($start + $perpage) > $totalresults) {
echo " <font class=\"smallora2\">next >></font> ";
}
else echo " <a href=\"b-$w.html?start=".($start + $perpage)."\">next >></a>";
?>
</td></tr></table>
<?php
include("footer.php");
?>