hi all
in the following link when i am displaying pagination select box and next and last buttons before the display button is clicked. please correct my code
http://nac.net.in/list_trainee.php
<?php
$qry3 = "SELECT DISTINCT location FROM `centers` ORDER BY `location`";
$sql3 = mysql_query($qry3);
while ($r3 = mysql_fetch_row($sql3))
{?>
<option value="<? echo $r3[0]; ?>"<?php if($cent==$r3[0]) echo " SELECTED";?>><? echo $r3[0]; ?></option>
<? } ?>
</select></td>
<td width="71"><input name="display" type="submit" class="butt" value="Display" id="display" onMouseOver="mover('dp');" onMouseOut="mout('dp');"> </td>
</tr>
<tr>
<td class="cont">Trade<?php // echo $qry2 = "SELECT DISTINCT trade FROM trainees ORDER BY trade"; ?></td>
<td colspan="3">
<select name="trad">
<option selected>All</option>
<?php
$qry2 = "SELECT DISTINCT trade FROM trainees ORDER BY trade";
$sql2 = mysql_query($qry2);
while ($r2 = mysql_fetch_row($sql2))
{?>
<option value="<? echo $r2[0]; ?>"<?php if($trad==$r2[0]) echo " SELECTED";?>><? echo $r2[0]; ?></option>
<? } ?>
</select>
</td>
<td width="163">
<span class="cont">Placement</span></td>
<td width="137">
<select name="batch">
<option value="" selected>ALL</option>Indiramma Housing programme & DGET Certification
<option value="Under Going Training"<? if($batch=='Under Going Training') echo ' SELECTED';?>>Under Going Training</option> <option value="Skill Upgradation"<? if($batch=='Skill Upgradation') echo ' SELECTED';?>>Skill Upgradation</option> <option value="Self Employment"<? if($batch=='Self Employment') echo ' SELECTED';?>>Self Employment</option> <option value="Company Placement"<? if($batch=='Company Placement') echo ' SELECTED';?>>Company Placement</option> <option value="IHP Certification"<? if($batch=='IHP Certification') echo ' SELECTED';?>>IHP Certification</option> <option value="DGET Certification"<? if($batch=='DGET Certification') echo ' SELECTED';?>>DGET Certification</option> <option value="ADDA LABOUR"<? if($batch=='ADDA LABOUR') echo ' SELECTED';?>>ADDA LABOUR</option> <option value="Others"<? if($batch=='Others') echo ' SELECTED';?>>Others</option> </select></td> <td><?
if((!empty($year))&&($year!='All')) $condition1 = " completion_date LIKE '%$year'";
if((!empty($batch))&&($batch!='All')) $condition2 = " placement = '$batch'";
if((!empty($trad))&&($trad!='All')) $condition3 = " trade = '$trad'";
if((!empty($dist))&&($dist!='All')) $condition4 = " district = '$dist'";
if((!empty($cent))&&($cent!='All')) $condition5 = " center = '$cent'";
$qry = "SELECT * FROM `trainees` WHERE status = 'A'";
if(!empty($condition1)) $qry .= " AND ".$condition1;
if(!empty($condition2)) $qry .= " AND ".$condition2;
if(!empty($condition3)) $qry .= " AND ".$condition3;
if(!empty($condition4)) $qry .= " AND ".$condition4;
if(!empty($condition5)) $qry .= " AND ".$condition5;
if(!empty($condition3)) $qry .= " ORDER BY t_name";
else $qry .= " ORDER BY trade";
session_start();
$_SESSION["tQry"] = $qry;
session_write_close();
$sql8 = mysql_query($qry); ?>
<div id="prnt" onMouseOver="mover('prnt');" onMouseOut="mout('prnt');" align="center" style="margin:5px; line-height:20px" class="butt">
<a href="xls_trainee.php" class="cont">Print</a></div>
</td>
</tr>
</table>
<div align="center" class="cont">
<?php //$start = $_GET["start"];
// if(isset($_POST['display'])){
$numrows = mysql_num_rows($sql8);
// if($_POST['display']) {
//It holds total no. of rows retrieved by query
$recsPerPage = 20;
$pgs = 4;
if($numrows < 1) $numrows = 1;
$noOfPages = ceil($numrows/$recsPerPage);
if(isset($_POST['first'])) $page = 1;
elseif(isset($_POST['prev'])) $page = $_POST["page"]-1;
elseif(isset($_POST['next'])) $page = $_POST["page"]+1;
elseif(isset($_POST['last'])) $page = $noOfPages;
else $page = $_POST["page"];
if($page == null) {
$start = 0;
$page = 1;
}else{
$start = $recsPerPage*($page-1);
}
if($noOfPages > 0){
if($start > $recsPerPage){
$prv = ($start - $recsPerPage);
$ppg = ($page - 1);
}else{
$prv = 0;
$ppg = 1;
}
if($page==1){
//echo "<span>First</span> | ";
//echo "<span>Previous</span> ";
}else{
//if($_POST['display']){
?><input name="first" type="submit" class="butt" value="First" style="width:80px;" id="fb" onMouseOver="mover('fb');" onMouseOut="mout('fb');">
<input name="prev" type="submit" class="butt" value="Previous" style="width:80px;" id="pb" onMouseOver="mover('pb');" onMouseOut="mout('pb');">
<?
//echo "<span><a href='list_trainee.php?start=0&page=1' class='pglnks'>First</a></span> | ";
//echo "<span><a href='list_trainee.php?start=".$prv."&page=".$ppg."' class='pglnks'>Previous</a></span> ";
} echo "<select name='page' onChange='submit();'>";
for($i = 1; $i <= $noOfPages; $i++) {
//if(!(($i < ($page-$pgs))||($i > ($page+$pgs)))){
?>
<option value='<? echo $i ?>'<? if($page==$i) echo ' SELECTED';?>><? echo $i ?></option>
<? /* if($i == $page){
$line = "<span class='fbar'><b>". $i."</a> </b></span> ";
}else{
$j = ($i-1)*$recsPerPage;
$line = "<span><a href='list_trainee.php?start=".$j. "&page=". $i."' class='pglnks'>". $i."</a></span> ";
}
echo $line;*/
//}
}
?></select> <?
if($start < ($numrows-$recsPerPage)){
$nxt = ($start + $recsPerPage);
$pg = ($page + 1);
}else{
$nxt = (($noOfPages-1)*$recsPerPage);
$pg = $page;
}
$lst = (($noOfPages-1)*$recsPerPage);
if($page==$noOfPages){
//echo "<span>Next</span> | ";
//echo "<span>Last</span> ";
}else{
?><input name="next" type="submit" class="butt" value="Next" style="width:80px;" id="nb" onMouseOver="mover('nb');" onMouseOut="mout('nb');">
<input name="last" type="submit" class="butt" value="Last" id="lb" style="width:80px;" onMouseOver="mover('lb');" onMouseOut="mout('lb');">
<? //echo "<span><a href='list_trainee.php?start=".$nxt."&page=".$pg."' class='pglnks' onClick='submit();'>Next</a></span> | ";
//echo "<span><a href='list_trainee.php?start=".$lst."&page=".$noOfPages."' class='pglnks'>Last</a></span> ";
}
}
?>
</div>
</form>
