Difference between revisions of "Edna duma"
From Ilianko
(4 intermediate revisions 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:ММС]] |
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>