Der bliver vist de første 3 sider, nederst er et link hvor man når man trykker på næste viser de næste 3 resultater med derefter viser den ikke et link til det sidste resultat. Jeg ved der er 7 resultater i alt, så den burde vise et link til det sidste resultat
<?php session_start();?><html><head></head><BODY><?php /*------------------------------------------------------------------------ control codes ------------------------------------------------------------------------*/ if ( (isset($_POST['submit'])) or (isset($_GET['pg'])) ) { search(); //call the search function }else{ show_form(); //call the show form function }//end if /*------------------------------------------------------------------------ show the search form ------------------------------------------------------------------------*/ function show_form() { //call the dropdown function which creates an html string to build a select box for each element $be = dropdown('be','behan'); $omraede = dropdown('omraede','behan'); $pro = dropdown('pro','behan'); echo "<form name='search' action=".$_SERVER['PHP_SELF']." method='post'> <table width='50%' align='center' > <tr> <td colspan='2' align='center' style='font-family:verdana;font-size:130%;'><strong> </strong><br></br></td> </tr> <tr> <td align='right' style='font-family:verdana;font-size:110%;'>Behandler:</td><td><select name='be'style='font-size: 18px;'>><option value='alle'>Alle</option><option value='Fy'>Fy</option><option value='Ki'>Ki</option></td> </tr> </select> <tr> <td align='right' style='font-family:verdana;font-size:110%;'>Område:</td><td><select name='omraede' style='font-size: 18px;'><option value='alle'>Alle</option><option value='F'>F</option><option value='Sj'>Sj</option><option value='jy'>Jy</option></td> </tr> </select> <tr> <td align='right' style='font-family:verdana;font-size:110%;'>Pro:</td><td><select name='pro' style='font-size: 18px;'><option value='alle'>Alle</option><option value='yg'>yg</option><option value='rm'>rm</option><option value='f'>F</option> </td> </tr> </select> <td colspan='2' align='center'> </tr> <tr> <td colspan='2' align='center' ><input type='submit' name='submit' style='font-size: 15px;' value='Fin'></td> </tr> <tr> </td> <td style='position:absolute;right:18px;top:36px' 'tdimage' BACKGROUND='forside1.jpg' width='290' height='600'></td></tr> </table> </form>"; }//end function /*------------------------------------------------------------------------ run the search and show the results ------------------------------------------------------------------------*/ function search() { if (isset($_POST)) { foreach($_POST as $k=>$v) { $_SESSION[$k]=$v; }}//Pagination mysql_connect("localhost", "***", "****") or die(mysql_error());mysql_select_db("*****") or die(mysql_error());$getcount = mysql_query ("SELECT * FROM behan");$postnum = mysql_result($getcount,0);$limit = 3;if($postnum > $limit){$tagend = round($postnum % $limit,0);$splits = round(($postnum - $tagend)/$limit,0);if($tagend == 0){$num_pages = $splits;}else{$num_pages = $splits + 1;}if(isset($_GET['pg'])){$pg = $_GET['pg'];}else{$pg = 1;}$startpos = ($pg*$limit)-$limit;$limstring = "LIMIT $startpos,$limit";}else{$limstring = "LIMIT 0,$limit";} /////////////////////////////////////$sql = "SELECT * FROM behan WHERE 1=1"; //get the values from the form //NOTE: You should do way more valdation on the values before you attempt to process anything if ((!empty($_SESSION['be']))&&($_SESSION['be'] != 'alle')) { $sql .= " and be like '". mysql_real_escape_string($_SESSION['be'])."%' "; } if ((!empty($_SESSION['omraede']))&&($_SESSION['omraede'] != 'alle')) { $sql .= " and omraede like '". mysql_real_escape_string($_SESSION['omraede'])."%' "; } if ((!empty($_SESSION['pro']))&&($_SESSION['pro'] != 'alle')) { $sql .= " and pro = '". mysql_real_escape_string($_SESSION['pro'])."' "; } // ADD ORDER BY $sql .= " GROUP BY na order by total_value DESC $limstring "; print "<table border=1>"; //run query $result = conn($sql); if (!$result){ die("No results due to database error.<br>".mysql_error()); } if (mysql_num_rows($result)==0 && ($result)!='alle') {echo "<p>No results!</p>"; } else{echo "<TABLE width=100% height=300 border='0' cellpadding='5' cellspacing='10'>";$first_run = "true"; while ($rows= mysql_fetch_array($result)){echo "<TR>"; if ($first_run == "true"){echo "<TH colspan='5' scope='colgroup'><p style='font-family:verdana;font-size:130%;text-align:center;'>Results: <scope='row'>"; if (($_SESSION['be'] == 'alle')&&($_SESSION['omraede'] == 'alle')&&($_SESSION['pro'] == 'alle')) { echo "alle" ; }if ($_SESSION['be'] != 'alle') { echo $rows['be'] ; } echo " ";if ($_SESSION['omraede'] != 'alle') { echo $rows['omraede'] ;} echo " ";if ($_SESSION['pro'] != 'alle') { echo $rows['pro'];}echo "</P></h1></Th>"; $first_run = "false";}if($_SESSION['pro'] != 'alle'){ echo "<TR>";echo "<TH scope='col' abbr='be'><p style='font-family:verdana;font-size:100%;text-align:justify;text-decoration:underline;'>B e</p></TH>";echo "<TH scope='col' abbr='rating'><p style='font-family:verdana;font-size:100%;text-align:justify;text-decoration:underline;'>R ating</p></TH>";echo "<TH scope='col'><p style='font-family:verdana;font-size:100%;text-align:justify;text-decoration:underline;'>K o</p></TH>";echo "</TR>";echo "<TR>";echo "<TD ALIGN=justify width=25% height=100 scope='row'><p style='font-family:verdana;font-size:100%;'>". $rows['be'] ."<br> ". $rows['na'] ."<br> ". $rows['ad'] ."<br> ". $rows['por'] .", ". $rows['y'] ."<br> ". $rows['tl'] ."</p></TD>";echo "<TD ALIGN=justify width=50% height=100 scope='row'>". rating_bar($rows['id'],'6','static')."<p style='font-family:verdana;font-size:100%;'> <a href='bed.php?id={$rows['id']}&na={$rows['na']}&pro={$rows['pro']}&be={$rows['be']}&omraed e={$rows['omraede']}&ad={$rows['ad']}&tl={$rows['tl']}&por={$rows['por']}'>Bed </a></p></TD>";echo "<TD ALIGN=justify width=25% height=100 scope='row'><p style='font-family:verdana;font-size:100%;'><a href='kom.php?na={$rows['na']}&id={$rows['id']}&be={$rows['be']}'>Larer</a></p> </TD>";echo "<TABLE width=100% height=100 border='0' cellpadding='5' cellspacing='10'><hr>";echo "</TR>"; } else {echo "<TR>";echo "<TH scope='col' abbr='be'><p style='font-family:verdana;font-size:100%;text-decoration:underline;text-align:justify;'>B e</p></TH>";echo "<TH scope='col' abbr='rating'><p style='font-family:verdana;font-size:100%;text-decoration:underline;text-align:center;'>Ra ting</p></TH>";echo "<TH scope='col'><p style='font-family:verdana;font-size:100%;text-decoration:underline;text-align:justify;'>K o</p></TH>";echo "</TR>";echo "<TR>";echo "<TD ALIGN=justify width=20% height=100 scope='row'><p style='font-family:verdana;font-size:100%;'>". $rows['be'] ."<br> ". $rows['na'] ."<br> ". $rows['ad'] ."<br> ". $rows['por'] .", ". $rows['y'] ."<br> ". $rows['tl'] ."</p></TD>";echo "<TD ALIGN=center width=50% height=100 scope='row'><p style='font-family:verdana;font-size:100%;'><a href='bed.php?id={$rows['id']}&na={$rows['na']}&pro={$rows['pro']}&be={$rows['be']}&omraed e={$rows['omraede']}&ad={$rows['ad']}&tl={$rows['tl']}&por={$rows['por']}'>Bed </a></p> </TD>";echo "<TD ALIGN=justify width=40% height=100 scope='row'><p style='font-family:verdana;font-size:100%;'><a href='kom.php?na={$rows['na']}&id={$rows['id']}&be={$rows['be']}'>Larer</a></p> </TD>";echo "<TABLE width=100% height=100 border='0' cellpadding='5' cellspacing='10'><hr>";echo "</TR>"; } } }echo "</table>"; //////////////////////// Links for paginationif($postnum > $limit){echo "<strong>Pages:</strong> ";$n = $pg + 1;$p = $pg - 1;$thisroot = $_SERVER['PHP_SELF'];;if($pg > 1){echo "<a href=\"$thisroot?pg=$p\"><< prev</a> ";}for($i=1; $i<=$num_pages; $i++){if($i!= $pg){echo "<a href=\"$thisroot?pg=$i\">$i</a> ";}else{echo "$i ";}}if($pg < $num_pages){echo "<a href=\"$thisroot?pg=$n\">next >></a>";}echo " ";} /////////////////}//end function /*------------------------------------------------------------------------ create the drop downs ------------------------------------------------------------------------*/ function dropdown($field, $table) { //initialize variables $oHTML = ''; $result = ''; //check to see if the field is passed correctly if (($field == "")||($table == "")) { die("No column or table specified to create drop down from!"); } $sql = "select distinct($field) from $table"; //call the db function and run the query $result = conn($sql); //if no results are found to create a drop down return a textbox if ((!$result) ||(mysql_num_rows($result)==0)) { $oHTML .= "<input type='text' name='$field' value='' size='15'>"; } elseif (($result)&&(mysql_num_rows($result)>0)){ //build the select box out of the results $oHTML .= "<select name='$field'>\n<option onClick='alert(\"warning\")' value='alle' disabled>Alle</option>\n"; while ($rows = mysql_fetch_array($result)) { $oHTML .= "<option value='".$rows[$field]."'>".$rows[$field]."</option>\n"; } $oHTML .= "</select>\n"; } //send the value back to the calling code return $oHTML; }//end function ?></body>
|