Can you show the codes you have currently and show how you want the url to look?
__________________
Official BinPress hand picked coder.
For anyone worried about SQL injection go have a look at my small yet powerful script here.
Go Pledge for Light Table, if it hit's $300,000 Python and other languages will get added.
I am 1 of 65,608 people to get a Pebble Watch :P
If you don't mind about a reload then you can use this in the href href="?rscounty={$RSCOUNTY1}"
__________________
Official BinPress hand picked coder.
For anyone worried about SQL injection go have a look at my small yet powerful script here.
Go Pledge for Light Table, if it hit's $300,000 Python and other languages will get added.
I am 1 of 65,608 people to get a Pebble Watch :P
function AJAX() {
var xmlhttp;
if(window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
} else {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
return xmlhttp;
}
function Send(o) {
var unix = Math.round(new Date().getTime() / 1000),
AJAX = new AJAX();
AJAX.onreadystatechange=function() {
if(AJAX.readyState==4 && AJAX.status==200) {
alert(AJAX.responseText);
}
};
AJAX.open("POST","http://www.example.com/page.php",true);
AJAX.setRequestHeader("Content-type","application/x-www-form-urlencoded");
AJAX.send('unix='+unix+'&text='+o); // Things you want to post in the query
}
And on the link you would do this.
Code:
<a href="javascript:void(0);" onclick="Send('this is the text that will be sent');">Hello World</a>
__________________
Official BinPress hand picked coder.
For anyone worried about SQL injection go have a look at my small yet powerful script here.
Go Pledge for Light Table, if it hit's $300,000 Python and other languages will get added.
I am 1 of 65,608 people to get a Pebble Watch :P
Just remove the word new, and how do you mean set the requested value as a PHP variable?
__________________
Official BinPress hand picked coder.
For anyone worried about SQL injection go have a look at my small yet powerful script here.
Go Pledge for Light Table, if it hit's $300,000 Python and other languages will get added.
I am 1 of 65,608 people to get a Pebble Watch :P
thanks for your help but the code you gave me doesn't work?!
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>
<body>
<script type="text/javascript" language="javascript">
function AJAX() {
var xmlhttp;
if(window.XMLHttpRequest) {
xmlhttp = XMLHttpRequest();
} else {
xmlhttp = ActiveXObject("Microsoft.XMLHTTP");
}
return xmlhttp;
}
function Send(o) {
var unix = Math.round(new Date().getTime() / 1000),
AJAX = AJAX();
AJAX.onreadystatechange=function() {
if(AJAX.readyState==4 && AJAX.status==200) {
alert(AJAX.responseText);
}
};
AJAX.open("POST","http://www.example.com/page.php",true);
AJAX.setRequestHeader("Content-type","application/x-www-form-urlencoded");
AJAX.send('unix='+unix+'&text='+o); // Things you want to post in the query
}
</script>
<a href="javascript:void(0);" onclick="Send('this is the text that will be sent');">Hello World</a>
</body>
</html>
basically, what I am trying to do is send a County Name through the querystring then request it and set it as a variable so I can use it in my SQL string to filter WHERE CountyName = (the requested County Name)
modify your link to this:
<li><a href="#$RSCOUNTY1" class="digg-count" onClick="passcountryval(this.href)">$CountyCount</a> <input type="hidden" name="start" id="start" /></li>
then create a js script, inseart in between header tags
<script type="text/javascript">
<!--
function passcountryval(valhref)
{
document.getElementById('start').value = valhref;
}
-->
</script>
I just create a container for "start" as your action page is asking for $_GET['start'] , if your page won't pass any value to what your action page is asking.. it will ready indeed won't execute well..
thanks, I tried what you suggested and tried echoing it out and I get this: <b>Notice</b>: Undefined index: start in <b>D:\mypubspace.com\wwwroot\iphone\pubs\pubs.php</b> on line <b>74</b><br />
here is my code now:
Code:
<?php
include_once("config.php");
include_once("functions.php");
// Check user logged in already:
checkLoggedIn("yes");
//doCSS(); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>My Pub Space</title>
<link rel="stylesheet" type="text/css" href="stylesheets/style1.css" title="default" />
<meta name="viewport" content="width=device-width; initial-scale=1.0; minimum-scale=1.0; maximum-scale=1.0; user-scalable=0;"/>
<link rel="apple-touch-icon" href="../iui/iui/mps-icon.png" />
<style type="text/css" media="screen">@import "../iui/iui/iui.css";</style>
<script type="application/x-javascript" src="../iui/iui/iui.js"></script>
<meta name="apple-touch-fullscreen" content="YES" />
<script type="text/javascript" src="js/jva.js"></script>
<script type="text/javascript">
<!--
function passcountryval(valhref)
{
document.getElementById('start').value = valhref;
}
-->
</script>
<style type="text/css">
body > ul > li {
font-size: 14px;
}
body > ul > li > a {
padding-left: 54px;
padding-right: 40px;
min-height: 34px;
}
li .digg-count {
display: block;
position: absolute;
margin: 0;
left: 6px;
top: 7px;
text-align: center;
font-size: 110%;
letter-spacing: -0.07em;
color: #93883F;
font-weight: bold;
text-decoration: none;
width: 36px;
height: 30px;
padding: 7px 0 0 0;
background: url(shade-compact.gif) no-repeat;
}
h2 {
margin: 10px;
color: slateblue;
}
p {
margin: 10px;
}
</style>
</head>
<body>
<?
$CountyName = filter_input(INPUT_GET, 'start', FILTER_SANITIZE_STRING);
echo $CountyName;
$CountyName1 = $_GET['start'];
echo $CountyName1;
$offset = (isset($_GET['start'])) ? (int)$_GET["start"] : 0;
$rowsPerPage = (isset($_GET['count'])) ? (int)$_GET["count"] : 10;
$query = "SELECT * FROM pubs WHERE rsCounty = 'Aberdeenshire' 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);
$County1 = $result1['rsCounty'];
$CountyCount = $result1['County_Count'];
?>
<div class="toolbar">
<h1 id="pageTitle">Select County</h1>
<a id="backButton" class="button" href="#"></a>
<a class="button" href="logout.php" target="_self">Logout</a>
</div>
<ul title="Select County" id="county" selected="true">
<?php
while ($row = mysql_fetch_assoc($result1)){
$RSCOUNTY1 = $row['rsCounty'];
$RSCOUNTY1short = substr($row['rsCounty'],0,4);
$CountyCount = $row['County_Count'];
echo <<<EOF
<li><a href="#$RSCOUNTY1" class="digg-count" onClick="passcountryval(this.href)">$CountyCount</a> <input type="hidden" name="start" id="start" />
<a href="#$RSCOUNTY1short">$RSCOUNTY1</a></li>
EOF;
}
echo "</ul>";
// start East Sussex
echo "<ul title=\"Aberdeenshire\" id=\"Aber\">";
while($row = mysql_fetch_array($result)){
$PUBID = $row['PUBID'];
$rsPubName = $row['rsPubName'];
$rsAddress = $row['rsAddress'];
$rsPostCode = $row['rsPostCode'];
$rsTel = $row['rsTel'];
$rsTown = $row['rsTown'];
$rsCounty = $row['rsCounty'];
// how many rows we have in database
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$next = "<li><a href=\"all.php?start=" . ($offset + $rowsPerPage) . "&count={$rowsPerPage}\" target=\"_replace\">View More</a></li>";
//div container of header and information
echo <<<EOF
<li><a href="viewpub.php?PUBID=$PUBID">$rsPubName</a></li>
EOF;
if ($_SESSION["RSUSER"] == "admin")
{
echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</a>";
}
}
echo $next;
echo "</ul>";
// End East Sussex
// start London
echo "<ul title=\"Pubs in London\" id=\"Lond\">";
while($row = mysql_fetch_array($result2)){
$PUBID = $row['PUBID'];
$RSPUBNAME = $row['RSPUBNAME'];
$RSADDRESS = $row['RSADDRESS'];
$RSPOSTCODE = $row['RSPOSTCODE'];
$RSTEL = $row['RSTEL'];
$RSTOWN = $row['RSTOWN'];
$RSCOUNTY = $row['RSCOUNTY'];
// how many rows we have in database
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$next = "<li><a href=\"all2.php?start=" . ($offset + $rowsPerPage) . "&count={$rowsPerPage}\" target=\"_replace\">View More</a></li>";
//div container of header and information
echo <<<EOF
<li><a href="viewpub.php?PUBID=$PUBID">$RSPUBNAME</a></li>
EOF;
if ($_SESSION["RSUSER"] == "admin")
{
echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</a>";
}
}
echo $next;
echo "</ul>";
// End London
?>
</body>
</html>
Before you post, read our: 
Need to pass variable through querystring?!
