/genxml.php

<?php

include("dbconfig.php");

// coment the above lines if php 5

//include("JSON.php");

//$json = new Services_JSON();

// end comment

$examp = $_REQUEST["q"]; //query number







$db = mysql_connect($dbhost, $dbuser, $dbpassword)

or die("Connection Error: " . mysql_error());



mysql_select_db($database) or die("Error conecting to db.");



switch ($examp) {

    case 1:

		

		

      	if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {

  		header("Content-type: application/xhtml+xml;charset=utf-8"); } else {

  		header("Content-type: text/xml;charset=utf-8");

		}

	  	$et = ">";

  		echo "<?xml version='1.0' encoding='utf-8'?$et\n";

	

	echo '<JSChart>';

		echo '<dataset type="pie">

			<data unit="Sistematika" value="17"/>

			<data unit="Vullneti" value="8"/>

			<data unit="Inteligjenca" value="5"/>

			<data unit="Frekuentimi i rregullt" value="5"/>

			<data unit="Aktive ne klase" value="4"/>					

		</dataset>'	;

		

	echo '<colorset>

		<color value="#33FF00"/>		

		<color value="#FFFF00"/>

		<color value="#FF3300"/>

		<color value="#FF6600"/>

		<color value="#FFCC00"/>

		</colorset>';

		

		echo ' <optionset>

		<option set="setPiePosition" value="130, 105"/>

		<option set="setTitle" value="\'Top 1 \'"/>

		<option set="setTitleColor" value="\'#ffffff\'"/>

		<option set="setTextPaddingBottom" value="20"/>

		<option set="setTitleFontSize" value="11"/>

		<option set="setTextPaddingTop" value="30"/>

		<option set="setPieRadius" value="85"/>

		<option set="setPieUnitsFontSize" value="8"/>

		<option set="setPieUnitsColor" value="\'#474747\'"/>

		<option set="setPieValuesColor" value="\'#474747\'"/>

		<option set="setPieValuesOffset" value="-10"/>

		<option set="setTitleColor" value="\'#fff\'"/>		

			

	</optionset>';

	

	echo '</JSChart>';

     

	 

	   break;

	   

	   case 2:

	   

	   	$result = mysql_query("SELECT COUNT(*) AS count FROM tbl_data ");

		$row = mysql_fetch_array($result,MYSQL_ASSOC);

		$total = $row['count'];

		

		$result = mysql_query("SELECT COUNT(*) AS count FROM tbl_data where besushme='pjo'");

		$row = mysql_fetch_array($result,MYSQL_ASSOC);

		$pjo = $row['count'];

		

		$result = mysql_query("SELECT COUNT(*) AS count FROM tbl_data where besushme='po'");

		$row = mysql_fetch_array($result,MYSQL_ASSOC);

		$po = $row['count'];

		

		

		$result = mysql_query("SELECT COUNT(*) AS count FROM tbl_data where besushme='jo'");

		$row = mysql_fetch_array($result,MYSQL_ASSOC);

		$jo = $row['count'];	

	 

	   	if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {

  		header("Content-type: application/xhtml+xml;charset=utf-8"); } else {

  		header("Content-type: text/xml;charset=utf-8");

		}

	  	$et = ">";

  		echo "<?xml version='1.0' encoding='utf-8'?$et\n";

	

	echo '<JSChart>';

		echo '<dataset type="bar">

			<data unit="Total" value="'.$total.'"/>

			<data unit="Credible" value="'.$po.'"/>

			<data unit="Half Credible" value="'.$pjo.'"/>

			<data unit="Not Credible" value="'.$jo.'"/>

		</dataset>'	;

		

		echo '<colorset>

				<color value="#6ca6d1"/>

				<color value="#71D743"/>

				<color value="#FDCB3F"/>

				<color value="#D23333"/>

			</colorset>';

	 

	echo ' <optionset>

		<option set="setAxisColor" value="\'#c6c6c6\'"/>		

		<option set="setAxisWidth" value="1"/>

		<option set="setAxisNameX" value="\'Credibility\'"/>

		<option set="setAxisNameY" value="\'\'"/>

		<option set="setAxisNameColor" value="\'#9a9a9a\'"/>

		<option set="setAxisValuesColor" value="\'#939393\'"/>

		<option set="setAxisNameFontSize" value="9"/>

		<option set="setAxisPaddingTop" value="30"/>

		<option set="setAxisPaddingLeft" value="50"/>

		<option set="setAxisPaddingBottom" value="60"/>

		<option set="setAxisValuesColor" value="\'#9C1919\'"/>

		<option set="setTextPaddingLeft" value="15"/>

		<option set="setTextPaddingBottom" value="20"/>

		<option set="setBarValuesColor" value="\'#737373\'"/>

		<option set="setBarBorderWidth" value="0"/>

		<option set="setBarSpacingRatio" value="7"/>

		<option set="setTitle" value="\'Interviewers performance\'"/>

		<option set="setTitleColor" value="\'#8E8E8E\'"/>

		<option set="setGridColor" value="\'#5D5F5D\'"/>

		<option set="setSize" value="316, 321"/>

		</optionset>';

	

	echo '</JSChart>';

										

			

	 

	   break;

	   

	   

	   case 3:

	   

	   

	   if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {

  		header("Content-type: application/xhtml+xml;charset=utf-8"); } else {

  		header("Content-type: text/xml;charset=utf-8");

		}

	  	$et = ">";

  		echo "<?xml version='1.0' encoding='utf-8'?$et\n";

	

	echo '<JSChart>';

		echo '<dataset type="pie">

			<data unit="Individ" value="31"/>

			<data unit="Parents" value="8"/>

			<data unit="Familly" value="6"/>

			<data unit="Friends" value="2"/>

								

		</dataset>'	;

		

	echo '<colorset>

		<color value="#33FF00"/>		

		<color value="#FFFF00"/>

		<color value="#FF3300"/>

		<color value="#FF6600"/>		

		</colorset>';

		

		echo ' <optionset>

		<option set="setPiePosition" value="130, 105"/>

		<option set="setTitle" value="\'Top 1 \'"/>

		<option set="setTitleColor" value="\'#ffffff\'"/>

		<option set="setTextPaddingBottom" value="20"/>

		<option set="setTitleFontSize" value="11"/>

		<option set="setTextPaddingTop" value="30"/>

		<option set="setPieRadius" value="85"/>

		<option set="setPieUnitsFontSize" value="8"/>

		<option set="setPieUnitsColor" value="\'#474747\'"/>

		<option set="setPieValuesColor" value="\'#474747\'"/>

		<option set="setPieValuesOffset" value="-10"/>

		<option set="setTitleColor" value="\'#fff\'"/>		

			

	</optionset>';

	

	echo '</JSChart>';

	   

	   

	   

	   

	   break;

        

    

}

mysql_close($db);



function Strip($value)

{

	if(get_magic_quotes_gpc() != 0)

  	{

    	if(is_array($value))  

			if ( array_is_associative($value) )

			{

				foreach( $value as $k=>$v)

					$tmp_val[$k] = stripslashes($v);

				$value = $tmp_val; 

			}				

			else  

				for($j = 0; $j < sizeof($value); $j++)

        			$value[$j] = stripslashes($value[$j]);

		else

			$value = stripslashes($value);

	}

	return $value;

}

function array_is_associative ($array)

{

    if ( is_array($array) && ! empty($array) )

    {

        for ( $iterator = count($array) - 1; $iterator; $iterator-- )

        {

            if ( ! array_key_exists($iterator, $array) ) { return true; }

        }

        return ! array_key_exists(0, $array);

    }

    return false;

}

?>