myitems.php

<?php 
//NOTDONE
//
// GiftWeb: PHP/PostgreSQL online Gift Registry System 
// Matthew T. Jachimstal
// Copyright (C) 2000-2008  Matthew T. Jachimstal
//
// email: matthew@jachimstal.com
//
// Snail mail: Matthew Jachimstal
//             1106 Canterbury Ct, Unit D
//             Elgin, IL 60120
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
//
//

require "./main.inc";
require "./util.php";

$s = $_COOKIE["GiftWeb_Session"];

$uid = validatesession($s);

$conn = ADONewConnection($dbtype);
$conn->PConnect($dbhost, $dbuser, $dbpass, $dbname);

startpage("myPurchases", "My Purchased items");

// doesn't need to be a function call, but we might want to do something
// further on this page in the future, and this makes expansion easier.

show_purchased_items();

function show_purchased_items()
{
	global $conn;
	global $uid;

	$sql = "SELECT DISTINCT uid FROM items WHERE purchased='$uid'";
	$result = $conn->Execute($sql);

	echo "<div id=\"mainContent\">\n";
	//echo "<div class=\"contentHead\">";
	echo "<h1>";
	echo "My Purchased Items";
	echo "</h1>";
	//echo "</div>\n";

	if ($result->RecordCount() == 0)
	{
		echo "You have not purchased any items yet.";
		echo "</div>";
		endpage(1);
		exit(0);
	}

	echo "<ul class=\"people\">\n";

	while (!$result->EOF)
	{
		$user = $result->fields["uid"];

		$sql = "SELECT * FROM users WHERE uid='$user'";
		$result2 = $conn->Execute($sql);

		$name = chop($result2->fields["last_name"]);
		$name .= ", " . chop($result2->fields["first_name"]);

		echo "<li>$name\n";

		$sql = "SELECT * FROM items WHERE uid='$user' and purchased='$uid'";
		$result3 = $conn->Execute($sql);

		echo "<ul class=\"purchases\">\n";

		while (!$result3->EOF)
		{
			$item = $result3->fields["description"];

			echo "<li>$item</li>\n";

			$result3->MoveNext();
		}
		echo "</ul>\n";
		echo "</li>\n";

		$result->MoveNext();
	}

	echo "</ul>\n";
	echo "</div>\n";

}

endpage(1);
?>