Difference between revisions of "Edna duma"
From Ilianko
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | <pre> | |
| + | |||
| + | <?php | ||
| + | |||
| + | $con = mysql_connect('localhost', 'root', '3403a'); | ||
| + | mysql_select_db("test", $con); | ||
| + | |||
| + | $tochki = 0; | ||
| + | |||
| + | if($_GET) | ||
| + | { | ||
| + | $result = mysql_query('SELECT * FROM `vyprosi` WHERE `status` = 1'); | ||
| + | while($row = mysql_fetch_assoc($result)) | ||
| + | { | ||
| + | $query = 'SELECT * FROM `otgovori` WHERE id_vyprosi='.$row['id'].' AND status = 1'; | ||
| + | $result2= mysql_query($query); | ||
| + | $otgovor = mysql_fetch_assoc($result2); | ||
| + | |||
| + | print $_GET[$row['id']].' == '.$otgovor['id'].'<br>'; | ||
| + | |||
| + | if ( $_GET[$row['id']] == $otgovor['id']) | ||
| + | { | ||
| + | $tochki++; | ||
| + | } | ||
| + | |||
| + | } | ||
| + | print $tochki; | ||
| + | exit(); | ||
| + | } | ||
| + | |||
| + | |||
| + | |||
| + | ?> | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <form name="input" action="" method="get"> | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <?php | ||
| + | |||
| + | $result = mysql_query('SELECT * FROM `vyprosi` WHERE `status` = 1 ORDER BY RAND()'); | ||
| + | |||
| + | $i=1; | ||
| + | while($row = mysql_fetch_assoc($result)) | ||
| + | { | ||
| + | |||
| + | print $i++.$row['vypros'].'<br />'; | ||
| + | |||
| + | $query = 'SELECT * FROM `otgovori` WHERE id_vyprosi='.$row['id'].' ORDER BY RAND()'; | ||
| + | |||
| + | $result2 = mysql_query($query); | ||
| + | |||
| + | |||
| + | while($row1 = mysql_fetch_assoc($result2)) | ||
| + | { | ||
| + | print '<input type="radio" name="'.$row['id'].'" value="'.$row1['id'].'" />'; | ||
| + | |||
| + | print $row1['otgovor'].'<br />'; | ||
| + | } | ||
| + | |||
| + | } | ||
| + | |||
| + | ?> | ||
| + | <input type="submit" value="Submit" /> | ||
| + | </form> | ||
| + | |||
| + | </pre> | ||
| − | |||
[[Category:ММС]] | [[Category:ММС]] | ||
Latest revision as of 15:20, 14 October 2011
<?php
$con = mysql_connect('localhost', 'root', '3403a');
mysql_select_db("test", $con);
$tochki = 0;
if($_GET)
{
$result = mysql_query('SELECT * FROM `vyprosi` WHERE `status` = 1');
while($row = mysql_fetch_assoc($result))
{
$query = 'SELECT * FROM `otgovori` WHERE id_vyprosi='.$row['id'].' AND status = 1';
$result2= mysql_query($query);
$otgovor = mysql_fetch_assoc($result2);
print $_GET[$row['id']].' == '.$otgovor['id'].'<br>';
if ( $_GET[$row['id']] == $otgovor['id'])
{
$tochki++;
}
}
print $tochki;
exit();
}
?>
<form name="input" action="" method="get">
<?php
$result = mysql_query('SELECT * FROM `vyprosi` WHERE `status` = 1 ORDER BY RAND()');
$i=1;
while($row = mysql_fetch_assoc($result))
{
print $i++.$row['vypros'].'<br />';
$query = 'SELECT * FROM `otgovori` WHERE id_vyprosi='.$row['id'].' ORDER BY RAND()';
$result2 = mysql_query($query);
while($row1 = mysql_fetch_assoc($result2))
{
print '<input type="radio" name="'.$row['id'].'" value="'.$row1['id'].'" />';
print $row1['otgovor'].'<br />';
}
}
?>
<input type="submit" value="Submit" />
</form>