if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_Recordset1 = "-1";
if (isset($_GET['searchstr2'])) {
$colname_Recordset1 = $_GET['searchstr2'];
}
mysql_select_db($database_sch, $sch);
$query_Recordset1 = sprintf("SELECT * FROM degp1 WHERE id = %s", GetSQLValueString($colname_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $sch) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$colname_Recordset2 = "-1";
if (isset($_GET['searchstr3'])) {
$colname_Recordset2 = $_GET['searchstr3'];
}
mysql_select_db($database_sch, $sch);
$query_Recordset2 = sprintf("SELECT * FROM degp2 WHERE id=%s", GetSQLValueString($colname_Recordset2, "text"));
$Recordset2 = mysql_query($query_Recordset2, $sch) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<div class ="center" >
<h1 style="display:block; color:#FF0000; text-align:center; margin:20px 0 10px 0;">درجات الطلاب في الصف الاول و الثاني الابتدائي تقديرات وليس درجات</h1>
<h1 style="display:block; color:#FF0000; text-align:center; margin:20px 0 10px 0;"><img src="dd.gif" width="200" height="200"/></h1>
<form name="form2" method="get" action="">
<div align="center" style="font-size: 18px"></div>
<div align="center" style="font-size: 18px"></div>
<p><span style="font-size: 18px"><span class="style1" style="font-weight: bold; font-size: 24px"> نتيجة أولى ابتدائي </span></span></p>
<div align="center">
<input type="submit" name="button2" id="button2" value="الدرجات">
<input name="searchstr2" type="text" id="searchstr2">
<span style="font-weight: bold">أدخل رقم الجلوس </span></div>
</form>
</form>
<table width="318" border="1" align="center">
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<tr>
<td width="172"><div align="center" style="font-weight: bold; color: #3300FF"> <?php echo $row_Recordset1['name']; ?></div></td>
<td width="130" class="style1"><div align="center" class="style5" style="font-weight: bold">الاسم</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset1['ara']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة العربية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset1['math']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">الرياضيات</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset1['eng']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة الانجليزية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset1['fra']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة الفرنسية</div></td>
</tr>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset1['reg']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">التربية الدينية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #660033"><?php echo $row_Recordset1['total']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">المجموع</div></td>
</table>
<form name="form2" method="get" action="">
</br>
<p><span style="font-size: 18px"><span class="style1" style="font-weight: bold; font-size: 24px"> نتيجة ثانية ابتدائي </span></span></p>
<div align="center">
<input type="submit" name="button2" id="button2" value="الدرجات">
<input name="searchstr3" type="text" id="searchstr3">
<span style="font-weight: bold">أدخل رقم الجلوس </span> </div>
<div align="left"></div>
</form>
</form>
<table width="318" border="1" align="center">
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<tr>
<td width="172"><div align="center" style="font-weight: bold; color: #3300FF"> <?php echo $row_Recordset2['name']; ?></div></td>
<td width="130" class="style1"><div align="center" class="style5" style="font-weight: bold">الاسم</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset2['ara']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة العربية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset2['math']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">الرياضيات</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset2['eng']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة الانجليزية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset2['fra']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">اللغة الفرنسية</div></td>
</tr>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #3300FF"><?php echo $row_Recordset2['reg']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">التربية الدينية</div></td>
</tr>
<tr>
<td><div align="center" style="font-weight: bold; color: #660033"><?php echo $row_Recordset2['total']; ?></div></td>
<td class="style1"><div align="center" class="style5" style="font-weight: bold">المجموع</div></td>
</table>
