<?php

    // This is a very simple data provider for the cascading dropdown
    // example. A *real* data provider would most likely connect to
    // a database, use xslt and implement some level of security.

    Header("Content-type: text/xml"); 
    // get query string params
	$filter = $_GET['filter'];

	//Connect to mysql server
	$link = @mysql_connect("localhost","root","");
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	//Select database
	$db = @mysql_select_db("dropdown");
	if(!$db) {
		die("Unable to select database");
	}
	//Create query of Faculty
	$qryDepartment = "
						SELECT dep_id, dep_name, tbl_faculty.f_id, f_name
						FROM tbl_department, tbl_faculty
						WHERE tbl_department.f_id = tbl_faculty.f_id
						AND f_name = '$filter'
					";
	$resultDepartment = mysql_query($qryDepartment);

    // build xml content for client JavaScript

	$xml = "<mxml>";
	while($department = mysql_fetch_array($resultDepartment)){	
			$fn = $department['f_name'];
			$di = $department['dep_id'];
			$xml = $xml . '<faculty name="'.$fn.'">';
			$xml = $xml . '<department id="'.$di.'">'.$department["dep_name"].'</department>';
			$xml = $xml . '</faculty>';
		}
	$xml = $xml . "</mxml>";	
    // send xml to client
	echo( $xml );
?>