<?php
	#
	# Sample PHP code to issue a Bugzilla query.
	# Logic, DB and Presentation lumped here for simplicity.
	#
	#
	

	# :::::PLEASE NOTE:::::
	# The bugzilla database is very large, and some long-running queries can affect the performance
	# of bugs.eclipse.org
	# We suggest you don't use these queries in "publicly accessible" web pages, or if your queries
	# are for statistical/aggregation purposes, run them once a day and post the results of the query in a static web page.
	# Queries that run for more than 5 minutes are killed by the SQL server.

	# simplisticly silly way of preventing the page from being accessed by just anybody.
	# Linking to page.php?password=abc123 obviously defeats the whole purpose of this.
	$_PASSWORD = $_GET['password'];
	$_ID = $_GET['id'];
	if($_PASSWORD == "abc123") {


		# Load up the classfile
		# You need to tell the WebMaster from which URL you are loading this class from, 
		# otherwise the connect() will fail.
		require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";
		
		# Connect to database
		$dbc 	= new DBConnectionBugs();
		$dbh 	= $dbc->connect();
	
	
		# Please note: some columns are not SELECTable, such as the password and e-mail address.
		# They will return an error.
		$sql_info = "SELECT 
							BUG.bug_id, 
							BUG.short_desc,
							USR.realname AS somedude
					FROM 
							bugs AS BUG
							INNER JOIN profiles AS USR ON USR.userid = BUG.reporter
					WHERE
							BUG.bug_id = 221560";
		
		$sql_info2 = "SELECT bugs.bug_id, bugs.short_desc FROM milestones, products, bugs 
					WHERE products.name = \"Tigerstripe\" AND products.id = milestones.product_id AND bugs.target_milestone = milestones.value";
		
		$rs 	= mysql_query($sql_info, $dbh);
		
		if(mysql_errno($dbh) > 0) {
			echo "There was an error processing this request";
			
			# For debugging purposes - don't display this stuff in a production page.
			# echo mysql_error($dbh);
			
			# Mysql disconnects automatically, but I like my disconnects to be explicit.
			$dbc->disconnect();
			exit;
		}
			
		while($myrow = mysql_fetch_assoc($rs)) {
//			echo "Bug ID: " . $myrow['bug_id'] . " Description: " . $myrow['short_desc'] . " Reporter: " . $myrow['somedude'];
			echo "Bug: " . $myrow['bug_id'] . " Name: " . $myrow['short_desc'] . "</br>";
		}
		
//		echo "ID: " . $foo[];
		
		$dbc->disconnect();
	
		$rs 		= null;
		$dbh 		= null;
		$dbc 		= null;
	}
?>