Heres exactly what i'm trying to do, i'm trying to modify the script you gave me a hand with a while ago(louie) which populated a second select field based on the first select field, now im trying to display results on a page based on what link option chosen but with the url not changing so it stays as /releases.htm.
I'm completely stumped!
first page:
PHP Code:
<?php
include('***');
if(isset($_GET['stype']))
{
$stype = $_GET['stype'];
}
else
{
$stype = "all";
}
dbConnect();
echo'
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>releases'.get_prop("site_title_name").'</title>
<script type="text/javascript" language="javascript">
var loading_img = \'images/loading.gif\';
var loading_msg = \' Loading Data...\';
var xmlhttp_obj = false;
function ie_xmlhttp() {
if (window.XMLHttpRequest) {
xmlhttp_obj = new XMLHttpRequest();
} else if (window.ActiveXObject) {
try {
xmlhttp_obj = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp_obj = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {
}
}
} else {
xmlhttp_obj = false;
}
return xmlhttp_obj;
}
function getcontent(url,containerid) {
var xmlhttp_obj = ie_xmlhttp();
document.getElementById(containerid).innerHTML = \'<img src="\'+loading_img+\'"/>\'+loading_msg;
xmlhttp_obj.onreadystatechange=function() {
loadpage(xmlhttp_obj,containerid);
}
xmlhttp_obj.open(\'GET\',url,true);
xmlhttp_obj.send(null);
}
function loadpage(xmlhttp_obj,containerid) {
if (xmlhttp_obj.readyState == 4 && xmlhttp_obj.status == 200) {
document.getElementById(containerid).innerHTML = xmlhttp_obj.responseText;
}
}
//]]>
</script>
</head>';
site_header();
$rowsPerPage = 10;
// 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;
$numrows = row_count_releases();
// 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=\"../releases/".$page.".htm\">$page</a> ";
}
}
// 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
}
if((isset($_GET['page'])) && ($_GET['page'] > 0) && ($_GET['page'] <= $maxPage) && (is_numeric($_GET['page']) == true))
{
echo'<div id="releases_listing_item_wrapper_main">
<span id="span1">
</span>
</div>
<div id="releases_listing_item_selection_type">
<div id="releases_listing_item_selection_type_title">» search options</div>
<div id="releases_listing_item_selection_type_options_text">alphabet</div>
<div id="releases_listing_item_selection_type_options_body">
<a href="releases/1-a.htm">a</a>
<a href="releases/1-b.htm">b</a>
<a href="releases/1-c.htm">c</a>
<a href="releases/1-d.htm">d</a>
<a href="releases/1-e.htm">e</a>
<a href="releases/1-f.htm">f</a>
<a href="releases/1-g.htm">g</a>
<a href="releases/1-h.htm">h</a>
<a href="releases/1-i.htm">i</a>
<a href="releases/1-j.htm">j</a>
<a href="releases/1-k.htm">k</a>
<a href="releases/1-l.htm">l</a>
<a href="releases/1-m.htm">m</a>
<a href="releases/1-n.htm">n</a>
<a href="releases/1-o.htm">o</a>
<a href="releases/1-p.htm">p</a>
<a href="releases/1-q.htm">q</a>
<a href="releases/1-r.htm">r</a>
<a href="releases/1-r.htm">s</a>
<a href="releases/1-t.htm">t</a>
<a href="releases/1-u.htm">u</a>
<a href="releases/1-v.htm">v</a>
<a href="releases/1-w.htm">w</a>
<a href="releases/1-x.htm">x</a>
<a href="releases/1-y.htm">y</a>
<a href="releases/1-z.htm">z</a>
</div>
</div>
<div id="pagation_wrapper"><div class="pagation_link">Page: '.$nav.'</div></div>
</div>
</div>
</div>';
site_footer();
closeConnect();
?>
And i have the other page like so:
PHP Code:
<?php
include('db.php');
dbConnect();
$txt = "";
$qs = $_GET['stype'] != "" ? preg_replace("#[^0-9]#","",$_GET['stype']) : "1"; //I use preg_replace to sanitse the get request
//which in this case must be numbers
//this is manually created but it can easily populated froma database
if($qs != "")
{
$k = 0;
$sql = mysql_query("SELECT id,name FROM releases ORDER BY name ASC LIMIT ".$offset.",".$rowsPerPage."");
while($row = mysql_fetch_array($sql))
{
$link_name = preg_replace('#[^a-zA-Z0-9]+#','-',$row['name']);
$i = 0;
$j = $k + 1;
echo'<div class="releases_listing_item_wrapper" style="background-color:#'.check_bk_colour($k).';">
<div class="releases_listing_item_name"><div class="releases_item_front_link_'.$j.'"><a href="game-details/'.$row['id'].'-'.$link_name.'.htm">'.$row['name'].'<a/></div></div>
</div>
';
if($k == 0)
{$k=1;}
else
{$k=0;}
}
}
closeConnect();
?>
04-03-2008, 11:21 PM
PHP/AJAX based display problem. 
TOTW/F/M Award(s): 1
