hi all PHP masters and newbies
i have a question about pagination. this news script displays 4 little images and links at the right side and one large image at the left side. and all the links submitted shows below.
i need let at the page displays 8 news with little images and pagination. for ex i have 100 news let it displays latest 8 of them and other will be enabled by click next or 2 page (pagination simly)
thanks for attention
<?php
require_once('auth.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Bismillah</title>
<script type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<p>
<?
include("connect.php");
include ("image_edit.php");
?>
</p>
<p style="font-size:24pt; color:#FF0000;">add news</p>
<hr />
Mesajlar :
<? //
$no=$_POST[no];
$title=$_POST[title];
$subject=$_POST[subject];
$explanation=$_POST[explanation];
$aktif=$_POST[aktif];
$search=$_POST[search];
$show=$_POST[show];
// image ayarlari burada
$large_image="haber_kucuk"; // open this folder
$little_image="haber_buyuk"; // give mode chmod 777
$large_image_en=300;
$large_image_boy=200;
$little_image_en=100;
$little_image_boy=75;
//if ($image)
?>
<? if ($_POST[delete])
{// if isset delete button
$query=mysql_query("select * from haber where no='$no'");
while($row=mysql_fetch_row($query))
{ @unlink($row[4]); //
@unlink($row[5]); //
}
if (mysql_query("delete from haber where no='$no'")) echo " deleted";
else echo "not deleted";
}
?>
<?
if ($_POST[edit])
{
//
$query=mysql_query("select * from haber where no='$no'");
while($row=mysql_fetch_row($query))
{
$no2=$row[0];
$title2=$row[1];
$subject2=$row[2];
$explanation2=$row[3];
$littleimage2=$row[4];
$image2=$row[5];
$aktif2=$row[7];
}
}
?>
<? if($_POST["add"])
{
if(strlen($_FILES["image"]["name"])>4)
{
$find=$_FILES["image"] ;
$to_be_finded = array('ç','Ç','ý','Ý','ð','Ð','ü','ö','Þ','þ','Ö','Ü',',',' ','(',')','[',']');
$change = array('c','C','i','I','g','G','u','o','S','s','O','U','','_','','','','');
$_FILES["image"]=str_replace($to_be_finded, $change, $find);
$image = "$haber_large_image_klasor/".$_FILES["image"]["name"];
move_uploaded_file($_FILES["image"]["tmp_name"],$image);
$littleimage = "$haber_little_image_klasor/".$_FILES["image"]["name"];
move_uploaded_file($_FILES["image"]["tmp_name"],$littleimage);
// little image resampling
$icerik = resample($image,$little_image_en,$little_image_boy);
$folder = fopen ($littleimage,"w+");
fwrite($folder,$icerik);
fclose($folder);
// large image resampling
$icerik = resample($image,$large_image_en,$large_image_boy);
$folder = fopen ($image,"w+");
fwrite($folder,$icerik);
fclose($folder);
}
if (!$no)
{
if (mysql_query("insert into haber values ('','$title','$subject','$explanation','$kucukimage','$image','$aktif')"))
{echo " changed"; $image="";$littleimage="";}
else echo "not changed!";
}
else
{ //
if ($image) $imageek="image='$image',littleimage='$littleimage'";
if (mysql_query("update haber set title='$title',subject='$subject',explanation='$explanation',aktif='$aktif'$imageek where no='$no'"))
{echo "added"; $image="";$littleimage="";}
else echo "not added";
}
}
?>
<hr />
<form id="form1" name="form1" method="post" action="">
News :
<label>
<select name="no" id="no">
<?
$query=mysql_query("select * from haber order by no desc");
while($row=mysql_fetch_row($query))
{
echo "<option value='$row[0]'>$row[1]</option>";
}
?>
</select>
</label>
<label>
<input name="edit" type="submit" id="edit" value="edit" />
</label>
<label>
<input name="delete" type="submit" id="delete" value="delete" />
</label>
<label></label>
</form>
<hr />
<form id="form2" name="form2" method="post" action="" enctype="multipart/form-data">
<table width="250" border="1" cellspacing="5" cellpadding="0">
<tr>
<td width="80">no
<input name="no" type="hidden" value="<? echo $no2; ?>" /></td>
<td width="100"><label></label> </td>
</tr>
<tr>
<td>image
<? if($littleimage2)
{echo "<img src=$littleimage2 align=right><br />";
}
?>
</td>
<td> <label>
<input name="image" type="file" id="image" />
</label></td>
</tr>
<tr>
<td>title</td>
<td><input name="title" type="text" id="title" value="<? echo $title2;?>" size="50" /></td>
</tr>
<tr>
<td>subject</td>
<td><input name="subject" type="text" id="subject" value="<? echo $subject2;?>" size="50" /></td>
</tr>
<tr>
<td>explanation</td>
<td><label>
<textarea name="explanation" cols="80" rows="5" id="is"><? echo $explanation2;?></textarea>
</label></td>
</tr>
<tr>
<td>Aktive</td>
<td><label>
<input <?php if ($aktif2=="aktif") {echo "checked=\"checked\"";} ?> name="aktif" type="radio" value="aktif" checked="checked" />
aktivate
<input <?php if ($aktif2=="pasif") {echo "checked=\"checked\"";} ?> name="aktif" type="radio" value="pasif" />
Passivate</label></td>
</tr>
<tr>
<td> </td>
<td><input name="add" type="submit" id="add" value="add" />
<label>
<input name="search" type="submit" id="search" value="search" />
<input name="show" type="submit" id="show" value="news show" />
</label></td>
</tr>
</table>
</form>
<p> </p>
<?
if (($search) || ($show))
{
if ($search)
{
if ($title) $query=mysql_query("select * from haber where title like '%$title%'");
if ($subject) $query=mysql_query("select * from haber where subject like '%$subject%'");
if ($explanation) $query=mysql_query("select * from haber where explanation like '%$explanation%'");
}
if ($show)
{
$query=mysql_query("select * from haber order by no desc");
}
echo "<table border=1>
<tr>
<td>Edit</td>
<td>delete</td>
<td>No</td>
<td>title</td>
<td>subject</td>
<td>explanation</td>
<td>littleimage</td>
<td>aktive</td>
</tr>";
while($row=mysql_fetch_row($query))
{echo "
<tr><form action=\"\" method=\"post\"><input name=\"no\" type=\"hidden\" value=\"$row[0]\">
<td><input name=\"edit\" type=\"submit\" value=\"change\"> </td>
<td><input name=\"delete\" type=\"submit\" value=\"delete\"></td>
<td>$row[0] </td>
<td>$row[1] </td>
<td>$row[2] </td>
<td>$row[3] </td>
<td><img src=$row[4]> </td>
<td>$row[6]</td>
</form> </tr>";
}
echo "</table>";
}
?>
<?php
echo "<a href=\"http://aziko.6te.net\"> return to the main page</a>";
?>
</body>
</html>