PHP RSS PHP RSS

paging

Reply

•
•
Join Date: Nov 2007
Posts: 183
Reputation: lydia21 is an unknown quantity at this point 
Solved Threads: 5
lydia21 lydia21 is offline Offline
Junior Poster

paging

 
0
  #1
Jul 25th, 2008
hi,
page navigation is not working.please tell how to pass date
PHP Syntax (Toggle Plain Text) 
  1. <?
  2. include_once('session_control_emp_sp.php');
  3. ?>
  4. <html>
  5. <head></head>
  6. <body>
  7. <?
  8.  //db connection
  9.  
  10. $page_name="mg_resumep.php";
  11. //$limit=sql_quote($_GET['limit']); // Read the limit value from query string.
  12. $limit=$_GET['limit'];
  13. //$start=sql_quote($_GET['start']); // To take care global variable if OFF
  14. $start=$_GET['start'];
  15.  $id=$_GET['id'];
  16.  
  17.   // echo "\n";
  18. $agent=mysql_query("select * from magic_agent where id='$id'") or die("ERROR:".mysql_error());
  19. while ($magic=mysql_fetch_array($agent))
  20.     {
  21.     $industry=$magic[2];
  22.      $industry1=$industry;
  23.  
  24. // $industry1=$industry&$careerlevel1=$careerlevel&$day1=$day
  25.     $careerlevel=$magic[3];
  26.     $careerlevel1=$careerlevel;
  27.  
  28.     // echo $careerlevel;
  29.     // echo "\n";
  30.     $chkstate=$magic[4];
  31.  
  32.     $day=$magic[6];
  33. $day1=$day;
  34. //echo $day1;
  35. echo $industry1;
  36. echo $careerlevel1;
  37. echo $chkstate;
  38.      // echo "\n";
  39.     }
  40. $empi=$_SESSION['employerid'];
  41. $ours=mysql_query("SELECT group1 from cggroup where userid='$empi'")or die("ERROR:".mysql_error());
  42. while ($our=mysql_fetch_row($ours))
  43.  
  44.     {
  45. echo "ours";
  46. $gnam=$our[0];
  47. $gname1=$gnam;
  48. echo $gnam;
  49. }
  50.  
  51. if(!($start > 0))
  52. { // This variable is set to zero for the first page
  53. $start = 0;
  54. }
  55.  
  56. $eu = ($start - 0); 
  57. if(!$limit > 0 )
  58. { // if limit value is not available then let us use a default value
  59. $limit = 1; // No of records to be shown per page by default.
  60. } 
  61. $this1 = $eu + $limit; 
  62. $back = $eu - $limit; 
  63. $next = $eu + $limit; 
  64.  
  65.  
  66. //*****************************************************************/
  67.  
  68.  
  69. if($chkstate==0)
  70. {
  71. if($careerlevel==-1)
  72. {
  73.  
  74. $result =  mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  75.  
  76.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  77.  
  78. FROM post_resume
  79.  
  80. INNER JOIN login ON post_resume.owner = login.id
  81.  
  82. WHERE ind_type = '$industry1'
  83.  
  84. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate<='$day1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  85. }
  86. else
  87. {
  88. $result =  mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  89.  
  90.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  91.  
  92. FROM post_resume
  93.  
  94. INNER JOIN login ON post_resume.owner = login.id
  95.  
  96. WHERE ind_type = '$industry1'  && career='$careerlevel1'
  97.  
  98. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate<='$day1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  99. }
  100. }
  101. else if($chkstate==1)
  102. {
  103.   if($careerlevel==-1)
  104. {
  105.  
  106. $result =mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  107.  
  108.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  109.  
  110. FROM post_resume
  111.  
  112. INNER JOIN login ON post_resume.owner = login.id
  113.  
  114. WHERE ind_type = '$industry1'
  115.  
  116. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate>'$day1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  117. }
  118. else
  119. {
  120. $result = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  121.  
  122.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  123.  
  124. FROM post_resume
  125.  
  126. INNER JOIN login ON post_resume.owner = login.id
  127.  
  128. WHERE ind_type = '$industry1' && career='$careerlevel1'
  129.  
  130. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate>'$day1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  131. }
  132. }
  133. else if($chkstate==2)
  134. {
  135.  if($careerlevel==-1)
  136. {
  137.  
  138. $result = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  139.  
  140.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  141.  
  142. FROM post_resume
  143.  
  144. INNER JOIN login ON post_resume.owner = login.id
  145.  
  146. WHERE ind_type = '$industry1'
  147.  
  148. && groupn = '$gnam' && owner<>'$empi' && type='1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  149. }
  150. else
  151. {
  152. $result = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  153.  
  154.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  155.  
  156. FROM post_resume
  157.  
  158. INNER JOIN login ON post_resume.owner = login.id
  159.  
  160. WHERE ind_type = '$industry1' && career='$careerlevel1'
  161.  
  162. && groupn = '$gnam' && owner<>'$empi' && type='1' order by tdate limit $eu, $limit") or die("ERROR:".mysql_error());
  163. }
  164. }
  165. else
  166. {
  167. }
  168.  
  169. //code for paging
  170.  
  171. if($chkstate==0)
  172. {
  173. if($careerlevel==-1)
  174. {
  175.  
  176. $selcount =  mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  177.  
  178.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  179.  
  180. FROM post_resume
  181.  
  182. INNER JOIN login ON post_resume.owner = login.id
  183.  
  184. WHERE ind_type = '$industry1'
  185.  
  186. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate<='$day1' order by tdate") or die("ERROR:".mysql_error());
  187. echo "*";
  188. }
  189. else
  190. {
  191. $selcount =  mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  192.  
  193.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  194.  
  195. FROM post_resume
  196.  
  197. INNER JOIN login ON post_resume.owner = login.id
  198.  
  199. WHERE ind_type = '$industry1'  && career='$careerlevel1'
  200.  
  201. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate<='$day1' order by tdate") or die("ERROR:".mysql_error());
  202. echo "**";
  203. $nume=mysql_num_rows($selcount);
  204. echo $nume;
  205. }
  206. }
  207. else if($chkstate==1)
  208. {
  209.   if($careerlevel==-1)
  210. {
  211.  
  212. $selcount =mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  213.  
  214.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  215.  
  216. FROM post_resume
  217.  
  218. INNER JOIN login ON post_resume.owner = login.id
  219.  
  220. WHERE ind_type = '$industry1'
  221.  
  222. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate>'$day1' order by tdate") or die("ERROR:".mysql_error());
  223. echo "***";
  224. $nume=mysql_num_rows($selcount);
  225. echo $nume;
  226. }
  227. else
  228. {
  229. $selcount = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  230.  
  231.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  232.  
  233. FROM post_resume
  234.  
  235. INNER JOIN login ON post_resume.owner = login.id
  236.  
  237. WHERE ind_type = '$industry1' && career='$careerlevel1'
  238.  
  239. && groupn = '$gnam' && owner<>'$empi' && type='1' && tdate>'$day1' order by tdate") or die("ERROR:".mysql_error());
  240. echo "****";
  241. $nume=mysql_num_rows($selcount);
  242. echo $nume;
  243. }
  244. }
  245. else if($chkstate==2)
  246. {
  247.  if($careerlevel==-1)
  248. {
  249.  
  250. $selcount = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  251.  
  252.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  253.  
  254. FROM post_resume
  255.  
  256. INNER JOIN login ON post_resume.owner = login.id
  257.  
  258. WHERE ind_type = '$industry1'
  259.  
  260. && groupn = '$gnam' && owner<>'$empi' && type='1' order by tdate") or die("ERROR:".mysql_error());
  261. echo "*****";
  262. $nume=mysql_num_rows($selcount);
  263. echo $nume;
  264. }
  265. else
  266. {
  267. $selcount = mysql_query("SELECT post_resume.pid,post_resume.res_title, post_resume.candidate_type,
  268.  
  269.  post_resume.ind_type, post_resume.career, post_resume.resume, post_resume.resume_upload, post_resume.groupn, login.id, login.username
  270.  
  271. FROM post_resume
  272.  
  273. INNER JOIN login ON post_resume.owner = login.id
  274.  
  275. WHERE ind_type = '$industry1' && career='$careerlevel1'
  276.  
  277. && groupn = '$gnam' && owner<>'$empi' && type='1' order by tdate") or die("ERROR:".mysql_error());
  278. echo "******";
  279. $nume=mysql_num_rows($selcount);
  280. echo $nume;
  281. }
  282. }
  283. else
  284. {
  285. }
  286.  
  287.  
  288. //$nume=mysql_num_rows($selcount);
  289. //echo $nume;
  290. echo "<table>";
  291. //**************************************************************************
  292. while($row = mysql_fetch_array($result)) 
  293. {?> 
  294. <tr><td>
  295. <?echo $row[0]; ?>
  296. <td><?echo $row[1]?></td>
  297. </tr>
  298. <?
  299. }
  300. echo "</table>";
  301. if($nume > $limit)
  302. {
  303. //Counting no of pages and the current page.
  304. $totnumofpages = round($nume/$limit);
  305. $i=0;
  306. $l=1;
  307. for($i=0;$i < $nume;$i=$i+$limit)
  308. {
  309. if($i == $eu)
  310. {
  311. $currentpage= $l;
  312. }
  313. $l=$l+1;
  314. } 
  315.  
  316. echo "<div height=28 align=right><table cellpadding=3 cellspacing=1 border=0 height=28><tr><td>Page ".$currentpage." / ".$totnumofpages."</td>";
  317. //// if our variable $back is equal to 0 or more then only we will display the link to move back //////// 
  318. if($back >=0) 
  319. { 
  320. print "<td align='left'><a href='$page_name?start=$back&limit=$limit'>&lt;</a></td>"; 
  321. } 
  322. //////////////// We will not display the current page as a link ///////////
  323. $i=0;
  324. $l=1;
  325. for($i=0;$i < $nume;$i=$i+$limit)
  326. {
  327. if($i <> $eu)
  328. {
  329. echo "<td align=center><a href='$page_name?start=$i&limit=$limit&industry1=$industry&careerlevel1=$careerlevel&day1=$day&gname1=$gnam'><span>$l</span></a></td>";
  330. }
  331. else 
  332. { 
  333. echo "<td align=center><span><b>$l</b></span></td>";
  334. } /// Current page is not displayed as link 
  335. $l=$l+1;
  336. }
  337. ///////////// If we are not in the last page then Next link will be displayed. Here we check that /////
  338. if($this1 < $nume) 
  339. { 
  340. print "<td align=center width=15><a href='$page_name?start=$next&limit=$limit&industry1=$industry&careerlevel1=$careerlevel&day1=$day&gname1=$gnam'><span ><b>&gt;</b></span></a></td>";
  341. } 
  342. echo "</tr></table></div>";
  343. }
  344. mysql_close();
  345. ?>
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 183
Reputation: lydia21 is an unknown quantity at this point 
Solved Threads: 5
lydia21 lydia21 is offline Offline
Junior Poster

Re: paging

 
0
  #2
Jul 25th, 2008
hi i just want to how to pass data for navigation
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



ajax apache api array basics beginner binary bounce broken cakephp checkbox class cms code codingproblem combobox cron curl database date display dynamic echo email error file files folder form forms function functions google href htaccess html image include insert integration interactive ip java javascript joomla js limit link login mail menu mlm mobile multiple mysql nodes oop outofmemmory paging parse paypal pdf php problem procedure query radio ram random recursion regex remote return script search server sessions smash sms soap source space sql syntax system table tutorial up-to-date update upload url validation validator variable video web webapplications websitecontactform xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC