Jump to content

how can I keep county in search?!


jarv

Recommended Posts

here is my site: http://www.retroandvintage.co.uk/

 

start typing a name of town in the UK, select it and click GO

 

When you click from Page to page it loses the County in the H2

 

Please help?!

 

here is code for search page

<?php

include_once("config.php");

/*
Login script:
This script does the following:

Checks that the user is NOT already logged in - if they are they
are redirected to the members page by the 'checkLoggedIn()' function.

Checks if the login form has been submitted - if so, the 'login' and
'password' fields are checked to ensure they are of the correct format and length.
If there are any problems here an error is added to the $messages array and
then the script executes the 'doIndex()' function - this function basically
outputs the main 'index' page for this script - ie the login form.

If there are no problems with the previous step, the 'login' and 'password'
field data is passed to the 'checkPass' function to check that an entry
exists in the 'users' table for that login/password pair.
If nothing is returned from the 'checkPass()' function, an error is
added to the $messages array and the 'doIndex()' function is called as above.

If a row of data is returned from the 'users' table, the data is passed to
the 'cleanMemberSession()' function - which initializes session variables and
logs the user in.  The user is then forwarded to the members page.

If the form hasn't yet been submitted, then the 'doIndex()' function is called
and the login page is displayed.
*/
// Check user not logged in already:
checkLoggedIn("no");

// Page title:
$title="Member Login Page";

// if $submit variable set, login info submitted:
if(isset($_POST["submit"])) {
//
// Check fields were filled in
//
// login must be between 4 and 15 chars containing alphanumeric chars only:
field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15);
// password must be between 4 and 15 chars - any characters can be used:
field_validator("rsPass", $_POST["rsPass"], "string", 4, 15);

// if there are $messages, errors were found in validating form data
// show the index page (where the messages will be displayed):
if($messages){
	doIndex();
	// note we have to explicity 'exit' from the script, otherwise
	// the lines below will be processed:
	exit;
}

// OK if we got this far the form field data was of the right format;
// now check the user/pass pair match those stored in the db:
/*
If checkPass() is successful (ie the login and password are ok),
then $row contains an array of data containing the login name and
password of the user.
If checkPass() is unsuccessful however, $row will simply contain
the value 'false' - and so in that case an error message is
stored in the $messages array which will be displayed to the user.
*/
    if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) {
	// login/passwd string not correct, create an error message:
        $messages[]="Incorrect login/password, try again";
    }

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
	doIndex();
	exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["rsUser"], $row["rsPass"]);

// and finally forward user to members page (populating the session id in the URL):
header("Location: main.php");
} else {
// The login form wasn't filled out yet, display the login form for the user to fill in:
doIndex();
}

/*
This function displays the default 'index' page for this script.  This consists of just a simple
login form for the user to submit their username and password.
*/
function doIndex() {
/*
Import the global $messages array.
If any errors were detected above, they will be stored in the $messages array:
*/
global $messages;

/*
also import the $title for the page - note you can normally just declare all globals on one line
- ie:
global $messages, $title;
*/
global $title;

// drop out of PHP mode to display the plain HTML:
$Townsearch = $_REQUEST['rsTown'];


// Delimiters may be slash, dot, or hyphen

list($Town, $County) = split('[,]', $Townsearch);
?>
<!doctype html>
<html>
<head>
<title>Pubs and bars in <? echo $Townsearch;?></title>
<meta name="description" content="Pubs, bars and restuarants in <? echo $Townsearch;?>" />
<meta name="keywords" content="<? echo $Townsearch;?>, pubs, bars, food, drink, nightlife" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
	if(inputString.length == 0) {
		// Hide the suggestion box.
		$('#suggestions').hide();
	} else {
		$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
			if(data.length >0) {
				$('#suggestions').show();
				$('#autoSuggestionsList').html(data);
			}
		});
	}
} // lookup

function fill(thisValue) {
	$('#inputString').val(thisValue);
	setTimeout("$('#suggestions').hide();", 200);
}
</script>
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
	<h1>My Pub Space
	 <a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
	 <span>
		 <form method="post" class="textbox" action="search.php?rsTown=<? echo $Town ?>&rsCounty=<? echo $County ?>">
				Town/City: <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>
	</span>		</h1>
</div>
</header>
<nav>
<ul>
	<li class="selected"><a href="#">Home</a></li>
	<li><a href="#">Pubs</a></li>
	<li><a href="#">Members</a></li>
	<li><a href="#">Events</a></li>
	<li><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
	<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
	<section>
		<article class="blogPost">
			<header>
				<h2>Pubs in <? echo $Town;?>, <? echo $County;?></h2>
				<p>Posted on
					<time datetime="2009-06-29T23:31+01:00">June 29th 2009</time>
					by <a href="#">Mads Kjaer</a> - <a href="#comments">3 comments</a></p>
			</header>
			<?php

$tableName="pubs";		
$targetpage = "search.php"; 	
$limit = 20; 

$query = "SELECT COUNT(*) as num FROM $tableName WHERE rsTown LIKE '$Town%'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
$page = $_GET['page'];
if($page){
	$start = ($page - 1) * $limit; 
}else{
	$start = 0;	
	}	

    // Get page data
$query1 = "SELECT * FROM $tableName WHERE rsTown LIKE '$Town%' LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	




	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev&rsTown=$Town'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1&rsTown=$Town'>1</a>";
			$paginate.= "<a href='$targetpage?page=2&rsTown=$Town'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next&rsTown=$Town'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}

	$paginate.= "</div>";		


}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>

<ul>

<?php 


	while($row = mysql_fetch_array($result))
	{

	echo '<li>'.$row['rsPubName'].', '.$row['rsTown'].', '.$row['rsCounty'].'</li>';

	}

?>
</ul>
		</article>
	</section>
	<section id="comments">
		<h3>Comments</h3>
		<article>
			<header> <a href="#">George Washington</a> on
				<time datetime="2009-06-29T23:35:20+01:00">June 29th 2009 at 23:35</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Benjamin Franklin</a> on
				<time datetime="2009-06-29T23:40:09+01:00">June 29th 2009 at 23:40</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Barack Obama</a> on
				<time datetime="2009-06-29T23:59:00+01:00">June 29th 2009 at 23:59</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
	</section>
	<form action="" method="POST" method="post">
		<h3>Post a comment</h3>
		<p>
			<label for="name">Name</label>
			<input name="name" id="name" type="text" required />
		</p>
		<p>
			<label for="email">E-mail</label>
			<input name="email" id="email" type="email" required />
		</p>
		<p>
			<label for="website">Website</label>
			<input name="website" id="website" type="url" />
		</p>
		<p>
			<label for="comment">Comment</label>
			<textarea name="comment" id="comment" required></textarea>
		</p>
		<p>
			<input type="submit" value="Post comment" />
		</p>
	</form>
</div>
<aside>
	<section>
		<header>
			<h3>Members Login Area</h3>
		</header>
		<form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>">
			Username: <br />
			<input type="text" class="textbox" name="rsUser" value="<?php print isset($_POST["rsUser"]) ? $_POST["rsUser"] : "" ; ?>">
			Password: <br />
			<input type="password" class="textbox" name="rsPass">
			<br />
			<br />
			<input name="submit" type="submit" value="Login">
			<br />
		</form>
		<ul>
			<li><a href="#">Sign up</a></li>
			<li><a href="#">Forgot Password</a></li>
		</ul>
	</section>
	<section>
		<header>
			<h3>Archives</h3>
		</header>
		<ul>
			<li><a href="#">December 2008</a></li>
			<li><a href="#">January 2009</a></li>
			<li><a href="#">February 2009</a></li>
			<li><a href="#">March 2009</a></li>
			<li><a href="#">April 2009</a></li>
			<li><a href="#">May 2009</a></li>
			<li><a href="#">June 2009</a></li>
		</ul>
	</section>
</aside>
</div>
<footer>
<div>
	<section id="about">
		<header>
			<h3>About</h3>
		</header>
		<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
	</section>
	<section id="blogroll">
		<header>
			<h3>Blogroll</h3>
		</header>
		<ul>
			<li><a href="#">NETTUTS+</a></li>
			<li><a href="#">FreelanceSwitch</a></li>
			<li><a href="#">In The Woods</a></li>
			<li><a href="#">Netsetter</a></li>
			<li><a href="#">PSDTUTS+</a></li>
		</ul>
	</section>
	<section id="popular">
		<header>
			<h3>Popular</h3>
		</header>
		<ul>
			<li><a href="#">This is the title of a blog post</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
			<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
			<li><a href="#">Duis aute irure dolor</a></li>
			<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
			<li><a href="#">Reprehenderit in voluptate velit</a></li>
			<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
		</ul>
	</section>
</div>
</footer>
</body>
</html>
<?php
}
?>

Link to comment
Share on other sites

Put the county inside a session

 

start all your pages with session_start();

Then innitialize the session when the visitor uses the search

 

Ex:

$_SESSION[county] = $_POST[county];

 

Then evry time you need the county var you use the $_SESSION[county]

As long as you start your PHP page with session_start(); the var will be available

Link to comment
Share on other sites

thanks, now I get teh error: Notice: Use of undefined constant county - assumed 'county' in D:\retroandvintage.co.uk\wwwroot\search.php on line 200

 

 

I am echoing it out here:

 

 

line 200:

<h2>Pubs in <? echo $Town;?>, <? echo  $_SESSION[county];?></h2>

Link to comment
Share on other sites

thanks, still not working, here is my code:

<?php
session_start();
include_once("config.php");
/*
Login script:
This script does the following:

Checks that the user is NOT already logged in - if they are they
are redirected to the members page by the 'checkLoggedIn()' function.

Checks if the login form has been submitted - if so, the 'login' and
'password' fields are checked to ensure they are of the correct format and length.
If there are any problems here an error is added to the $messages array and
then the script executes the 'doIndex()' function - this function basically
outputs the main 'index' page for this script - ie the login form.

If there are no problems with the previous step, the 'login' and 'password'
field data is passed to the 'checkPass' function to check that an entry
exists in the 'users' table for that login/password pair.
If nothing is returned from the 'checkPass()' function, an error is
added to the $messages array and the 'doIndex()' function is called as above.

If a row of data is returned from the 'users' table, the data is passed to
the 'cleanMemberSession()' function - which initializes session variables and
logs the user in.  The user is then forwarded to the members page.

If the form hasn't yet been submitted, then the 'doIndex()' function is called
and the login page is displayed.
*/
// Check user not logged in already:
checkLoggedIn("no");

// Page title:
$title="Member Login Page";

// if $submit variable set, login info submitted:
if(isset($_POST["submit"])) {
//
// Check fields were filled in
//
// login must be between 4 and 15 chars containing alphanumeric chars only:
field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15);
// password must be between 4 and 15 chars - any characters can be used:
field_validator("rsPass", $_POST["rsPass"], "string", 4, 15);

// if there are $messages, errors were found in validating form data
// show the index page (where the messages will be displayed):
if($messages){
	doIndex();
	// note we have to explicity 'exit' from the script, otherwise
	// the lines below will be processed:
	exit;
}

// OK if we got this far the form field data was of the right format;
// now check the user/pass pair match those stored in the db:
/*
If checkPass() is successful (ie the login and password are ok),
then $row contains an array of data containing the login name and
password of the user.
If checkPass() is unsuccessful however, $row will simply contain
the value 'false' - and so in that case an error message is
stored in the $messages array which will be displayed to the user.
*/
    if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) {
	// login/passwd string not correct, create an error message:
        $messages[]="Incorrect login/password, try again";
    }

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
	doIndex();
	exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["rsUser"], $row["rsPass"]);

// and finally forward user to members page (populating the session id in the URL):
header("Location: main.php");
} else {
// The login form wasn't filled out yet, display the login form for the user to fill in:
doIndex();
}

/*
This function displays the default 'index' page for this script.  This consists of just a simple
login form for the user to submit their username and password.
*/
function doIndex() {
/*
Import the global $messages array.
If any errors were detected above, they will be stored in the $messages array:
*/
global $messages;

/*
also import the $title for the page - note you can normally just declare all globals on one line
- ie:
global $messages, $title;
*/
global $title;

// drop out of PHP mode to display the plain HTML:
$Townsearch = $_REQUEST['rsTown'];


// Delimiters may be slash, dot, or hyphen

list($Town, $County) = split('[,]', $Townsearch);
$_SESSION['county'] = $County;
?>
<!doctype html>
<html>
<head>
<title>Pubs and bars in <? echo $Townsearch;?></title>
<meta name="description" content="Pubs, bars and restuarants in <? echo $Townsearch;?>" />
<meta name="keywords" content="<? echo $Townsearch;?>, pubs, bars, food, drink, nightlife" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
	if(inputString.length == 0) {
		// Hide the suggestion box.
		$('#suggestions').hide();
	} else {
		$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
			if(data.length >0) {
				$('#suggestions').show();
				$('#autoSuggestionsList').html(data);
			}
		});
	}
} // lookup

function fill(thisValue) {
	$('#inputString').val(thisValue);
	setTimeout("$('#suggestions').hide();", 200);
}
</script>
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
	<h1>My Pub Space
	 <a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
	 <span>
		 <form method="post" class="textbox" action="search.php?rsTown=<? echo $Town ?>&rsCounty=<? echo $County ?>">
				Town/City: <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>
	</span>		</h1>
</div>
</header>
<nav>
<ul>
	<li class="selected"><a href="#">Home</a></li>
	<li><a href="#">Pubs</a></li>
	<li><a href="#">Members</a></li>
	<li><a href="#">Events</a></li>
	<li><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
	<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
	<section>
		<article class="blogPost">
			<header>
				<h2>Pubs in <? echo $Town;?>, <? echo $_SESSION['county'];?></h2>
				<p>Posted on
					<time datetime="2009-06-29T23:31+01:00">June 29th 2009</time>
					by <a href="#">Mads Kjaer</a> - <a href="#comments">3 comments</a></p>
			</header>
			<?php

$tableName="pubs";		
$targetpage = "search.php"; 	
$limit = 20; 

$query = "SELECT COUNT(*) as num FROM $tableName WHERE rsTown LIKE '$Town%'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
$page = $_GET['page'];
if($page){
	$start = ($page - 1) * $limit; 
}else{
	$start = 0;	
	}	

    // Get page data
$query1 = "SELECT * FROM $tableName WHERE rsTown LIKE '$Town%' LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	




	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev&rsTown=$Town'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1&rsTown=$Town'>1</a>";
			$paginate.= "<a href='$targetpage?page=2&rsTown=$Town'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next&rsTown=$Town'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}

	$paginate.= "</div>";		


}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>

<ul>

<?php 


	while($row = mysql_fetch_array($result))
	{

	echo '<li>'.$row['rsPubName'].', '.$row['rsTown'].', '.$row['rsCounty'].'</li>';

	}

?>
</ul>
		</article>
	</section>
	<section id="comments">
		<h3>Comments</h3>
		<article>
			<header> <a href="#">George Washington</a> on
				<time datetime="2009-06-29T23:35:20+01:00">June 29th 2009 at 23:35</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Benjamin Franklin</a> on
				<time datetime="2009-06-29T23:40:09+01:00">June 29th 2009 at 23:40</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Barack Obama</a> on
				<time datetime="2009-06-29T23:59:00+01:00">June 29th 2009 at 23:59</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
	</section>
	<form action="" method="POST" method="post">
		<h3>Post a comment</h3>
		<p>
			<label for="name">Name</label>
			<input name="name" id="name" type="text" required />
		</p>
		<p>
			<label for="email">E-mail</label>
			<input name="email" id="email" type="email" required />
		</p>
		<p>
			<label for="website">Website</label>
			<input name="website" id="website" type="url" />
		</p>
		<p>
			<label for="comment">Comment</label>
			<textarea name="comment" id="comment" required></textarea>
		</p>
		<p>
			<input type="submit" value="Post comment" />
		</p>
	</form>
</div>
<aside>
	<section>
		<header>
			<h3>Members Login Area</h3>
		</header>
		<form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>">
			Username: <br />
			<input type="text" class="textbox" name="rsUser" value="<?php print isset($_POST["rsUser"]) ? $_POST["rsUser"] : "" ; ?>">
			Password: <br />
			<input type="password" class="textbox" name="rsPass">
			<br />
			<br />
			<input name="submit" type="submit" value="Login">
			<br />
		</form>
		<ul>
			<li><a href="#">Sign up</a></li>
			<li><a href="#">Forgot Password</a></li>
		</ul>
	</section>
	<section>
		<header>
			<h3>Archives</h3>
		</header>
		<ul>
			<li><a href="#">December 2008</a></li>
			<li><a href="#">January 2009</a></li>
			<li><a href="#">February 2009</a></li>
			<li><a href="#">March 2009</a></li>
			<li><a href="#">April 2009</a></li>
			<li><a href="#">May 2009</a></li>
			<li><a href="#">June 2009</a></li>
		</ul>
	</section>
</aside>
</div>
<footer>
<div>
	<section id="about">
		<header>
			<h3>About</h3>
		</header>
		<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
	</section>
	<section id="blogroll">
		<header>
			<h3>Blogroll</h3>
		</header>
		<ul>
			<li><a href="#">NETTUTS+</a></li>
			<li><a href="#">FreelanceSwitch</a></li>
			<li><a href="#">In The Woods</a></li>
			<li><a href="#">Netsetter</a></li>
			<li><a href="#">PSDTUTS+</a></li>
		</ul>
	</section>
	<section id="popular">
		<header>
			<h3>Popular</h3>
		</header>
		<ul>
			<li><a href="#">This is the title of a blog post</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
			<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
			<li><a href="#">Duis aute irure dolor</a></li>
			<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
			<li><a href="#">Reprehenderit in voluptate velit</a></li>
			<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
		</ul>
	</section>
</div>
</footer>
</body>
</html>
<?php
}
?>

Link to comment
Share on other sites

I am getting Undefined offset on line 116:<b>Notice</b>:  Undefined offset:  1 in <b>D:\retroandvintage.co.uk\wwwroot\search.php</b> on line <b>116</b><br />

 

 

$Townsearch = $_REQUEST['rsTown'];


// Delimiters may be slash, dot, or hyphen

list($Town, $County) = split('[,]', $Townsearch);
$_SESSION['county'] = $County;

 

Link to comment
Share on other sites

main.php

Login at: [url]http://www.retroandvintage.co.uk[/url] using: test/test
<?php
include_once("config.php");
include_once("functions.php");
// Check user logged in already:
checkLoggedIn("yes");
$Townsearch = $_REQUEST['rsTown'];
list($Town, $County) = split('[,]', $Townsearch);
ltrim($County,1);
?>
<!doctype html>
<html>
<head>
<title>Pubs and bars in the UK</title>
<meta name="description" content="xxx" />
<meta name="keywords" content="xxx" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
	if(inputString.length == 0) {
		// Hide the suggestion box.
		$('#suggestions').hide();
	} else {
		$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
			if(data.length >0) {
				$('#suggestions').show();
				$('#autoSuggestionsList').html(data);
			}
		});
	}
} // lookup

function fill(thisValue) {
	$('#inputString').val(thisValue);
	setTimeout("$('#suggestions').hide();", 200);
}
</script>
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
	<h1>My Pub Space
	 <a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
	 <span>
		 <form method="post" class="textbox" action="search1.php?rsTown=<? echo $Town ?>&rsCounty=<? echo $County ?>">
				Town/City: <input type="text" size="26" class="searchbox" value="" name="rsTown" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" />
			<input type="hidden" value="<? echo $County ?>" name="rsCounty" 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>
	</span>		</h1>
</div>
</header>
<nav>
<ul>
	<li class="selected"><a href="main.php">Home</a></li>
	<li><a href="#">Pubs</a></li>
	<li><a href="#">Members</a></li>
	<li><a href="#">Events</a></li>
	<li><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
	<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
	<section>
		<article class="blogPost">
			<header>
				<h2>This is the title of a blog post</h2>
				<p>Posted on
					<time datetime="2009-06-29T23:31+01:00">June 29th 2009</time>
					by <a href="#">Mads Kjaer</a> - <a href="#comments">3 comments</a></p>
			</header>
			<?php

$tableName="pubs";		
$targetpage = "main.php"; 	
$limit = 20; 

$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
$page = mysql_escape_string($_REQUEST['page']);
if( isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) ) {
      $page = (int) $_GET['page'];
      $start = ($page - 1) * $limit;
}else{
      $start = 0;   
}

    // Get page data
$query1 = "SELECT * FROM $tableName LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	




	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}

	$paginate.= "</div>";		


}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>

<ul>

<?php 


	while($row = mysql_fetch_array($result))
	{

	echo '<li>'.$row['rsPubName'].', '.$row['rsTown'].', '.$row['rsCounty'].'</li>';
	if	($_SESSION["rsUser"] == "admin")
{
	echo "<a href=\"edit.php?PUBID=".$row['PubID']."\" class=\"small\">edit this pub</a>";
}

	}

?>
</ul>
		</article>
	</section>
	<section id="comments">
		<h3>Comments</h3>
		<article>
			<header> <a href="#">George Washington</a> on
				<time datetime="2009-06-29T23:35:20+01:00">June 29th 2009 at 23:35</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Benjamin Franklin</a> on
				<time datetime="2009-06-29T23:40:09+01:00">June 29th 2009 at 23:40</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Barack Obama</a> on
				<time datetime="2009-06-29T23:59:00+01:00">June 29th 2009 at 23:59</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
	</section>
	<form action="#" method="POST" method="post">
		<h3>Post a comment</h3>
		<p>
			<label for="name">Name</label>
			<input name="name" id="name" type="text" required />
		</p>
		<p>
			<label for="email">E-mail</label>
			<input name="email" id="email" type="email" required />
		</p>
		<p>
			<label for="website">Website</label>
			<input name="website" id="website" type="url" />
		</p>
		<p>
			<label for="comment">Comment</label>
			<textarea name="comment" id="comment" required></textarea>
		</p>
		<p>
			<input type="submit" value="Post comment" />
		</p>
	</form>
</div>
<aside>
	<section>
		<header>
			<h3>Members Login Area</h3>
		</header>
		<h4>Welcome <? print($_SESSION["rsUser"]); ?></h4>
		<a href="logout.php">Logout</a>
	</section>
	<section>
		<header>
			<h3>Archives</h3>
		</header>
		<ul>
			<li><a href="#">December 2008</a></li>
			<li><a href="#">January 2009</a></li>
			<li><a href="#">February 2009</a></li>
			<li><a href="#">March 2009</a></li>
			<li><a href="#">April 2009</a></li>
			<li><a href="#">May 2009</a></li>
			<li><a href="#">June 2009</a></li>
		</ul>
	</section>
</aside>
</div>
<footer>
<div>
	<section id="about">
		<header>
			<h3>About</h3>
		</header>
		<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
	</section>
	<section id="blogroll">
		<header>
			<h3>Blogroll</h3>
		</header>
		<ul>
			<li><a href="#">NETTUTS+</a></li>
			<li><a href="#">FreelanceSwitch</a></li>
			<li><a href="#">In The Woods</a></li>
			<li><a href="#">Netsetter</a></li>
			<li><a href="#">PSDTUTS+</a></li>
		</ul>
	</section>
	<section id="popular">
		<header>
			<h3>Popular</h3>
		</header>
		<ul>
			<li><a href="#">This is the title of a blog post</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
			<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
			<li><a href="#">Duis aute irure dolor</a></li>
			<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
			<li><a href="#">Reprehenderit in voluptate velit</a></li>
			<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
		</ul>
	</section>
</div>
</footer>
</body>
</html>

 

Search1.php

<?php
session_start();
include_once("config.php");
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
// Check user logged in already:
checkLoggedIn("yes");
$Townsearch = $_REQUEST['rsTown'];
$County = $_REQUEST['rsCounty'];

// Delimiters may be slash, dot, or hyphen
list($Town, $County1) = split('[,]', $Townsearch);
$County1 = substr($County1, 1);

?>
<!doctype html>
<html>
<head>
<title>Pubs and bars in <? echo $Town;?>, <? echo $County1;?></title>
<meta name="description" content="Pubs, bars and restuarants in <? echo $Townsearch;?>" />
<meta name="keywords" content="<? echo $Townsearch;?>, pubs, bars, food, drink, nightlife" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
	if(inputString.length == 0) {
		// Hide the suggestion box.
		$('#suggestions').hide();
	} else {
		$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
			if(data.length >0) {
				$('#suggestions').show();
				$('#autoSuggestionsList').html(data);
			}
		});
	}
} // lookup

function fill(thisValue) {
	$('#inputString').val(thisValue);
	setTimeout("$('#suggestions').hide();", 200);
}
</script>
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
	<h1>My Pub Space
	 <a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
	 <span>
		 <form method="post" class="textbox" action="search1.php?rsTown=<? echo $Town; ?>&rsCounty=<? echo $County1; ?>">
				Town/City: <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>
	</span>		</h1>
</div>
</header>
<nav>
<ul>
	<li class="selected"><a href="main.php">Home</a></li>
	<li><a href="#">Pubs</a></li>
	<li><a href="#">Members</a></li>
	<li><a href="#">Events</a></li>
	<li><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
	<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
	<section>
		<article class="blogPost">
			<header>
				<h2>Pubs in <? echo $Town;?>, <? echo $County1;?></h2>
				<p>Posted on
					<time datetime="2009-06-29T23:31+01:00">June 29th 2009</time>
					by <a href="#">Mads Kjaer</a> - <a href="#comments">3 comments</a></p>
			</header>
			<?php

$tableName="pubs";		
$targetpage = "search1.php"; 	
$limit = 20; 

$query = "SELECT COUNT(*) as num FROM $tableName WHERE rsTown LIKE '$Town%'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
$page = $_GET['page'];
if($page){
	$start = ($page - 1) * $limit; 
}else{
	$start = 0;	
	}	

    // Get page data
$query1 = "SELECT * FROM $tableName WHERE rsTown LIKE '$Town%' LIMIT $start, $limit";
$result = mysql_query($query1);
echo $paginate['rsTown'];
// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	



	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev&rsTown=$Town&rsCounty=$County1'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town&rsCounty=$County1'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town&rsCounty=$County1'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town&rsCounty=$County1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town&rsCounty=$County1'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1&rsTown=$Town&rsCounty=$County1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2&rsTown=$Town&rsCounty=$County1'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town&rsCounty=$County1'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1&rsTown=$Town&rsCounty=$County1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage&rsTown=$Town&rsCounty=$County1'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1&rsCounty=$County1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2&rsCounty=$County1'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter&rsTown=$Town&rsCounty=$County1'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next&rsTown=$Town&rsCounty=$County1'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}

	$paginate.= "</div>";		


}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>

<ul>

<?php 


	while($row = mysql_fetch_array($result))
	{

	echo '<li>'.$row['rsPubName'].', '.$row['rsTown'].', '.$row['rsCounty'].'</li>';
	if	($_SESSION["rsUser"] == "admin")
{
	echo "<a href=\"edit.php?PUBID=".$row['PubID']."\" class=\"small\">edit this pub</a>";
}
	}
$_SESSION['county'] = $row['rsCounty'];
?>
</ul>
		</article>
	</section>
	<section id="comments">
		<h3>Comments</h3>
		<article>
			<header> <a href="#">George Washington</a> on
				<time datetime="2009-06-29T23:35:20+01:00">June 29th 2009 at 23:35</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Benjamin Franklin</a> on
				<time datetime="2009-06-29T23:40:09+01:00">June 29th 2009 at 23:40</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
		<article>
			<header> <a href="#">Barack Obama</a> on
				<time datetime="2009-06-29T23:59:00+01:00">June 29th 2009 at 23:59</time>
			</header>
			<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
		</article>
	</section>
	<form action="" method="POST" method="post">
		<h3>Post a comment</h3>
		<p>
			<label for="name">Name</label>
			<input name="name" id="name" type="text" required />
		</p>
		<p>
			<label for="email">E-mail</label>
			<input name="email" id="email" type="email" required />
		</p>
		<p>
			<label for="website">Website</label>
			<input name="website" id="website" type="url" />
		</p>
		<p>
			<label for="comment">Comment</label>
			<textarea name="comment" id="comment" required></textarea>
		</p>
		<p>
			<input type="submit" value="Post comment" />
		</p>
	</form>
</div>
<aside>
	<section>
		<header>
			<h3>Members Login Area</h3>
		</header>
		<h4>Welcome <? print($_SESSION["rsUser"]); ?></h4>
		<a href="logout.php">Logout</a>
		</ul>
	</section>
	<section>
		<header>
			<h3>Archives</h3>
		</header>
		<ul>
			<li><a href="#">December 2008</a></li>
			<li><a href="#">January 2009</a></li>
			<li><a href="#">February 2009</a></li>
			<li><a href="#">March 2009</a></li>
			<li><a href="#">April 2009</a></li>
			<li><a href="#">May 2009</a></li>
			<li><a href="#">June 2009</a></li>
		</ul>
	</section>
</aside>
</div>
<footer>
<div>
	<section id="about">
		<header>
			<h3>About</h3>
		</header>
		<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
	</section>
	<section id="blogroll">
		<header>
			<h3>Blogroll</h3>
		</header>
		<ul>
			<li><a href="#">NETTUTS+</a></li>
			<li><a href="#">FreelanceSwitch</a></li>
			<li><a href="#">In The Woods</a></li>
			<li><a href="#">Netsetter</a></li>
			<li><a href="#">PSDTUTS+</a></li>
		</ul>
	</section>
	<section id="popular">
		<header>
			<h3>Popular</h3>
		</header>
		<ul>
			<li><a href="#">This is the title of a blog post</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
			<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
			<li><a href="#">Duis aute irure dolor</a></li>
			<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
			<li><a href="#">Reprehenderit in voluptate velit</a></li>
			<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
			<li><a href="#">Lorem ipsum dolor sit amet</a></li>
		</ul>
	</section>
</div>
</footer>
</body>
</html>

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.