...

View Full Version : Need to pass variable through querystring?!



jarv
01-14-2011, 11:46 PM
I was told I need to use Ajax XML HTTPRequest

Can someone please help me here?
basically, I need to pass $RSCOUNTY1 through the query string


<a href="#$RSCOUNTY1" class="digg-count">$CountyCount</a>

jarv
01-15-2011, 11:27 AM
can anyone help me here?

DJCMBear
01-15-2011, 01:32 PM
Can you show the codes you have currently and show how you want the url to look?

jarv
01-15-2011, 09:30 PM
<?
$offset = (isset($_GET['start'])) ? (int)$_GET["start"] : 0;
$rowsPerPage = (isset($_GET['count'])) ? (int)$_GET["count"] : 10;
$query = "SELECT * FROM pubs WHERE rsCounty = 'East Sussex' 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">Logout1</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">$CountyCount</a>
<a href="#$RSCOUNTY1">$RSCOUNTY1</a></li>
EOF;
}
echo "</ul>";

// start East Sussex
echo "<ul title=\"Pubs in East Sussex\" id=\"East Sussex\">";
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


I just want to pass $RSCOUNTY1 through the querystring

<li><a href="#$RSCOUNTY1" class="digg-count">$CountyCount</a>

DJCMBear
01-15-2011, 11:30 PM
Do you want the page to reload of not?

If you don't mind about a reload then you can use this in the href href="?rscounty={$RSCOUNTY1}"

jarv
01-15-2011, 11:54 PM
I have tried this with an XML link, it doesn't work?!

here is my code:



<?
$CountyName = filter_input(INPUT_GET, 'CountyName', FILTER_SANITIZE_STRING);

$offset = (isset($_GET['start'])) ? (int)$_GET["start"] : 0;
$rowsPerPage = (isset($_GET['count'])) ? (int)$_GET["count"] : 10;
$query = "SELECT * FROM pubs";
if ($CountyName ) $query .= " WHERE rsCounty = '$CountyName'";
$query .= " 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">Logout1</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="?rscounty={$RSCOUNTY1}" class="digg-count">$CountyCount</a>
<a href="#$RSCOUNTY1">$RSCOUNTY1</a></li>
EOF;
}
echo "</ul>";

// start East Sussex
echo "<ul title=\"$CountyName\" id=\"$CountyName\">";
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

DJCMBear
01-16-2011, 12:08 PM
Simple way to do it.


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.

<a href="javascript:void(0);" onclick="Send('this is the text that will be sent');">Hello World</a>

jarv
01-16-2011, 12:42 PM
thanks, I just tried that, there is a javascript error:

AJAX is not a constructor
[Break On This Error] AJAX = new AJAX();

Also, I would then need to set the requested value as a php variable

DJCMBear
01-16-2011, 12:47 PM
Just remove the word new, and how do you mean set the requested value as a PHP variable?

jarv
01-16-2011, 01:01 PM
thanks for your help but the code you gave me doesn't work?!



<!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)

jarv
01-16-2011, 01:45 PM
here is the link

http://www.mypubspace.com/iphone/pubs/default.php#___1__

user: test
password: test

if you click on Aberdeenshire this is the only one that works, I have set it up manually


here is my current code with Aberdeenshire working


<?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>

</head>

<body>
<?
$CountyName = filter_input(INPUT_GET, 'CountyName', FILTER_SANITIZE_STRING);

$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="#$RSCOUNTY1short" class="digg-count">$CountyCount</a>
<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>

akosiana
01-16-2011, 02:49 PM
you may try below:

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..

jarv
01-16-2011, 09:19 PM
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:




<?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>



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum