abhi10kumar 0 Junior Poster

I have a page where lots of pagination links are there.. now it is not possible manage via links.. So, I need combobox where page number will be in that combobox and a Button named Go. After clicking a button, result will show for that particular number as well perserve page no.

Here is my code

$criteria=" resume_status=1 and status=1 ";

if(isset($industry_type))
	$criteria .= (($criteria!="")?" and ":"") . " job_category=$industry_type ";
else
	$industry_type="";

if(isset($q))
{
	$q=str_replace(" ",",",$q);
	$q=preg_replace("(,+)",",",$q);
	
	$qexpand="";
	$qarray=split("[,]",$q);
	foreach($qarray as $qvalue)
	{
		$qexpand .= (($qexpand!="")?" or ":"")." resume_heading LIKE '%$qvalue%' or key_skills LIKE '%$qvalue%' ";
	}
	if($qexpand!="")
		$criteria .= (($criteria!="")?" and ":"") . " ($qexpand) ";
}
else
{
	$q="";
}

$criteria = (($criteria!="")?" where ":"") . " $criteria ";
		
$resumes=mysql_query("select * from $tbl_name $criteria");


if(!isset($display))
$display='full';

if($_GET && array_key_exists("page",$_GET) && is_numeric($_GET["page"]))
	$page=secure_form_data($_GET["page"]);

if($display=='full')
	$perpage=15;

$startrecord=($page-1)*$perpage;

if($resumes && (mysql_num_rows($resumes)>0))
{
@mysql_data_seek($resumes,$startrecord);
?>
<form action="contact_jobseekers.php" method='post' onsubmit="return checkform(this);">
<table width="470px" style="font-size:10pt;" cellspacing="1" cellpadding="3">
<?php
	$rcount=0;
	while($rcount<$perpage && ($resume=mysql_fetch_array($resumes)))
	{
		echo "<tr  >".
			"<td width='3%' valign='top' style='border-bottom: 1px solid #ccc;'><br>
			<input type='checkbox' id='resume_$resume[id]' name='resume[]' value='$resume[id]' /></td>".
			"<td style='border-bottom: 1px solid #ccc; font-family:'Trebuchet MS' '><br><a href='resume_detail.php?jsid=$resume[id]' target='_blank' style='text-decoration:none; color:#666; font-family:verdana;'>
			<span style='font-weight:bold;font-size:10pt; font-family:Trebuchet MS; color:#253D65; '>
			$resume[resume_heading] ".(($resume['experience_yr'] && $resume['experience_mn'])?"Experience: $resume[experience_yr] year(s) $resume[experience_mn] month(s)":"Fresher")."</span> <br />
			<span style='font-family:Trebuchet MS;'>
			$resume[name]<br>
			$resume[location]<br>".
			nl2br($resume["key_skills"]).
			"</span></a></td>";
			
			$rcount++;
	}

	echo "<tr><td colspan='2' style='text-align:right; font-family:verdana; padding-top:3px;' class='f blue-red'>";
	

	$pcounter=1;
	while($pcounter <=  ceil(@mysql_num_rows($resumes)/$perpage))
	{
		echo " <a href='$_SERVER[PHP_SELF]?q=$q&ind=$industry_type&page=$pcounter'>".(($pcounter==$page)?"[$pcounter]":"$pcounter")."</a> ";
		$pcounter++;
	}  [B]// HERE PAGINATION LINKS ARE DISPLAYING.. I need Combobox here.. [/B]
	



echo "</td></tr>";
?>
<tr><td>&nbsp;</td><td><input type="submit" name="contact_bt" id="contact_bt" value="Contact Jobseekers"></td></tr>
</table>

</form>
<?php		
}
else
{
	echo "<div style='color:red; padding-top:10px; font-family:Trebuchet MS; font-size:13px;'>No resume found.</div>";
}	
?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.