lo script funziona solo la prima volta non so come restituirgli i valori postati con il get ho provato con if ma niente qualcuno mi può dare qualche dritta?
<?PHP
//pagina attuale
$page= $_GET['page'];
$actualpage = $page;
//vecchia pagina
$lastpage = $_GET['lastpage'];
//se il get nn mi restituisce nessun valore laspage = 1 e page = 1
if ($lastpage == NULL){
$page = 1;
}
if ($page == NULL){
$page = 1;
}
//connessione al server e query
$nomeserver = "localhost";
$username = "";
$password = "";
$dbname = "my_rbrtone81";
$tablename = "immagini";
$myconn = mysql_connect($nomeserver);
$mydb = mysql_select_db($dbname,$myconn);
$mycountsql = "SELECT COUNT(*) FROM $tablename";
$result = mysql_query($mycountsql);
$total = mysql_result($result, 0, 0);
$limit = 2;
$numpages=ceil($total/$limit);
$offset = $_GET['offset'];
if ($offset == NULL){
$offset = 0;
}
$my_var2_sql = "SELECT * FROM $tablename LIMIT $offset , $limit";
$myquery = mysql_query($my_var2_sql,$myconn);
//se la vecchia pagina è prima dell'attuale
if($lastpage < $page){
while($myvalues = mysql_fetch_array($myquery)){
$io=$offset ;
$cartella = "images/";
$newfile = "temp/".$myvalues["file"];
$immagine = $myvalues["file"];
copy($cartella.$immagine, $newfile);
list($current_width, $current_height) = getimagesize($newfile);
$left = $current_width/2;
$top = $current_height/2;
$crop_width = 80;
$crop_height = 80;
$canvas = imagecreatetruecolor($crop_width, $crop_height);
$current_image = imagecreatefromjpeg($newfile);
imagecopy($canvas, $current_image, 0, 0, $left, $top, $current_width, $current_height);
$img = imagejpeg($canvas, $newfile, 100);
if ($img == 1) {
$cartellal = "big.php?immagine=$cartella$immagine";
$larghezza = 60;
echo "<a href=\"javascript:finestra('$cartellal', '$img');\"><img src=\"$newfile\" height=\"$larghezza\" </a>";
}
$io++;
}
$offset = $io;
}
// se la vecchia pagina è quella successiva
if($lastpage > $page){
while($myvalues = mysql_fetch_array($myquery)){
$io=$offset;
$cartella = "images/";
$newfile = "temp/".$myvalues["file"];
$immagine = $myvalues["file"];
copy($cartella.$immagine, $newfile);
list($current_width, $current_height) = getimagesize($newfile);
$left = $current_width/2;
$top = $current_height/2;
$crop_width = 80;
$crop_height = 80;
$canvas = imagecreatetruecolor($crop_width, $crop_height);
$current_image = imagecreatefromjpeg($newfile);
imagecopy($canvas, $current_image, 0, 0, $left, $top, $current_width, $current_height);
$img = imagejpeg($canvas, $newfile, 100);
if ($img == 1) {
$cartellal = "big.php?immagine=$cartella$immagine";
$larghezza = 60;
echo "<a href=\"javascript:finestra('$cartellal', '$img');\"><img src=\"$newfile\" height=\"$larghezza\" </a>";
}
$io--;
}
$offset = $io;
}
if ($page == 1)
echo "Previous";
else
echo "<a href=\"visualizzazione_file.php?page=" . ($page - 1) . "&lastpage=".$actualpage."&offset=".$offset."\">Pr evious</a>";
for ($i = 1; $i <= $numpages; $i++) {
echo " | ";
if ($i == $page)
echo "Page $i";
else
echo "<a href=\"visualizzazione_file.php?page=$i&lastpage=$ actualpage&offset=$offset\">Page $i</a>";
}
if ($page == $numpages)
echo "Next";
else
echo "<a href=\"visualizzazione_file.php?page=" . ($page + 1) ."&lastpage=".$actualpage."&offset=".$offset."\">N ext</a>";
mysql_close($myconn);
?>
Rispondi quotando