الجداول الابتدائية




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">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;نتيجة أولى ابتدائي </span></span></p>
        <div align="center">
          <input type="submit" name="button2" id="button2" value="الدرجات">
          <input name="searchstr2" type="text" id="searchstr2">
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
          <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">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;نتيجة ثانية ابتدائي </span></span></p>
        <div align="center">
          <input type="submit" name="button2" id="button2" value="الدرجات">
          <input name="searchstr3" type="text" id="searchstr3">
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
          <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>