Page 5 - $_GET using an iframe

Dev Shed Forums Sponsor:

#61

July 2nd, 2009, 05:03 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Folding Points: 33832 Folding Title: Starter Folder

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Quote:

Originally Posted by simshaun

Deviating just a little bit, do your counties have id numbers attached to them in the database? I assume they probably do. If so, it may be a better idea to pass the id number instead of the county name, instead of worrying about passing both the county and state names.

Yes... all have id associated with them.

#62

July 2nd, 2009, 05:10 PM

simshaun

$x=104;echo chr($x++),chr($x);

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Mar 2008

Location: North Carolina

Posts: 1,658

Folding Points: 18142 Folding Title: Novice Folder

Time spent in forums: 2 Weeks 4 Days 2 h 18 m 38 sec
Reputation Power: 1384

You should change your php to output the state's ID number and the county's ID number in their appropriate link's rel tag instead of the state's name and the county's name. The JavaScript shouldn't need to change at all to accommodate this; only "yourbannerloader.php" will change. Give me a bit and I'll try and think of a way to rotate the images. (Have an idea brewing in my head, just need to think it out.

)

#63

July 2nd, 2009, 05:12 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Quote:

Originally Posted by simshaun

)

Alright... Thanks.

Also, would like them to be random.... 1 I came across would rotate them in the same order entirely.... so if I clicked Gainesville, it would show the 1st, then 2nd, etc.... then if I clicked Marion, it would restart from the 1st, then 2nd, etc...

#64

July 2nd, 2009, 07:38 PM

simshaun

$x=104;echo chr($x++),chr($x);

Join Date: Mar 2008

Location: North Carolina

Posts: 1,658

Time spent in forums: 2 Weeks 4 Days 2 h 18 m 38 sec
Reputation Power: 1384

Ok this is what I came up with.

retrieve_banners.html

html Code:

Original - html 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>Sample JSON Test.</title>
<script type="text/javascript" src="jquery-1.3.2.min.js"></script>
</head>

<body>
<script type="text/javascript">
$(function() {
	var $ad = $('#ad');
	$ad.data('ad_index', 0);

$.ajax({
		type: 'post'
		,url: 'yourbannerad.php'
		,data: { }
		,dataType: 'json'
		,success: function(json) {
			console.log('test');
			// Build an array from the JSON object.
			var arr = [];
			$.each(json, function(index, element) {
				arr[arr.length] = [element.ad, element.url];
			});

// Dont do anything unless there was actually data returned.
			if (arr.length > 0) {
				// Immediately display a banner.
				random_ad(arr);

// If there is more than 1 ad, start rotating them.
				if (arr.length > 1) {
					// Set the interval to rotate the ads.
					// The number is in millseconds. 1000 = 1 second, 10000 = 10 seconds, ....
					setInterval(function() { random_ad(arr); }, 10000);
				}
			} else {
				console.log('No data.');
			}
		}
	});

function random_ad(arr) {
		// Retrieve the ad_index.
		var ad_index = $ad.data('ad_index');

// Restart the rotation after we reach the last ad.
		if (ad_index == arr.length) {
			var ad_index = 0;
			$ad.data('ad_index', ad_index);
		}

// Retrieve the ad data.
		var new_image = arr[ad_index][0];
		var new_url = arr[ad_index][1];

// If there is more than one element in the array, increment the ad_index so
		// the next time this function is called, the next ad is displayed.
		if (arr.length > 1) {
			var ad_index = ad_index + 1;
			$ad.data('ad_index', ad_index);
		}

// Finally, display the ad.
		$ad.html('<a href="' + new_url + '" target="_blank"><img src="' + new_image + '" alt="" />');
	}
});
</script>
<div id="ad"></div>
</body>
</html>

<!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>Sample JSON Test.</title>
<script type="text/javascript" src="jquery-1.3.2.min.js"></script>
</head>

<body>
<script type="text/javascript">
$(function() {
    var $ad = $('#ad');
    $ad.data('ad_index', 0);

    $.ajax({
        type: 'post'
        ,url: 'yourbannerad.php'
        ,data: { }
        ,dataType: 'json'
        ,success: function(json) {
            console.log('test');
            // Build an array from the JSON object.
            var arr = [];
            $.each(json, function(index, element) {
                arr[arr.length] = [element.ad, element.url];
            });

            // Dont do anything unless there was actually data returned.
            if (arr.length > 0) {
                // Immediately display a banner.
                random_ad(arr);

                // If there is more than 1 ad, start rotating them.
                if (arr.length > 1) {
                    // Set the interval to rotate the ads.
                    // The number is in millseconds. 1000 = 1 second, 10000 = 10 seconds, ....
                    setInterval(function() { random_ad(arr); }, 10000);
                }
            } else {
                console.log('No data.');
            }
        }
    });

    function random_ad(arr) {
        // Retrieve the ad_index.
        var ad_index = $ad.data('ad_index');

        // Restart the rotation after we reach the last ad.
        if (ad_index == arr.length) {
            var ad_index = 0;
            $ad.data('ad_index', ad_index);
        }

        // Retrieve the ad data.
        var new_image = arr[ad_index][0];
        var new_url = arr[ad_index][1];

        // If there is more than one element in the array, increment the ad_index so
        // the next time this function is called, the next ad is displayed.
        if (arr.length > 1) {
            var ad_index = ad_index + 1;
            $ad.data('ad_index', ad_index);
        }

        // Finally, display the ad.
        $ad.html('<a href="' + new_url + '" target="_blank"><img src="' + new_image + '" alt="" />');
    }
});
</script>
<div id="ad"></div>
</body>
</html>

yourbannerad.php

php Code:

Original - php Code

<?php
//-------------------------------------------------------------
// In this example, I assumed your database may look something
// like this:
//-------------------------------------------------------------
// Table: advertisements
//-------------------------------------------------------------
// state_id | county_id | image                       | url
//-------------------------------------------------------------
// 1        | 0         | florida/marion/image1.jpg   | http://www.google.com
// 1        | 0         | florida/marion/image2.jpg   | http://www.yahoo.com
// 1        | 0         | florida/marion/image3.jpg   | http://www.hotmail.com
// 2        | 0         | nc/iredell/image1.jpg       | http://www.digg.com
// 2        | 0         | nc/iredell/image2.jpg       | http://www.jquery.com
// 2        | 0         | nc/iredell/image3.jpg       | http://drupal.org
//-------------------------------------------------------------
// Note: This schema is not exactly how I would really design
// the database. Instead of having the full path to the image
// in the "image" column, I would only store the filename.
// I would then build the path out of segments stored in the
// states and counties tables. For the sake of simplicity, I am
// using a full path in the "image" column. Unfortunately, the
// simplicity means it will be more difficult to update your
// folder names in the future if you ever need to.
//
// To illustrate how I would be able to build the path from segments,
//-------------------------------------------------------------
// Table: states
//-------------------------------------------------------------
// state_id  | title          | folder
//-------------------------------------------------------------
// 1         | Florida        | florida
// 2         | North Carolina | nc
//-------------------------------------------------------------
// Table: counties
//-------------------------------------------------------------
// county_id | state_id | title        | folder
//-------------------------------------------------------------
// 1         | 1        | Marion       | marion
// 2         | 2        | Iredell      | iredell
//-------------------------------------------------------------
// Hopefully you see how it would be possible to build a path
// to an image if you know either the state_id or the county_id.
//-------------------------------------------------------------

// Include database config and initialize database connection.
// .............

// Initialize variables.
$sql_where = array();

/**
* This should be either state or county.
* @var string
*/
$type = strtolower($_POST['type']);

/**
* This should be the ID number of the state or county.
* @var int
*/
$value = $_POST['value'];

// Validate $value
if ($value == '') {
	exit;
}

// Validate $type
switch ($type) {
	case 'state':
		$sql_where[] = "state_id = '".mysql_real_escape_string($value)."'";
		break;
	case 'county':
		$sql_where[] = "county_id = '".mysql_real_escape_string($value)."'";
		break;
	default:
		// If $type is an unknown value, halt execution of the script.
		exit;
}

// Only get ads where the image column is not empty.
$sql_where[] = "image != ''";

// Turn our where array into a usable string.
$sql_where = implode(' AND ', $sql_where);

// Get the advertisements out of the database.
$result = mysql_query("
	SELECT
		image
		,url
	FROM
		advertisements
	WHERE
		$sql_where
") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
	$ads = array();
	while ($row = mysql_fetch_assoc($result)) {
		$ads[] = array('ad' => '/images/states/' . $row['image'], 'url' => $row['url']);
	}

// Shuffle up the array so the ads are always in a random order.
	shuffle($ads);

// Output the ads in json format.
	echo json_encode($ads);
}

// Do not go any further.
exit;

/**
* For sample/testing purposes, I have left this here.
* This illustrates what the array being returned to JavaScript
* should look like.
*/
$ads = array(
	array('ad' => '/images/states/state/county/gainesville1.jpg', 'url' => 'http://www.google.com'),
	array('ad' => '/images/states/state/county/gainesville2.jpg', 'url' => 'http://www.yahoo.com'),
	array('ad' => '/images/states/state/county/gainesville3.jpg', 'url' => 'http://www.hotmail.com'),
	array('ad' => '/images/states/state/county/gainesville4.jpg', 'url' => 'http://www.digg.com'),
	array('ad' => '/images/states/state/county/gainesville5.jpg', 'url' => 'http://www.devshed.com'),
	array('ad' => '/images/states/state/county/gainesville6.jpg', 'url' => 'http://www.sitepoint.com'),
	array('ad' => '/images/states/state/county/gainesville7.jpg', 'url' => 'http://www.nettuts.com')
);
echo json_encode($ads);

<?php
//-------------------------------------------------------------
// In this example, I assumed your database may look something
// like this:
//-------------------------------------------------------------
// Table: advertisements
//-------------------------------------------------------------
// state_id | county_id | image                       | url
//-------------------------------------------------------------
// 1        | 0         | florida/marion/image1.jpg   | http://www.google.com
// 1        | 0         | florida/marion/image2.jpg   | http://www.yahoo.com
// 1        | 0         | florida/marion/image3.jpg   | http://www.hotmail.com
// 2        | 0         | nc/iredell/image1.jpg       | http://www.digg.com
// 2        | 0         | nc/iredell/image2.jpg       | http://www.jquery.com
// 2        | 0         | nc/iredell/image3.jpg       | http://drupal.org
//-------------------------------------------------------------
// Note: This schema is not exactly how I would really design
// the database. Instead of having the full path to the image
// in the "image" column, I would only store the filename.
// I would then build the path out of segments stored in the
// states and counties tables. For the sake of simplicity, I am
// using a full path in the "image" column. Unfortunately, the
// simplicity means it will be more difficult to update your
// folder names in the future if you ever need to.
//
// To illustrate how I would be able to build the path from segments,
//-------------------------------------------------------------
// Table: states
//-------------------------------------------------------------
// state_id  | title          | folder
//-------------------------------------------------------------
// 1         | Florida        | florida
// 2         | North Carolina | nc
//-------------------------------------------------------------
// Table: counties
//-------------------------------------------------------------
// county_id | state_id | title        | folder
//-------------------------------------------------------------
// 1         | 1        | Marion       | marion
// 2         | 2        | Iredell      | iredell
//-------------------------------------------------------------
// Hopefully you see how it would be possible to build a path
// to an image if you know either the state_id or the county_id.
//-------------------------------------------------------------
 
// Include database config and initialize database connection.
// .............
 
// Initialize variables.
$sql_where = array();
 
/**
* This should be either state or county.
* @var string
*/
$type = strtolower($_POST['type']);
 
/**
* This should be the ID number of the state or county.
* @var int
*/
$value = $_POST['value'];
 
// Validate $value
if ($value == '') {
    exit;
}
 
// Validate $type
switch ($type) {
    case 'state':
        $sql_where[] = "state_id = '".mysql_real_escape_string($value)."'";
        break;
    case 'county':
        $sql_where[] = "county_id = '".mysql_real_escape_string($value)."'";
        break;
    default:
        // If $type is an unknown value, halt execution of the script.
        exit;
}
 
// Only get ads where the image column is not empty.
$sql_where[] = "image != ''";
 
// Turn our where array into a usable string.
$sql_where = implode(' AND ', $sql_where);
 
// Get the advertisements out of the database.
$result = mysql_query("
    SELECT
        image
        ,url
    FROM
        advertisements
    WHERE
        $sql_where
") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    $ads = array();
    while ($row = mysql_fetch_assoc($result)) {
        $ads[] = array('ad' => '/images/states/' . $row['image'], 'url' => $row['url']);
    }
 
    // Shuffle up the array so the ads are always in a random order.
    shuffle($ads);
 
    // Output the ads in json format.
    echo json_encode($ads);
}
 
// Do not go any further.
exit;
 
/**
* For sample/testing purposes, I have left this here.
* This illustrates what the array being returned to JavaScript
* should look like.
*/
$ads = array(
    array('ad' => '/images/states/state/county/gainesville1.jpg', 'url' => 'http://www.google.com'),
    array('ad' => '/images/states/state/county/gainesville2.jpg', 'url' => 'http://www.yahoo.com'),
    array('ad' => '/images/states/state/county/gainesville3.jpg', 'url' => 'http://www.hotmail.com'),
    array('ad' => '/images/states/state/county/gainesville4.jpg', 'url' => 'http://www.digg.com'),
    array('ad' => '/images/states/state/county/gainesville5.jpg', 'url' => 'http://www.devshed.com'),
    array('ad' => '/images/states/state/county/gainesville6.jpg', 'url' => 'http://www.sitepoint.com'),
    array('ad' => '/images/states/state/county/gainesville7.jpg', 'url' => 'http://www.nettuts.com')
);
echo json_encode($ads);

I think I've accommodated for everything, but again, its the end of the day and I tend to think poorly around this time of day.

#65

July 2nd, 2009, 09:52 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Thanks... I will try those out in the morning...

As for the database, I have 1 table that stores pretty much everything... so there are roughly 25 fields... 1 is logo, and 1 is website. The logo field will only store the filename (hopefully.. haven't created the upload script yet). But ideally, I was just going to have the filename there.

I was sort of picturing being able to have 'type' and 'value' from the other script you had created to build out the path for the files and such...

But as I mentioned, will try all this out in the morning... think I'm making it an early night tonight.

#66

July 3rd, 2009, 12:42 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Alright... I changed over the rel's to have the value of the id, but I may not have my db structure in such a way that this'll work properly.

Basically, here's the structure of the tree...
A user logs in and creates his listing... enters in his city, county, and state... all of this info for his item is stored in a table, 'list'..

From 'list', I have the php pulling all the info alphabetically by state, then county, then city....

Then it displays the state... county... city... item.... (of course checking for duplicates... if a duplicate exists, it doesn't print, and keeps going...)

So basically, by assigning id to rel, not every id will be used...

#67

July 3rd, 2009, 12:45 PM

simshaun

$x=104;echo chr($x++),chr($x);

Join Date: Mar 2008

Location: North Carolina

Posts: 1,658

Time spent in forums: 2 Weeks 4 Days 2 h 18 m 38 sec
Reputation Power: 1384

So your database isnt normalized. In other words, you are storing the full state, city, and county name for each item. Correct?

#68

July 3rd, 2009, 01:07 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Quote:

Originally Posted by simshaun

So your database isnt normalized. In other words, you are storing the full state, city, and county name for each item. Correct?

Nothing about my programming is normalized..

Yes... full state, city, and county are stored in same table as items.

I have a separate table for cities, counties, and states.. but this table is used for drop down boxes in their profile.... When a user logs in, they then can add the item to the db which includes name, phone, fax, state, city, county, website, etc.....

#69

July 5th, 2009, 11:07 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Alright... so after working the last couple of days on this rotating banner thing, trying your code, etc, I got 1 thing to work. I played around with the jQuery Cycle plugin again, and got it to work... in IE6. For whatever reason, it doesn't work in FF, Opera, Flock, Safari, Chrome, etc.... Not sure what the problem is, but here's what's happening.

In IE6 (I dont have 7 or 8, so havent tried those), if I click the folder tree, I have the right column rotating preset images. (I'll change code after I get this to work to reflect images from various counties, etc).

In the other browsers, if I click a folder tree item, the 1st image displays... and that's it. Nothing rotates. However, if I go direct to domain.com/yourbannerloader.php (which is the php page pushed into the right column div), then the images rotates as they should. So something is preventing the javascript from being pushed into the right column?... Initially, I thought maybe a conflict between the jquery folder tree and jquery cycle plugin.... but then I loaded all .js files together in the files, and went direct to yourbannerloader.php again, and it still worked. (dont know what this means as direct on that page, the actual folder tree isnt loaded)

Anyways... I'm confused as to what would be preventing the javascript from working in the right column, but allowing it to work on the page itself.

There are about 6 or so .js files and I can post the code from all of those or the site or whatever... just let me know what info would make things easier for you to assist with. (I'll put the site live tomorrow and post a link so you can see what exactly is going on.)

Thanks

#70

July 6th, 2009, 12:03 AM

simshaun

$x=104;echo chr($x++),chr($x);

Join Date: Mar 2008

Location: North Carolina

Posts: 1,658

Time spent in forums: 2 Weeks 4 Days 2 h 18 m 38 sec
Reputation Power: 1384

The reason your javascript probably is not working in most browsers is because javascript written in a page that is pulled via ajax is generally not executed. IE6 may just be an exception. That is why my code is designed to simply pull a list of images from the php script and let your calling page handle it.

Because you have not normalized your database, we'll have to change how the script works slightly. I'll get back to you tomorrow, or at the very latest a couple days. Mondays always suck at work.

Last edited by simshaun : July 6th, 2009 at 12:07 AM.

#71

July 6th, 2009, 09:04 AM

Onslaught

/(bb|[^b]{2})/

Join Date: Nov 2001

Location: Somewhere in the great unknown

Posts: 5,161

Time spent in forums: 5 Days 21 h 37 m 35 sec
Reputation Power: 766

Something that might help your testing out:
https://secure.xenocode.com/Browsers/

Comments on this post

hiker agrees: Thanks!

__________________
Joe

How To Ask FAQ | How To Be A Hacker | Hacker Mindset | jQuery

#72

July 6th, 2009, 10:34 AM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

Quote:

Originally Posted by simshaun

Thanks... Still no clue what normalized database means though..

Let me know any questions or info you need... or I can just set ya up with a login to phpmyadmin so you can see how my db is set up....

#73

July 6th, 2009, 10:44 AM

Onslaught

/(bb|[^b]{2})/

Join Date: Nov 2001

Location: Somewhere in the great unknown

Posts: 5,161

Time spent in forums: 5 Days 21 h 37 m 35 sec
Reputation Power: 766

typically for ajax request, you don't pull an entire page, but just a block of html.

Have the necessary javascript libraries included already on the page and call whatever necessary function calls upon the successful ajax completion.

#74

July 10th, 2009, 11:34 AM

simshaun

$x=104;echo chr($x++),chr($x);

Join Date: Mar 2008

Location: North Carolina

Posts: 1,658

Time spent in forums: 2 Weeks 4 Days 2 h 18 m 38 sec
Reputation Power: 1384

Sorry it took so long. This is untested, as I was kinda rushed to finish it. As I said before, things are little hectic here.

index.html

html Code:

Original - html Code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Uncommon Marketplace</title>
<link rel="stylesheet" href="assets/jquery.treeview.css" />
<link rel="stylesheet" href="assets/red-treeview.css" />
<link rel="stylesheet" href="assets/screen.css" />
<link rel="stylesheet" href="assets/um.css" type="text/css" />

// type and value are required arguments
		var data = {
			type: opts.type
			,value: opts.value
		};

// If a parent_state is provided, send it along as well
		if (opts.parent_state) {
			data.parent_state = opts.parent_state;
		}

$.ajax({
			type: 'post'
			,url: 'yourbannerad.php'
			,data: data
			,dataType: 'json'
			,success: function(json) {
				// Build an array from the JSON object.
				var arr = [];
				$.each(json, function(index, element) {
					arr[arr.length] = [element.ad, element.url];
				});

// Dont do anything unless there was actually data returned.
				if (arr.length > 0) {
					// Immediately display a banner.
					random_ad(arr);

// If there is more than 1 ad, start rotating them.
					if (arr.length > 1) {
						// Set the interval to rotate the ads.
						// The number is in millseconds. 1000 = 1 second, 10000 = 10 seconds, ....
						setInterval(function() { random_ad(arr); }, 10000);
					}
				} else {
					// console.log('No data.');
				}
			}
		});
	}

function random_ad(arr) {
		// Retrieve the ad_index.
		var ad_index = $ad.data('ad_index');

// Restart the rotation after we reach the last ad.
		if (ad_index == arr.length) {
			var ad_index = 0;
			$ad.data('ad_index', ad_index);
		}

// Retrieve the ad data.
		var new_image = arr[ad_index][0];
		var new_url = arr[ad_index][1];

// Finally, display the ad.
		$ad.html('<a href="' + new_url + '" target="_blank"><img src="' + new_image + '" alt="" />');
	}

$('#tree').treeview({
		collapsed: true,
		animated: 'medium',
		control: '#sidetreecontrol',
		prerendered: true,
		persist: 'location'
	});

var $hitareas = $('.hitarea');
	$hitareas.click(function() {
		var $this = $(this);
		var $anchor = $this.find('a:first');
		var rel = $anchor.attr('rel');

var segments = rel.split('|');
		var type = segments[0];
		var value = segments[1];

if (rel !== undefined && value != '') {
			// Only call updateBannerAd when the user expands the node.
			// The only way I could think of to test if the node was expanding was
			//    to look at the ul's height property and see if it was 1px.
			// I couldn't just use an if is(:hidden) condition on the ul because treeview
			//    already unhides the ul and is animating its height property by
			//    the time this function is executed.
			if ($this.parent().find('ul:first').css('height') == '1px') {
				// If the type is county, traverse the tree backwards to find the state that the county belongs to.
				if (type == 'county') {
					var $parent_anchor = $this.parents('li').find('.hitarea a:first[rel^="state|"]');
					var parent_anchor_rel = $parent_anchor.attr('rel');

var parent_anchor_segments = parent_anchor_rel.split('|');
					var parent_anchor_type = parent_anchor_segments[0];
					var parent_anchor_value = parent_anchor_segments[1];

updateBannerAd({
						type: type
						,value: value
						,parent_state: parent_anchor_value
					}); // Pass the required information to the updateBannerAd function.
				} else {
					updateBannerAd({
						type: type
						,value: value
					}); // Pass the required information to the updateBannerAd function.
				}
			}
		}
	});

$(function() {

});
</script>
<table style="width:780px;">
	<tr>
		<td width="200">
			<div id="sidetree">
				<div class="treeheader">&nbsp;</div>
				<div id="sidetreecontrol"> <a href="?#">Collapse All</a> | <a href="?#">Expand All</a> </div>
			<ul class="treeview" id="tree"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="state|Florida" onclick="return false;">Florida</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Alachua" onclick="return false;">Alachua</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Alachua" onclick="return false;">Gainesville</a></div><br /><ul style="display:none;"><li><a href="#" class="item_to_content" rel="1">Item 1</a></li><li>Item 2</li></ul></li></ul></li></ul><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Hillsborough" onclick="return false;">Hillsborough</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Tampa</a></div><br /><ul style="display:none;"><li>Item 4</li></ul></li></ul></li></ul><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Marion" onclick="return false;">Marion</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Ocala</a></div><br /><ul style="display:none;"><li>Item 3</li></ul></li></ul></li></ul></li><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Georgia</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Santa Rosa" onclick="return false;">Santa Rosa</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Gulf Breeze</a></div><br /><ul style="display:none;"><li>Item 5</li></ul></li></ul></li></ul></li></ul></div>
		</td>
		<td width="400">
		</td>
		<td width="180">
			<div id="ad"></div>
		</td>
	</tr>
</table>
</body>
</html>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Uncommon Marketplace</title>
<link rel="stylesheet" href="assets/jquery.treeview.css" />
<link rel="stylesheet" href="assets/red-treeview.css" />
<link rel="stylesheet" href="assets/screen.css" />
<link rel="stylesheet" href="assets/um.css" type="text/css" />

<script src="assets/jquery-1.3.2.min.js" type="text/javascript"></script>
<script src="assets/jquery.cookie.js" type="text/javascript"></script>
<script src="assets/jquery.treeview.js" type="text/javascript"></script>

<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />
<style type="text/css">
    *{zoom:1;}
    .treeview .hitarea{width:150px;}
</style>
</head>
<body>
<script type="text/javascript">
$(function(){
    /**
    * Declaration of updateBannerAd function.
    */
    function updateBannerAd(opts) {
        var $ad = $('#ad');
        $ad.data('ad_index', 0);

        // type and value are required arguments
        var data = {
            type: opts.type
            ,value: opts.value
        };

        // If a parent_state is provided, send it along as well
        if (opts.parent_state) {
            data.parent_state = opts.parent_state;
        }

        $.ajax({
            type: 'post'
            ,url: 'yourbannerad.php'
            ,data: data
            ,dataType: 'json'
            ,success: function(json) {
                // Build an array from the JSON object.
                var arr = [];
                $.each(json, function(index, element) {
                    arr[arr.length] = [element.ad, element.url];
                });

                // Dont do anything unless there was actually data returned.
                if (arr.length > 0) {
                    // Immediately display a banner.
                    random_ad(arr);

                    // If there is more than 1 ad, start rotating them.
                    if (arr.length > 1) {
                        // Set the interval to rotate the ads.
                        // The number is in millseconds. 1000 = 1 second, 10000 = 10 seconds, ....
                        setInterval(function() { random_ad(arr); }, 10000);
                    }
                } else {
                    // console.log('No data.');
                }
            }
        });
    }

    function random_ad(arr) {
        // Retrieve the ad_index.
        var ad_index = $ad.data('ad_index');

        // Restart the rotation after we reach the last ad.
        if (ad_index == arr.length) {
            var ad_index = 0;
            $ad.data('ad_index', ad_index);
        }

        // Retrieve the ad data.
        var new_image = arr[ad_index][0];
        var new_url = arr[ad_index][1];

        // If there is more than one element in the array, increment the ad_index so
        // the next time this function is called, the next ad is displayed.
        if (arr.length > 1) {
            var ad_index = ad_index + 1;
            $ad.data('ad_index', ad_index);
        }

        // Finally, display the ad.
        $ad.html('<a href="' + new_url + '" target="_blank"><img src="' + new_image + '" alt="" />');
    }

    $('#tree').treeview({
        collapsed: true,
        animated: 'medium',
        control: '#sidetreecontrol',
        prerendered: true,
        persist: 'location'
    });

    var $hitareas = $('.hitarea');
    $hitareas.click(function() {
        var $this = $(this);
        var $anchor = $this.find('a:first');
        var rel = $anchor.attr('rel');

        var segments = rel.split('|');
        var type = segments[0];
        var value = segments[1];

        if (rel !== undefined && value != '') {
            // Only call updateBannerAd when the user expands the node.
            // The only way I could think of to test if the node was expanding was
            //    to look at the ul's height property and see if it was 1px.
            // I couldn't just use an if is(:hidden) condition on the ul because treeview
            //    already unhides the ul and is animating its height property by
            //    the time this function is executed.
            if ($this.parent().find('ul:first').css('height') == '1px') {
                // If the type is county, traverse the tree backwards to find the state that the county belongs to.
                if (type == 'county') {
                    var $parent_anchor = $this.parents('li').find('.hitarea a:first[rel^="state|"]');
                    var parent_anchor_rel = $parent_anchor.attr('rel');

                    var parent_anchor_segments = parent_anchor_rel.split('|');
                    var parent_anchor_type = parent_anchor_segments[0];
                    var parent_anchor_value = parent_anchor_segments[1];

                    updateBannerAd({
                        type: type
                        ,value: value
                        ,parent_state: parent_anchor_value
                    }); // Pass the required information to the updateBannerAd function.
                } else {
                    updateBannerAd({
                        type: type
                        ,value: value
                    }); // Pass the required information to the updateBannerAd function.
                }
            }
        }
    });

    var $items_to_content = $("a.item_to_content");
    $items_to_content.click(function(e) {
        e.preventDefault();
        var item_id = $(this).attr('rel');
        $.ajax({
            type: 'post',
            url: 'getitemdata.php',
            data: 'item_id=' + item_id,
            success: function(msg) {
                $('.content').html(msg);
            }
        });
    });
});


$(function() {



});
</script>
<table style="width:780px;">
    <tr>
        <td width="200">
            <div id="sidetree">
                <div class="treeheader">&nbsp;</div>
                <div id="sidetreecontrol"> <a href="?#">Collapse All</a> | <a href="?#">Expand All</a> </div>
            <ul class="treeview" id="tree"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="state|Florida" onclick="return false;">Florida</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Alachua" onclick="return false;">Alachua</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Alachua" onclick="return false;">Gainesville</a></div><br /><ul style="display:none;"><li><a href="#" class="item_to_content" rel="1">Item 1</a></li><li>Item 2</li></ul></li></ul></li></ul><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Hillsborough" onclick="return false;">Hillsborough</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Tampa</a></div><br /><ul style="display:none;"><li>Item 4</li></ul></li></ul></li></ul><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Marion" onclick="return false;">Marion</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Ocala</a></div><br /><ul style="display:none;"><li>Item 3</li></ul></li></ul></li></ul></li><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Georgia</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" rel="county|Santa Rosa" onclick="return false;">Santa Rosa</a></div><br /><ul style="display:none;"><li class="expandable"><div class="hitarea expandable-hitarea"><a href="#" style="margin-left:20px;" onclick="return false;">Gulf Breeze</a></div><br /><ul style="display:none;"><li>Item 5</li></ul></li></ul></li></ul></li></ul></div>
        </td>
        <td width="400">
        </td>
        <td width="180">
            <div id="ad"></div>
        </td>
    </tr>
</table>
</body>
</html>

yourbannerad.php

php Code:

Original - php Code

// Include database config and initialize database connection.
// .............

// Initialize variables.
$sql_where = array();

/**
* This should be either state or county.
* @var string
*/
$type = strtolower($_POST['type']);

/**
* This should be the name of the state or county.
* @var string
*/
$value = $_POST['value'];

/**
* We must also provide the state if type is county, since
* a county with the same name may exist in another state.
*/
if ($type == 'county') {
	$parent_state = $_POST['parent_state'];
}

// Validate $value
if ($value == '') {
	exit;
}

// Validate $type
switch ($type) {
	case 'state':
		$sql_where[] = "state = '".mysql_real_escape_string($value)."'";
		break;
	case 'county':
		$sql_where[] = "county = '".mysql_real_escape_string($value)."'";
		$sql_where[] = "state = '".mysql_real_escape_string($parent_state)."'";
		break;
	default:
		// If $type is an unknown value, halt execution of the script.
		exit;
}

// Only get ads where the image column is not empty.
$sql_where[] = "image != ''";

// Turn our where array into a usable string.
$sql_where = implode(' AND ', $sql_where);

// Shuffle up the array so the ads are always in a random order.
	shuffle($ads);

// Output the ads in json format.
	echo json_encode($ads);
}

// Do not go any further.
exit;

<?php
//-------------------------------------------------------------
// In this example, I assumed your database may look something
// like this:
//-------------------------------------------------------------
// Table: advertisements
//-------------------------------------------------------------
// state_id | county_id | image                       | url
//-------------------------------------------------------------
// 1        | 0         | florida/marion/image1.jpg   | http://www.google.com
// 1        | 0         | florida/marion/image2.jpg   | http://www.yahoo.com
// 1        | 0         | florida/marion/image3.jpg   | http://www.hotmail.com
// 2        | 0         | nc/iredell/image1.jpg       | http://www.digg.com
// 2        | 0         | nc/iredell/image2.jpg       | http://www.jquery.com
// 2        | 0         | nc/iredell/image3.jpg       | http://drupal.org
//-------------------------------------------------------------
// Note: This schema is not exactly how I would really design
// the database. Instead of having the full path to the image
// in the "image" column, I would only store the filename.
// I would then build the path out of segments stored in the
// states and counties tables. For the sake of simplicity, I am
// using a full path in the "image" column. Unfortunately, the
// simplicity means it will be more difficult to update your
// folder names in the future if you ever need to.
//
// To illustrate how I would be able to build the path from segments,
//-------------------------------------------------------------
// Table: states
//-------------------------------------------------------------
// state_id  | title          | folder
//-------------------------------------------------------------
// 1         | Florida        | florida
// 2         | North Carolina | nc
//-------------------------------------------------------------
// Table: counties
//-------------------------------------------------------------
// county_id | state_id | title        | folder
//-------------------------------------------------------------
// 1         | 1        | Marion       | marion
// 2         | 2        | Iredell      | iredell
//-------------------------------------------------------------
// Hopefully you see how it would be possible to build a path
// to an image if you know either the state_id or the county_id.
//-------------------------------------------------------------
 
// Include database config and initialize database connection.
// .............
 
// Initialize variables.
$sql_where = array();
 
/**
* This should be either state or county.
* @var string
*/
$type = strtolower($_POST['type']);
 
/**
* This should be the name of the state or county.
* @var string
*/
$value = $_POST['value'];
 
/**
* We must also provide the state if type is county, since
* a county with the same name may exist in another state.
*/
if ($type == 'county') {
    $parent_state = $_POST['parent_state'];
}
 
// Validate $value
if ($value == '') {
    exit;
}
 
// Validate $type
switch ($type) {
    case 'state':
        $sql_where[] = "state = '".mysql_real_escape_string($value)."'";
        break;
    case 'county':
        $sql_where[] = "county = '".mysql_real_escape_string($value)."'";
        $sql_where[] = "state = '".mysql_real_escape_string($parent_state)."'";
        break;
    default:
        // If $type is an unknown value, halt execution of the script.
        exit;
}
 
// Only get ads where the image column is not empty.
$sql_where[] = "image != ''";
 
// Turn our where array into a usable string.
$sql_where = implode(' AND ', $sql_where);
 
// Get the advertisements out of the database.
$result = mysql_query("
    SELECT
        image
        ,url
    FROM
        advertisements
    WHERE
        $sql_where
") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    $ads = array();
    while ($row = mysql_fetch_assoc($result)) {
        $ads[] = array('ad' => '/images/states/' . $row['image'], 'url' => $row['url']);
    }
 
    // Shuffle up the array so the ads are always in a random order.
    shuffle($ads);
 
    // Output the ads in json format.
    echo json_encode($ads);
}
 
// Do not go any further.
exit;
 
/**
* For sample/testing purposes, I have left this here.
* This illustrates what the array being returned to JavaScript
* should look like.
*/
$ads = array(
    array('ad' => '/images/states/state/county/gainesville1.jpg', 'url' => 'http://www.google.com'),
    array('ad' => '/images/states/state/county/gainesville2.jpg', 'url' => 'http://www.yahoo.com'),
    array('ad' => '/images/states/state/county/gainesville3.jpg', 'url' => 'http://www.hotmail.com'),
    array('ad' => '/images/states/state/county/gainesville4.jpg', 'url' => 'http://www.digg.com'),
    array('ad' => '/images/states/state/county/gainesville5.jpg', 'url' => 'http://www.devshed.com'),
    array('ad' => '/images/states/state/county/gainesville6.jpg', 'url' => 'http://www.sitepoint.com'),
    array('ad' => '/images/states/state/county/gainesville7.jpg', 'url' => 'http://www.nettuts.com')
);
echo json_encode($ads);

Comments on this post

hiker agrees: Thanks for the help...

#75

August 2nd, 2009, 09:30 PM

hiker

They're coming to take me away

Join Date: Jan 2005

Location: Florida

Posts: 4,149

Time spent in forums: 2 Months 2 Weeks 8 h 55 m 22 sec
Reputation Power: 3178

I appreciate all the help in this thread.. I have learned some, but it's now official.. I'm stupid when it comes to this stuff... Been playing with it off and on now for the last few weeks or months or something, and it's really getting to take too long... so I'm going to post this over in the Project Help section...

Again.. I do appreciate the time you've taken, but I don't think I'll ever understand it.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Page 5 - PHP-General - $_GET using an iframe