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
|
<? session_start();
if(!array_key_exists('user', $_SESSION))
{
header("Location: index.php");
exit;
}
?>
<html>
<head>
<link rel="stylesheet" href="../style.css" type="text/css" media="screen" />
<title></title>
</head>
<body>
<div id="container">
<div id="content">
<TABLE width="100%" border="0">
<TR>
<TD valign="top">
<TABLE>
<TR>
<td height="50"><H1><? echo str_replace("_", " ", $_GET['nomecat']); ?></H1></td>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<?
include("../setConn.php");
include("../class_utility.php");
$special = new class_utility();
$namedb = "Sql603025_1";
//PAGINE
$result = mysql_db_query($namedb, $sql, $db);
$count = mysql_query("SELECT COUNT(ID) FROM vignette");
$res_count = mysql_fetch_row($count);
// numero totale di records
$tot_records = $res_count[0];
// risultati per pagina(secondo parametro di LIMIT)
$per_page = 3;
// numero totale di pagine
$tot_pages = ceil($tot_records / $per_page);
// pagina corrente
$current_page = (!$_GET['page']) ? 1 : (int)$_GET['page'];
// primo parametro di LIMIT
$primo = ($current_page - 1) * $per_page;
//FINE PAGINE
if ($db == FALSE)
die ("Errore nella connessione.");
$sql = "SELECT * FROM vignette ORDER BY data DESC, ID DESC LIMIT $primo, $per_page";
$result = mysql_db_query($namedb, $sql, $db);
//Numero per colore sfondo
$i=0;
while($results = mysql_fetch_array($result)){
$sfondo="fotobianca";
if ( $i % 2 == 0 ) {
$sfondo="fotoblu";
}
echo "<DIV class=".$sfondo.">";
echo "<TABLE width='98%' cellpadding='0' cellspacing='0'><TR><TD>";
echo "<DIV align='justify'>".$special->specialChars($results["titolo"])."</DIV>";
if($results["miniatura"]!=''){
echo "<DIV align='justify'><img src='../../public/vignette/".$results["miniatura"]."' width='200'></DIV>";
}
echo "<DIV><A HREF='mod.php?ID=".$results["ID"]."&nomecat=VIGNETTE'><IMG SRC='../mod.jpg' WIDTH='20' HEIGHT='30' BORDER='0' ALT='Modifica'></A>";
echo " ";
echo "<A HREF='del.php?ID=".$results["ID"]."&nomecat=VIGNETTE'><IMG SRC='../cancella.jpg' WIDTH='20' HEIGHT='30' BORDER='0' ALT='Elimina'></A>";
echo " ";
echo "</DIV>";
echo "</TD></TR></TABLE>";
echo "</DIV>";
echo "<!-- RIGA -->";
echo "<hr>";
echo "<!-- Fine Notizia 1 -->";
$i++;
}
include("../paginazione.php");
// in questa cella inseriamo la paginazione
print "<table width='100%' height='20' border='0' cellpadding='0' cellspacing='0' class='articoli'>";
print " <tr>\n <td height=\"30\" valign=\"center\" align=\"center\" class=\"pagine\">$paginazione</td>\n";
print " </tr>\n</table>";
mysql_close($db);
?>
</div>
</div>
</body>
</html>
|