darkfreaks Posted February 17, 2008 Share Posted February 17, 2008 could someone clean up my code so it works with my pagnation ??? <?php define('IN_PHPBB', true); $phpbb_root_path = '../architect-jobs-forum/'; include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$phpEx); // // Start session management // $userdata = session_pagestart($user_ip, PAGE_INDEX); init_userprefs($userdata); // // End session management // require "../db_conn.inc.php"; $page_title = 'Architect Job Postings'; include ('../includes/header.php'); ?> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td align="left" valign="top"><h1><img src="/images/sq_3.gif" width="17" height="17" hspace="5" vspace="5" align="left">Job Postings</h1></td> <td align="right" valign="bottom"><a href="http://www.arkitectum.com/architect-jobs/jobs.php?action=job"><img src="/images/but_post_job.gif" alt="Post an architect job" width="108" height="24" hspace="4" vspace="4" border="0"></a></td> </tr> </table> <table width="100%" border="0" cellspacing="1" cellpadding="2"> <tr> <td align="left"><p><b>Job Seekers:</b> Subscribe to our mailing list and receive daily emails with the latest job postings. </p> <form action="http://www.arkitectum.com/architect-jobs-forum/profile.php?mode=register" method="post"> <p><input type="text" id="email" name="email" value="email address" onfocus="this.value=''" /><input name="Submit" type="submit" value="Subscribe"></p></form></td> <td align="right" valign="bottom"> </td> </tr> </table> <table width="98%" border="0" align="center" cellpadding="4" cellspacing="1" class="forumline"> <tr> <th class="thTop" align="center">Job Title</th> <th align="center">Location</th> <th align="center">Posted</th> </tr> <?php if (isset($_GET['page'])) { $page = $_GET['page']; }else{ $page = 1; } $max_results = 25; $from = (($page * $max_results) - $max_results); if (isset($_POST['Search'])) { $total_results = "SELECT * FROM jobs WHERE NOW() < expires AND paid = '1' "; $total_pages = ceil($total_results / $max_results); $keyword = trim($_POST['keyword']); if($_POST['keyword']!=''){ $find = mysql_real_escape_string(htmlentities($_POST['keyword'])); $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); if(($_POST['category']!='')&&($_POST['location']!='')){ $total_results .= "AND category = '".mysql_real_escape_string($_POST['category'])."' OR location = '".mysql_real_escape_string($_POST['location'])."' OR title LIKE '%$find%' ORDER BY job_id DESC"; $search = TRUE; } elseif(($_POST['category']!='')&&($_POST['location']=='')){ $total_results .= "AND category = '".mysql_real_escape_string($_POST['category'])."' OR title LIKE '%$find%' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; } elseif(($_POST['category']=='')&&($_POST['location']!='')){ $total_results .= " AND location = '".mysql_real_escape_string($_POST['location'])."' OR title LIKE '%$find%' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; } else { $total_results .= "AND title LIKE '%$find%' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; } } else{ if($_POST['location']!=''){// Check if the location isnt empty if($_POST['category']==''){ // Check if category is empty $total_results .= "AND location = '".mysql_real_escape_string($_POST['location'])."' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; }// End if category is empty }// End if location isnt empty if($_POST['category']!=''){// Check if the category isnt empty if($_POST['location']==''){ // Check if location is empty $total_results .= "AND category = '".mysql_real_escape_string($_POST['category'])."' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; }// End if location is empty }// End if category isnt empty if($_POST['category']!=''){// Check if the category isnt empty if($_POST['location']!=''){ // Check if location is empty $total_results .= "AND category = '".mysql_real_escape_string($_POST['category'])."' AND location = '".mysql_real_escape_string($_POST['location'])."' ORDER BY job_id DESC LIMIT $from,$max_results"; $search = TRUE; }// End Else }// End if location isnt empty }// End if category isnt empty if($search){ $aa = mysql_query($total_results) or die(mysql_error()); $num = mysql_num_rows($aa); while($row = mysql_fetch_array($aa)){ echo " <tr> <td align='left' valign='top' bgcolor='#F2F5F9'><b><a href='view-job.php?job_id={$row['job_id']}'>". stripslashes($row['title']) ."</a></b> <br>". stripslashes($row['employer']) ."</td> <td align='left' valign='top' bgcolor='#F2F5F9'>{$row['city']}, {$row['location']}</td> <td align='center' valign='top' bgcolor='#F2F5F9' width='70' class='small_10'>". date('M d, y', strtotime($row['date'])) ."</td> </tr>"; }// End While } echo "</table>"; echo"<p align='right'>"; if($page <= 1){ echo " <a href='#'><<</a> "; } else{ $prev = ($page - 1); echo " <a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<</a> "; } for($i = 1; $i <= 10; $i++){ if(($page) == $i){ echo "[$i] "; }else{ echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } if($page < $total_pages){ $next = ($page + 1); echo " <a href=\"".$_SERVER['PHP_SELF']."?page=$next\"> >></a> "; } echo'</p>'; }// End if form was submitted include_once ('../includes/footer.htm'); ?> Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted February 17, 2008 Share Posted February 17, 2008 No, we're not here to do the work for you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.