phase2.php | searchcode

/twitter/phase2.php

http://skkucogpsylab.googlecode.com/
PHP | 325 lines | 204 code | 83 blank | 38 comment | 22 complexity | 866cce8098de80a53a7b5521c2435520 MD5 | raw file

<?php 

	session_start(); 

	$counter=$_COOKIE['visittimes'];

	

	//?? ?? ??

		if (isset($counter)) {

			$counter++;

			setcookie ('visittimes',$counter);

			session_start(); 



			// ?? ?? ??

				$_SESSION['estimate2'][$_SESSION['SavedColNum']-1]=$_POST['estimate2'];

				$_SESSION['confidence2'][$_SESSION['SavedColNum']-1]=$_POST['confidence2'];

				$_SESSION['accuracy2'][$_SESSION['SavedColNum']-1]=abs($_SESSION['CorrectAnswer']-$_POST['estimate2']);

				//revision ??. ?? ??=1 ??? 0

				if ($_SESSION['estimate1'][$_SESSION['SavedColNum']-1]==$_SESSION['estimate2'][$_SESSION['SavedColNum']-1]) { $_SESSION['revision'][$_SESSION['SavedColNum']-1]=0;

				} else {

					 $_SESSION['revision'][$_SESSION['SavedColNum']-1]=1;

				}



		

		} else {



				$counter=0;

				setcookie ('visittimes',$counter);



				//? ??

				$_SESSION['cvval']=array();



		//?? ?? ??? 



			//(??)????

				$latinnum=range(1,28);

				shuffle($latinnum);



			//(advice)?? ??

				$randadvice=range(1,84);

				shuffle($randadvice);



			//??? ??

				session_start(); 

				$_SESSION['RandArray']=$latinnum;

				$_SESSION['randadvice']=$randadvice;

				

		}



		



	//?? ?? ? ??, ??

			if ($counter>27) {

				//DB ??

					$connect = mysql_connect("mysql4.hosting.paran.com","ryuskae","cau20025590");

					mysql_select_db("ryuskae_db",$connect);



				//??? ??

					$SubjectNum=$_SESSION['SubjectNum'];



				//estimate ??

					$estimate2=$_SESSION['estimate2'];

					$query="insert into estimate2 (SubjectNum) value($SubjectNum)";;

					$result=mysql_query($query,$connect);



					  foreach ($estimate2 as $key => $estimate2Value) {

						$key2str="answer".strval($key);

						$query="update estimate2 set $key2str=$estimate2[$key] where SubjectNum=$SubjectNum" ;

						$result=mysql_query($query,$connect);

					  }

						



				//accuracy ??

					$accuracy2=$_SESSION['accuracy2'];

						$query="insert into accuracy2 (SubjectNum) value($SubjectNum)";;

						$result=mysql_query($query,$connect);



						  foreach ($accuracy2 as $key => $accuracy2Value) {

							$key2str="answer".strval($key);

							$query="update accuracy2 set $key2str=$accuracy2[$key] where SubjectNum=$SubjectNum" ;

							$result=mysql_query($query,$connect);

						  }



				//confidence ??

					$confidence2=$_SESSION['confidence2'];

							$query="insert into confidence2 (SubjectNum) value($SubjectNum)";;

							$result=mysql_query($query,$connect);



							  foreach ($confidence2 as $key => $confidence2Value) {

								$key2str="answer".strval($key);

								$query="update confidence2 set $key2str=$confidence2[$key] where SubjectNum=$SubjectNum" ;

								$result=mysql_query($query,$connect);

							  }



				//revision ??

					$revision=$_SESSION['revision'];

							$query="insert into revision (SubjectNum) value($SubjectNum)";;

							$result=mysql_query($query,$connect);



							  foreach ($revision as $key => $revisionValue) {

								$key2str="answer".strval($key);

								$query="update revision set $key2str=$revision[$key] where SubjectNum=$SubjectNum" ;

								$result=mysql_query($query,$connect);

							  }



				//CV ??

					 $CV=$_SESSION['cvval'];

					$query="insert into CV (SubjectNum) value($SubjectNum)";;

					$result=mysql_query($query,$connect);



					  foreach ($CV as $key => $CVValue) {

						$key2str="answer".strval($key);

						$query="update CV set $key2str=$CV[$key] where SubjectNum=$SubjectNum" ;

						$result=mysql_query($query,$connect);

					  }

							  



				mysql_close($connect);



				echo "<meta http-equiv='refresh' content='0; url=end.php'>";

			}

	?>









<html><body background="background.jpg">





<?php

//???? ??? ??

	function standard_deviation_sample ($a)

	{

	  //variable and initializations

	  $the_standard_deviation = 0.0;

	  $the_variance = 0.0;

	  $the_mean = 0.0;

	  $the_array_sum = array_sum($a); //sum the elements

	  $number_elements = count($a); //count the number of elements



	  //calculate the mean

	  $the_mean = $the_array_sum / $number_elements;



	  //calculate the variance

	  for ($i = 0; $i < $number_elements; $i++)

	  {

		//sum the array

		$the_variance = $the_variance + ($a[$i] - $the_mean) * ($a[$i] - $the_mean);

	  }



	  $the_variance = $the_variance / ($number_elements - 1.0);



	  //calculate the standard deviation

	  $the_standard_deviation = pow( $the_variance, 0.5);



	  //return the variance

	  return $the_standard_deviation;

	}



//?? ??? ??

	function average($a){

	  return array_sum($a)/count($a) ;

	}



//????



	//DB ??		

		$connect = mysql_connect("mysql4.hosting.paran.com","ryuskae","cau20025590");

		mysql_select_db("ryuskae_db",$connect);

		$result=mysql_query("select * from list",$connect); //??

		$latin=mysql_query("select * from latin",$connect); //?????

		$advicetable=mysql_query("select*from advice",$connect); //advice

		$randadvice=$_SESSION['randadvice']; //???? ??? ??



	//?? ??

		$randq=strval($_SESSION['RandArray'][$counter]);  //???? ??

		$calllatin=mysql_result($latin,$_SESSION['SubjectNum'],$randq)-1; //????? ????? ??? ??

		$question=mysql_result($result,$calllatin,"food");

		$weight=mysql_result($result,$calllatin,"gram");

		$calories=mysql_result($result,$calllatin,"calories");

		$_SESSION['CorrectAnswer']=$calories;

		$_SESSION['SavedColNum']=$_SESSION['RandArray'][$counter];



	//???

		$a= "?? ???? ??? ???? ??? ???. <br> ? ??? ??? ?? ?? ??? 10??? ??? ???. <br><br>";

		$InitialAnswer=$_SESSION['estimate1'][$randq-1];  //?? ??



	//????

	echo "<br><br><table height=50 align=\"center\"><tr align=\"center\"><td>";

		print "$a<br></td></tr>";

		echo "<table height=100 align=\"center\" border=1><tr align=\"center\"><td>";

		echo  strval($counter+1).".$question($weight gram)<br></td></tr>";

		echo "<tr><td>";

		print "??? ?? ??? $InitialAnswer ?????.<br>";

		echo "</td></tr></table><br>";

		







//advice



	//????

		if ($randq<10) {

			echo "<table align=\"center\"><tr><td>";

			echo "             84?? ??????? ?? ? <br><font color=\"red\"><b>????</b></font>? ?? ?????.</td></tr>";

			echo "<table height=100 align=\"center\" border=1 bordercolor=\"gray\" bgcolor=\"white\"><tr><td>";

			

			//advice? ?????

			for ($i=0; $i<84; $i++){

				$OriginAdvice[$i]=mysql_result($advicetable,$i,$calllatin);

			}		

			shuffle($OriginAdvice);

			

			for ($i=0; $i<3; $i++) {

				$IDnum=$counter+$i;

				echo "<tr><td >";

				echo "<img src=\"userimage.png\" width=40></td><td width=150 valign=\"center\">";  

				echo "<b>ID#$randadvice[$IDnum]</b> <br> $OriginAdvice[$i] ???";

				echo "</td></tr>";

				$CVArray[$i]=$OriginAdvice[$i];  

			}

			

			$CVCalculation=round(standard_deviation_sample($CVArray)/average($CVArray),3);

			$CVSaveCol=$_SESSION['SavedColNum']-1;



			$_SESSION['cvval'][$CVSaveCol]=$CVCalculation;

			





	//????( ???? ??? ??? ?? ????)



		}  else { 



			//Advice, ??? ?? ??

				echo "<table align=\"center\"><tr><td align=\"center\">";

				if (18<$randq) {

				echo "84?? ?????? ? <br><font color=\"red\"><b>??? ??? ??? ???</b></font>?? ?? ?????.</td></tr>";

				} else {

					echo " 84?? ?????? ? <br><font color=\"red\"><b>??? ??? ??</b></font>?? ?? ?????.</td></tr>";

						

				}



					echo "<table height=100 align=\"center\" border=1 bordercolor=\"gray\" bgcolor=\"white\"><tr><td>";

				

				for ($i=0; $i<84; $i++) {

				

				$OriginAdvice[$i]=mysql_result($advicetable,$i,$calllatin);

				$Correlates[$i]=abs($InitialAnswer-$OriginAdvice[$i]);    

				}



			//?? ??

				asort($Correlates);

				$i=0;

				foreach ($Correlates as $key => $SortedAdvice) {

				$advice2[$i]=$key;

				$i++;

				}



			//1,5,7 Advice ??

				$advice157_0=$advice2[0];

				$advice157_1=$advice2[4];

				$advice157_2=$advice2[6];



				$advice157=array($OriginAdvice[$advice157_0],$OriginAdvice[$advice157_1],$OriginAdvice[$advice157_2]);

				

				

				//CV ??

				$CVCalculation=round(standard_deviation_sample($advice157)/average($advice157),3);

				$CVSaveCol=$_SESSION['SavedColNum']-1;

				$_SESSION['cvval'][$CVSaveCol]=$CVCalculation;

				







			//?? ??

				for ($i=0; $i<3; $i++) {

					$IDnum=$counter+$i;		

					

					if (18<$randq) {

						echo "<tr><td >";

						echo "<img src=\"userimage.png\" width=40></td><td width=150 valign=\"center\">";  

						echo "<b>ID#$randadvice[$IDnum]</b> <font color=\"gray\" size=2 >by ID#".strval(rand(100,999))."</font><br> RT: $advice157[$i] ???";

						echo "</td></tr>";

					

					} else {

						echo "<tr><td >";

						echo "<img src=\"userimage.png\" width=40></td><td width=150 valign=\"center\">";  

					print "<b>ID#$randadvice[$IDnum]</b> <br> $advice157[$i] ???";	

					echo "</td></tr>";

					}

				}

		}  

		echo "</table><br>";



mysql_close($connect);

?>



<!-- ? ?? ??? ?? -->

	<script>



	function validateThis(dataform) { 



	if (dataform.estimate2.value == "") { 

	   alert("???? ???? ?????.");

	   return false; 

	   } else if  (dataform.confidence2.value == ""){

		    alert("???? ???? ?????.");

	   return false; 

	   } else {

	   return true;

	   }



	}

	</script>



<!-- ?? ?? -->



<table height=100 align="center" border=1><th><tr><td>????</td></tr></th><tr><td valign="middle">

	<form action="phase2.php" method="post" onSubmit="return validateThis(this)"><br>

	???: <input type="text" name="estimate2" size="3" maxlength="3">Kcal<br>

	???: <input type="text" name="confidence2" size="3" maxlength="3">%<br>

	</td></tr>

	<tr align="center"><td>

	<input type="submit" value="??"><br>

	</td></tr>

	</form>



</body></html>