Jump to content

Undefined index?


jarv

Recommended Posts

Hi, I would like to pass the value of a form name through "rsTown" but I am getting undefined index

 

my form:

<form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>">
                    City/Town: <input type="text" size="26" class="searchbox" value="" name="rsTown" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" />
                
                <div class="suggestionsBox" id="suggestions" style="display: none;">
                    <img src="images/upArrow.png" style="position: relative; top: -36px; left: 105px; z-index:1;" alt="upArrow" />
                    <div class="suggestionList" id="autoSuggestionsList">
                     </div>
                </div>
                <input type="image" src="images/go.png" height="30" with="30" value="GO" />
            </form>

 

my code on same page:

<?
			$Townsearch = $_REQUEST['rsTown'];
// how many rows to show per page
$rowsPerPage = 20;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;
$query  = "SELECT * FROM pubs WHERE rsTown LIKE '$Townsearch%' LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . $query);  

//looping counties
$query1  = "SELECT rsCounty, COUNT(PubID) AS County_Count FROM pubs GROUP BY rsCounty";
$result1 = mysql_query($query1) or die(mysql_error().'<br>SQL: ' . $query1);  

$county_select_options = '<option value="">Search county</option>';
while ($row = mysql_fetch_assoc($result1))
{
    $counties[$row['rsCounty']] = $row['County_Count'];
    // $county_select_options .= '<option value="display.php?PubID='.$row['id'].'">'.$row['rsCounty'].' (x'.$row['County_Count'].')</option>'."\n";
}
        // make this arrays not strings:
    $values = array();
    $labels = array();
        // compute the sum:
        $total = array_sum($counties);
    foreach($counties as $rsCounty=>$count){
                // compute percent and add to values list:
        $values[] = ($count*100/$total);
        $labels[] = $rsCounty;
    }
        // convert array $values to a string comma separated
    $values = implode(',',$values);
        // same conversion for $labels but '|' separated
    $labels = implode('|', $labels);
    $url = 'http://chart.apis.google.com/chart?cht=p3&chd=t:'.$values.'&chs=480x200&chl='.$labels.'&chco=b0d584';
    ?>
    <img src="<?php echo $url ?>" />
<?


// start main page
while($row = mysql_fetch_array($result)){
echo '<div id="pubholder" class="wrap">';
$PUBID = $row['PubID'];
$RSPUBNAME = $row['rsPubName'];
$RSADDRESS = $row['rsAddress']; 
$RSPOSTCODE = $row['rsPostCode'];
$RSTEL = $row['rsTel'];
$RSTOWN = $row['rsTown'];
$RSCOUNTY = $row['rsCounty'];

//div container of header and information

echo <<<EOF
  <a title="$PUBID" id="$PUBID" name="$PUBID"></a>
  <div class="entry_header">
    <div class="pubname">$RSPUBNAME</div> 
EOF;
if	($_SESSION["RSUSER"] == "admin") 
{
echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</a>";
}
echo  "</br>";
echo  "</br>";
echo	"<div class=\"county\">".$RSCOUNTY."</div><div class=\"town\">".$RSTOWN."</div>";

echo "</div>";
echo "</div>";
}

// how many rows we have in database
$query   = "SELECT COUNT(*) AS numrows FROM pubs";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);



// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   }
}

// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";

$first = " <a href=\"$self?page=1\">[First Page]</a> ";
} 
else
{
$prev  = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">[Next]</a> ";

$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
} 
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}


// print the page navigation link
echo "<div class=\"centertext\">";
echo $first . $prev .  $nav ." Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last;
echo "</div>";

?>

 

Also, I need my pagination sorting out if anyone can help?!

 

take a look at my site: http://www.retroandvintage.co.uk/default.php

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.