|
| |
|
|
| |
для: odindvatri
(24.07.2012 в 12:54)
| | | кстате с помощью mysql функций желательно | |
| |
|
|
| |
|
|
| | как вывести в таблицу кол-во правильных,неправильных ответов и процент правильных?
<html>
<head>
<title>
key
</title>
</head>
<body>
<?php
function mysqlcon() {
global $db;
$db = mysql_connect ("localhost","root","");
mysql_select_db ("baza",$db) or die("Не могу подсоединиться к базе: " . mysql_error());
}
if ( (isset($_POST['submit1'])) && ($_POST['submit1'] == 'OK') ) {
$rez = $_POST['resultat'];
$num1 = $_POST['number1'];
$num2 = $_POST['number2'];
$num3 = $_POST['number3'];
$num4 = $_POST['number4'];
$znak = $_POST['znak'];
$znak2 = $_POST['znak2'];
$znak3 = $_POST['znak3'];
if ($znak == 1 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 + $num2 + $num3 + $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'+'. $num3 .'+'. $num4;
}
if ( $znak == 2 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 - $num2 - $num3 - $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'-'. $num3 .'-'. $num4;
}
if ($znak == 1 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 + $num2 + $num3 - $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'+'. $num3 .'-'. $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 + $num2 - $num3 + $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'-'. $num3 .'+'. $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 + $num2 - $num3 - $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'-'. $num3 .'-'. $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 - $num2 + $num3 + $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'+'. $num3 .'+'. $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 - $num2 + $num3 - $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'+'. $num3 .'-'. $num4;
}
if ($znak == 2 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 - $num2 - $num3 + $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'-'. $num3 .'+'. $num4;
}
if ($proverka == $rez) {
echo 'PRAVILNO';
$resultatik = 'Y';
}else {
echo 'NE PRAVILNO';
$resultatik = 'N';
}
mysqlcon();
$sqladd = "INSERT INTO mybd (`id` , `data` , `vopros` , `otvet` , `pravilno` , `resultat` ) VALUES (
NULL ,NOW(),'".$proverka2."','".$rez."','".$proverka."','".$resultatik."')";
mysql_query($sqladd);
//echo $sqladd;
$query = "SELECT * FROM mybd";
$res = mysql_query($query);
//$row = mysql_num_rows($res);
// if(!$db) exit("Ошибка");
if(mysql_num_rows($res)) {
echo '<table border=1>';
echo '<tr>';
echo "<td>id</td>";
echo "<td>data</td>";
echo "<td>vopros</td>";
echo "<td>otvet</td>";
echo "<td>pravilno</td>";
echo "<td>resultat</td>";
echo '</tr>';
while($row = mysql_fetch_array($res)) {
echo '<tr>';
echo "<td>".$row['id']."</td>";
echo "<td>".$row['data']."</td>";
echo "<td>".$row['vopros']."</td>";
echo "<td>".$row['otvet']."</td>";
echo "<td>".$row['pravilno']."</td>";
echo "<td>".$row['resultat']."</td>";
echo '</tr>';
}
echo "</table>";
}
}
$a=rand(1,20);
$b=rand(1,20);
$x=rand(1,20);
$y=rand(1,20);
$c=rand(1,2);
$q=rand(3,4);
$w=rand(5,6);
if ($c == 1) $znak = '+';
if ($c == 2) $znak = '-';
if ($q == 3) $znak2 = '+';
if ($q == 4) $znak2 = '-';
if ($w == 5) $znak3 = '+';
if ($w == 6) $znak3 = '-';
echo "<h2>$a $znak $b $znak2 $x $znak3 $y= </h2>";
?>
<form action="key.php" method="post"/>
Введите результат:
<input type="text" name="resultat" />
<input type="submit" name="submit1" value="OK"/>
<input type="hidden" name="number1" value="<?php echo $a; ?>"/>
<input type="hidden" name="number2" value="<?php echo $b; ?>"/>
<input type="hidden" name="number3" value="<?php echo $x; ?>"/>
<input type="hidden" name="number4" value="<?php echo $y; ?>"/>
<input type="hidden" name="znak" value="<?php echo $c; ?>"/>
<input type="hidden" name="znak2" value="<?php echo $q; ?>"/>
<input type="hidden" name="znak3" value="<?php echo $w; ?>"/>
</form>
</body>
</html>
<?php
?> | |
| |
|
|
|
