Става въпрос за електронен дневник. Когато се даде проверка на някой ЕГН-та изписва че е невалидна контролна цифра на ЕГН-то. А такова ЕГН съществува и е вкарано в базата от данни. Не знам каква е тази проверка и къде да бутна. но мисля че трябва някъде тука:
<?php
if (isset ($_GET['id']))
{
$back = '<a href="javascript: history.go(-1)" class="admin_panel_a">Îáðàòíî</a>';
$id = $_GET['id'];
$show = mysql_fetch_array(mysql_query("SELECT * FROM students WHERE id=$id LIMIT 1"));
}
else
{
$egn = $_POST['student'];
validegn($egn);
if ($check_eroor == 1)
{
return false;
}
$show = mysql_fetch_array(mysql_query("SELECT * FROM students WHERE egn='$egn' LIMIT 1"));
}
if (! $show )
{
$type = 'Ó÷åíèê ñ òàêîâà åãí <b>íÿìà</b>. Ìîëÿ îïèòàéòå îòíîâî, èëè ñå îáúðíåòå çà ïîìîù êúì äèðåêòîðà. <a href="index.php">îáðàòíî</a>.';
ok();
}
else
{
$paralelka = $show['paralelkiid'];
$id = $show['id'];
$querysrok = mysql_fetch_array(mysql_query("SELECT * FROM srok LIMIT 1"));
$srok = $querysrok['checked'];
echo '
<div align="left" class="body">
<table cellpadding="1" cellspacing="0" border="0">
<tr>
<td align="left">
<span class="main_menu">
'.$show['ime'].' '.$show['familia'].'
</span>
</td>
<td align="right" colspan="15" widht="100%">
<span class="main_menu">'.$srok.' ñðîê</span>
</td>
';
$show2 = mysql_query("SELECT * FROM predmeti_e WHERE paralelkiid=$paralelka ORDER by id DESC");
while ($row1 = mysql_fetch_array($show2))
{
$predmeti_r1 = $row1['predmetiid'];
$show3 = mysql_query("SELECT * FROM predmeti WHERE id=$predmeti_r1 ORDER by id DESC");
while ($row2 = mysql_fetch_array($show3))
{
$predmeti_r2 = $row2['id'];
echo '
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">'.$row2['name'].'</td>
';
$show4 = mysql_query("SELECT * FROM otsenki WHERE predmetiid=$predmeti_r2 AND studentsid=$id AND srok=$srok ORDER by id DESC");
while ($row3 = mysql_fetch_array($show4))
{
$otsenka_id = $row3['id'];
$otsenka = $row3['otsenka'];
$type = $row3['izpitwane'];
echo "
<td width=\"13\">
<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\">
<tr>
<td style=\"border: 1px #90B1B0 solid;font-size:12px\" align=\"left\"><span class=\"sub_menu\"><a class=\"check\" href=\"javascript:generalWindow('include/otsenka.php?id=$otsenka_id', '200', '200')\" title='Ïîêàæè îöåíêàòà'>$otsenka</a></span></td>
</tr>
</table>
</td>
";
}
$show40 = mysql_fetch_array(mysql_query("SELECT * FROM srochni WHERE predmetid=$predmeti_r2 AND studentsid=$id AND srok=$srok ORDER by id DESC"));
if ($show40)
{
$sro4naa = $show40['otsenka'];
echo "<td style=\"border: 1px #dc0000 solid;font-size:12px\" align=\"left\"><b>$sro4naa</b></td>";
}
}
}
$show5 = mysql_fetch_array(mysql_query("SELECT count(*) FROM o_izwineni WHERE studentsid=$id"));
$show6 = mysql_fetch_array(mysql_query("SELECT * FROM o_neizwineni WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show7 = mysql_fetch_array(mysql_query("SELECT * FROM zakysneniq WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show8 = mysql_fetch_array(mysql_query("SELECT * FROM error WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show9 = mysql_fetch_array(mysql_query("SELECT count(*) FROM zabelevki WHERE studentsid=$id"));
if (! $show8)
$error_s = "-";
else
{
if ($show8['number'] == 1)
$error_s = "1-âî";
elseif ($show8['number'] == 2)
$error_s = "2-ðî";
elseif ($show8['number'] == 3)
$error_s = "3-òî";
}
echo '
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left">
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Èçâèíåíè îòñúñòâèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$show5[0].'</td>
</table>
</div>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Íåèçâèíåíè îòñúñòâèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$show6['broj'].'</td>
</table>
</div>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Çàêúñíåíèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60"><span class="superscript">'.$show6['broj'].' / 3</span></td>
</table>
</div>
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Çàáåëåæêè</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60"><a class="check" href="javascript:generalWindow(\'include/zabelevki.php?id='.$id.'\', \'400\', \'400\')" title="Ïîêàæè Çàáåëåæêèòå">'.$show9[0].'</a></td>
</table>
</div>
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Ïðåäóïðåæäåíèÿ çà èçãîíâàíå</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$error_s.'</td>
</table>
</div>
<br />
<div align="right">'.$back.' </div>
</div>
</td>
<td align="right">
';
$select_15 = mysql_fetch_array(mysql_query("SELECT * FROM plugins WHERE en_name='gallery'"));
if ($select_15)
{
if (file_exists('students_pic/img'.$id.'_thumb.jpg'))
{
echo '<span class="sub_menu"> Ñíèìàêà íà ó÷åíèêà</span> <br />';
echo '<a href="students_pic/img'.$id.'.jpg" target="_blanc"><img src="students_pic/img'.$id.'_thumb.jpg" border="0" alt="pic"></a> ';
}
}
echo '
</td>
</tr>
</table>
';
}
?>
<?php
if (isset ($_GET['id']))
{
$back = '<a href="javascript: history.go(-1)" class="admin_panel_a">Îáðàòíî</a>';
$id = $_GET['id'];
$show = mysql_fetch_array(mysql_query("SELECT * FROM students WHERE id=$id LIMIT 1"));
}
else
{
$egn = $_POST['student'];
validegn($egn);
if ($check_eroor == 1)
{
return false;
}
$show = mysql_fetch_array(mysql_query("SELECT * FROM students WHERE egn='$egn' LIMIT 1"));
}
if (! $show )
{
$type = 'Ó÷åíèê ñ òàêîâà åãí <b>íÿìà</b>. Ìîëÿ îïèòàéòå îòíîâî, èëè ñå îáúðíåòå çà ïîìîù êúì äèðåêòîðà. <a href="index.php">îáðàòíî</a>.';
ok();
}
else
{
$paralelka = $show['paralelkiid'];
$id = $show['id'];
$querysrok = mysql_fetch_array(mysql_query("SELECT * FROM srok LIMIT 1"));
$srok = $querysrok['checked'];
echo '
<div align="left" class="body">
<table cellpadding="1" cellspacing="0" border="0">
<tr>
<td align="left">
<span class="main_menu">
'.$show['ime'].' '.$show['familia'].'
</span>
</td>
<td align="right" colspan="15" widht="100%">
<span class="main_menu">'.$srok.' ñðîê</span>
</td>
';
$show2 = mysql_query("SELECT * FROM predmeti_e WHERE paralelkiid=$paralelka ORDER by id DESC");
while ($row1 = mysql_fetch_array($show2))
{
$predmeti_r1 = $row1['predmetiid'];
$show3 = mysql_query("SELECT * FROM predmeti WHERE id=$predmeti_r1 ORDER by id DESC");
while ($row2 = mysql_fetch_array($show3))
{
$predmeti_r2 = $row2['id'];
echo '
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">'.$row2['name'].'</td>
';
$show4 = mysql_query("SELECT * FROM otsenki WHERE predmetiid=$predmeti_r2 AND studentsid=$id AND srok=$srok ORDER by id DESC");
while ($row3 = mysql_fetch_array($show4))
{
$otsenka_id = $row3['id'];
$otsenka = $row3['otsenka'];
$type = $row3['izpitwane'];
echo "
<td width=\"13\">
<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\">
<tr>
<td style=\"border: 1px #90B1B0 solid;font-size:12px\" align=\"left\"><span class=\"sub_menu\"><a class=\"check\" href=\"javascript:generalWindow('include/otsenka.php?id=$otsenka_id', '200', '200')\" title='Ïîêàæè îöåíêàòà'>$otsenka</a></span></td>
</tr>
</table>
</td>
";
}
$show40 = mysql_fetch_array(mysql_query("SELECT * FROM srochni WHERE predmetid=$predmeti_r2 AND studentsid=$id AND srok=$srok ORDER by id DESC"));
if ($show40)
{
$sro4naa = $show40['otsenka'];
echo "<td style=\"border: 1px #dc0000 solid;font-size:12px\" align=\"left\"><b>$sro4naa</b></td>";
}
}
}
$show5 = mysql_fetch_array(mysql_query("SELECT count(*) FROM o_izwineni WHERE studentsid=$id"));
$show6 = mysql_fetch_array(mysql_query("SELECT * FROM o_neizwineni WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show7 = mysql_fetch_array(mysql_query("SELECT * FROM zakysneniq WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show8 = mysql_fetch_array(mysql_query("SELECT * FROM error WHERE studentsid=$id ORDER by id DESC LIMIT 1"));
$show9 = mysql_fetch_array(mysql_query("SELECT count(*) FROM zabelevki WHERE studentsid=$id"));
if (! $show8)
$error_s = "-";
else
{
if ($show8['number'] == 1)
$error_s = "1-âî";
elseif ($show8['number'] == 2)
$error_s = "2-ðî";
elseif ($show8['number'] == 3)
$error_s = "3-òî";
}
echo '
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left">
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Èçâèíåíè îòñúñòâèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$show5[0].'</td>
</table>
</div>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Íåèçâèíåíè îòñúñòâèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$show6['broj'].'</td>
</table>
</div>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Çàêúñíåíèÿ</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60"><span class="superscript">'.$show6['broj'].' / 3</span></td>
</table>
</div>
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Çàáåëåæêè</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60"><a class="check" href="javascript:generalWindow(\'include/zabelevki.php?id='.$id.'\', \'400\', \'400\')" title="Ïîêàæè Çàáåëåæêèòå">'.$show9[0].'</a></td>
</table>
</div>
<div align="left">
<br /><br />
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td style="border: 1px #90B1B0 solid;font-size:12px" align="left">Ïðåäóïðåæäåíèÿ çà èçãîíâàíå</td>
<td colspan="50" style="border: 1px #90B1B0 solid;font-size:12px" align="center" width="60">'.$error_s.'</td>
</table>
</div>
<br />
<div align="right">'.$back.' </div>
</div>
</td>
<td align="right">
';
$select_15 = mysql_fetch_array(mysql_query("SELECT * FROM plugins WHERE en_name='gallery'"));
if ($select_15)
{
if (file_exists('students_pic/img'.$id.'_thumb.jpg'))
{
echo '<span class="sub_menu"> Ñíèìàêà íà ó÷åíèêà</span> <br />';
echo '<a href="students_pic/img'.$id.'.jpg" target="_blanc"><img src="students_pic/img'.$id.'_thumb.jpg" border="0" alt="pic"></a> ';
}
}
echo '
</td>
</tr>
</table>
';
}
?>