/twitter/phase2.php
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>