Fetch all record form image table and create form as per record on a single page. and submit form on button. With the following example code u can place multiple submit form on single page and submit single form according to button submit. display form with pagination.
This example will help in understand pagination in php.
<!--
Javascript Function for submit Form
-->
<script language="javascript">
function function1(theForm){
theForm.submit();
}
</script>
<?php
$dbc=mysql_connect('hostname','username','password');
mysql_select_db('databasename',$dbc);
$start=$_REQUEST['startPostion'];
$display=20;
if(isset($start)&&is_numeric($start)){
$startNo=trim($start);
}else{
$startNo=0;
}
/*
Get TotalNo of Images in images table for calculate the no of pages
*/
$selCount="select count(id) from images where status='Ok'";
$countRs=mysql_query($selCount,$dbc);
$count=mysql_fetch_row($countRs);
if($count[0]>$display){
$pages=ceil($count[0]/$display);
}else{
$pages=1;
}
if($pages>1){
$currentPage=($startNo/$display)+1;
$stPageNo=$currentPage-4;
$endPageNo=(($currentPage+5)<$pages)? $currentPage+5 : $pages;
if($currentPage!=1){
echo '<a href="imageManager.php?startPostion='.($startNo-$display).'"><span class="nextpre">Previous </span></a>';
}
for($i=$stPageNo;$i<=$endPageNo;$i++){
if($i>0){
if($i==$currentPage){
echo '<span class="currpagingNo">'.$i.' '.'</span>';
}else{
echo '<a href="imageManager.php?startPostion='.($display*($i-1)).'"><span class="pagingNo">'.$i.' '.'</span></a>';
}
}
} echo '<span class="nextpre">...of '.$pages.'</span>';
if($currentPage!=$pages){
echo '<a href="wallpaperManager.php?startPostion='.($startNo+$display).'"><span class="nextpre">Next</span></a>';
}
}
?>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="360" align="center"><span class="style1">Wallpaper Detail </span> </td>
<td width="72" align="center"><span class="style1">Added Date</span> </td>
<td align="center"><span class="style1">Action </span></td>
</tr>
<?php
$selImage="select * from images where status='Ok' limit $startNo,$display";
$imageResult=mysql_query($selImage,$dbc);
while($row=mysql_fetch_row($imageResult)){
?>
<tr>
<td height="150" valign="top" >
<table width="340" border="1" cellspacing="0" cellpadding="0">
<form id="form1" name="forms<?php echo $row[0]; ?>" method="post" action="imageManager.php">
<tr>
<td width="80"> <span class="style1">Title</span> </td>
<td width="254">
<input type="text" name="photo_title" size="50" value="<?php echo $row[1]; ?>"> <input type="hidden" name="ask" value="activate" >
</td>
</tr>
<tr>
<td width="80"> <span class="style1">Description</span> </td>
<td width="254">
<input type="text" name="photo_desi" size="50" value="<?php echo $row[2]; ?>"> <input type="hidden" name="ask" value="activate" >
</td>
</tr>
</form>
</table>
</td>
<td align="center"><span id="textstyle"><?php echo $row[3]; ?></span></td>
<td align="center" width="38" valign="middle"><img src="../../All Users/Documents/images/yes.png" border="0" title="Activate" onclick="function1(forms<?php echo $row[0]; ?>)"></a></td>
</tr>
<?php
}
?>
</table>
No comments:
Post a Comment