JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-} .
LIBYA CYBER ARMY
Logo of a company Instagram@3g86    Server : Apache
System : Linux uta-edu.server.ly 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64
User : utripoli ( 1001)
PHP Version : 7.4.33
Disable Function : NONE
Directory :  /home/utripoli/public_html/cp/student/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/utripoli/public_html/cp/student/list_session.php
<?php
// اتصال بقاعدة بيانات
require_once("../../connection/connect2.php");
$page_title = "التنزيل الالكتروني";
$page_select = "11";
require_once("include/header.php");
require_once("include/check.php");
require_once("include/locked.php");


        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_student = sprintf("SELECT * FROM students where username= %s",
                          GetSQLValueString($_SESSION['MM_student'], "text"));
        $student = $dirsa->query($query_student) or die($dirsa->error);
        $row_student = $student->fetch_assoc();
        $totalRows_student = $student->num_rows;
        
         $dirsa->select_db($database_dirsa);
        $query_student2 = sprintf("SELECT * FROM study_programs where stu_id=%s",
                          GetSQLValueString($row_users22['old_id_stu'], "int"));
        $student2 = $dirsa->query($query_student2) or die($dirsa->error);
        $row_student2 = $student2->fetch_assoc();
        $totalRows_student2 = $student2->num_rows;
        
        
          if($totalRows_student2 > 0 ) { 
              
          } else {
                  $insertGoTo = "edit_my.php";
    if (isset($_SERVER['QUERY_STRING'])) {
      $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
      $insertGoTo .= $_SERVER['QUERY_STRING'];
    }
    header(sprintf("Location: %s", $insertGoTo));
          }

            // بيانات الطالب
                $dirsa->select_db($database_dirsa);
                $query_get_co = sprintf("SELECT SUM(sessionid) as total FROM courseenrollment2 where studentid= %s",
                                  GetSQLValueString($row_users22['old_id_stu'], "int"));
                $get_co = $dirsa->query($query_get_co) or die($dirsa->error);
                $row_get_co = $get_co->fetch_assoc();
                $totalRows_get_co = $get_co->num_rows;        


                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_year = sprintf("SELECT * FROM settings where set_id=%s",
                                    GetSQLValueString(1, "int"));
        $get_year  = $dirsa->query($query_get_year) or die($dirsa->error);
        $row_get_year  = $get_year ->fetch_assoc();
        $totalRows_get_year  = $get_year ->num_rows;

        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_time = "SELECT * FROM time";
        $get_time = $dirsa->query($query_get_time) or die($dirsa->error);
        $row_get_time = $get_time->fetch_assoc();
        $totalRows_get_time = $get_time->num_rows;

                // بيانات الطالب
                $dirsa->select_db($database_dirsa);
                $query_get_dept = sprintf("SELECT * FROM department where dep_another_id=%s",
                                    GetSQLValueString($row_users22['id_section'], "int"));
                $get_dept = $dirsa->query($query_get_dept) or die($dirsa->error);
                $row_get_dept = $get_dept->fetch_assoc();
                $totalRows_get_dept = $get_dept->num_rows;





///////////////////////////////////////////////////////////////
/////////////////// جلب بيانات الفعاليات ////////////////////////////
$maxRows_activite =10;
$pageNum_activite = 0;
if (isset($_GET['pageNum_activite'])) {
$pageNum_activite = $_GET['pageNum_activite'];
}
$startRow_activite = $pageNum_activite * $maxRows_activite;


$dirsa->select_db($database_dirsa);
$query_activite = sprintf("SELECT DISTINCT subjectid, groupid FROM timetable where depid=%s",
                         GetSQLValueString($row_student2['dep_id'], "int"));
$query_limit_activite = sprintf("%s LIMIT %d, %d", $query_activite, $startRow_activite, $maxRows_activite);
$activite = $dirsa->query($query_limit_activite) or die($dirsa->error);
$row_activite = $activite->fetch_assoc();
$totalRows_activite = $activite->num_rows;



if (isset($_GET['totalRows_activite'])) {
  $totalRows_activite = $_GET['totalRows_activite'];
  } else {
  $all_activite = $dirsa->query($query_activite);
  $totalRows_activite = $all_activite->num_rows;
  }
  $totalPages_activite = ceil($totalRows_activite/$maxRows_activite)-1;


$queryString_activite = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
  if (stristr($param, "pageNum_activite") == false &&
      stristr($param, "totalRows_activite") == false) {
    array_push($newParams, $param);
  }
}
if (count($newParams) != 0) {
  $queryString_activite = "&" . htmlentities(implode("&", $newParams));
}
}

?>
<style>
    @media screen {
        #printSection {
            display: none;
        }
    }

    @media print {
        body * {
            visibility:hidden;
        }
        #printSection, #printSection * {
            visibility:visible;
        }
        #printSection {
            position:absolute;
            left:0;
            top:0;
        }
    }



</style>
     <?php if($row_get_year['set_t_on'] == "1") { ?>
    <div class="container-xxl">

    
      
      <div class="authentication-wrapper authentication-basic container-p-y">
        
      <div class="demo-inline-spacing" style="float:left;">
                        <a href="print.php"><button type="button" class="btn btn-primary"><i class='bx bx-list-ul'></i> طباعة</button></a>
                  
                      </div>
                      <?php if($_GET['showerror'] == 1) { ?>
                        <div class="alert alert-warning alert-dismissible fade show" role="alert">
              يوجد مادة أسبقية
              <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
           </div>
        <?php } else if($_GET['showerror'] == 2) { ?>
          <div class="alert alert-warning alert-dismissible fade show" role="alert">
              يوجد تعارض في التوقيت
              <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
           </div>
           <?php } ?>
      <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">الفصل الدراسي الحالي </span>&nbsp;&nbsp; </h4>

      <div class="row align-items-start">


      <div class="card text-center">

      <div class="table-responsive text-nowrap">
      <br>
  <center><h3>جدولي الدراسي </h3></center>
    <table  class="table table-bordered">
        <!--<caption>Timetable</caption>-->
        <thead class="thead-dark">
        <tr>
            <th scope="col" style="text-align:center;"><b>الأيام</b></th>
            <?php do { ?>
            <th scope="col"style="text-align:center;">
                <b><?php echo $row_get_time['timename']; ?><br><?php echo $row_get_time['totime']; ?>-<?php echo $row_get_time['fromtime']; ?></b>
            </th>
            <?php } while ($row_get_time = $get_time->fetch_assoc()); ?>
        </tr>
            </thead>
        <tr>
            <td align="center" height="50">
                <b>السبت</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
                             GetSQLValueString(1, "int"),
                            GetSQLValueString(1, "int"),
                             GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1 = $dirsa->query($query_get_timetable1) or die($dirsa->error);
        $row_get_timetable1 = $get_timetable1->fetch_assoc();
        $totalRows_get_timetable1 = $get_timetable1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1['courseid'], "int"));
                $get_subject_name = $dirsa->query($query_get_subject_name) or die($dirsa->error);
                $row_get_subject_name = $get_subject_name->fetch_assoc();
                $totalRows_get_subject_name = $get_subject_name->num_rows;  

                $dirsa->select_db($database_dirsa);
                $query_get_class = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1['roomid'], "int"));
                $get_class = $dirsa->query($query_get_class) or die($dirsa->error);
                $row_get_class = $get_class->fetch_assoc();
                $totalRows_get_class = $get_class->num_rows;  
                if($totalRows_get_timetable1 > 0) { 
               echo "<b>" . $row_get_subject_name['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class['room_name'] . ")" ."<br>";
               echo $row_get_timetable1['groupid']  ."<br>";
                }
               } while ($row_get_timetable1 = $get_timetable1->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(1, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2 = $dirsa->query($query_get_timetable2) or die($dirsa->error);
        $row_get_timetable2 = $get_timetable2->fetch_assoc();
        $totalRows_get_timetable2 = $get_timetable2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2['courseid'], "int"));
                $get_subject_name2 = $dirsa->query($query_get_subject_name2) or die($dirsa->error);
                $row_get_subject_name2 = $get_subject_name2->fetch_assoc();
                $totalRows_get_subject_name2 = $get_subject_name2->num_rows; 
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2['roomid'], "int"));
                $get_class2 = $dirsa->query($query_get_class2) or die($dirsa->error);
                $row_get_class2 = $get_class2->fetch_assoc();
                $totalRows_get_class2 = $get_class2->num_rows;  
                if($totalRows_get_timetable2  > 0) { 
               echo "<b>" . $row_get_subject_name2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2['room_name'] . ")" ."<br>";
               echo $row_get_timetable2['groupid']  ."<br>";
                }
               } while ($row_get_timetable2 = $get_timetable2->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(1, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3 = $dirsa->query($query_get_timetable3) or die($dirsa->error);
        $row_get_timetable3 = $get_timetable3->fetch_assoc();
        $totalRows_get_timetable3 = $get_timetable3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3['courseid'], "int"));
                $get_subject_name3 = $dirsa->query($query_get_subject_name3) or die($dirsa->error);
                $row_get_subject_name3 = $get_subject_name3->fetch_assoc();
                $totalRows_get_subject_name3 = $get_subject_name3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3['roomid'], "int"));
                $get_class3 = $dirsa->query($query_get_class3) or die($dirsa->error);
                $row_get_class3 = $get_class3->fetch_assoc();
                $totalRows_get_class3 = $get_class3->num_rows;  
                if($totalRows_get_timetable3 > 0) { 
               echo "<b>" . $row_get_subject_name3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3['room_name'] . ")" ."<br>";
               echo $row_get_timetable3['groupid']  ."<br>";
                }
               } while ($row_get_timetable3 = $get_timetable3->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(1, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4 = $dirsa->query($query_get_timetable4) or die($dirsa->error);
        $row_get_timetable4 = $get_timetable4->fetch_assoc();
        $totalRows_get_timetable4 = $get_timetable4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4['courseid'], "int"));
                $get_subject_name4 = $dirsa->query($query_get_subject_name4) or die($dirsa->error);
                $row_get_subject_name4 = $get_subject_name4->fetch_assoc();
                $totalRows_get_subject_name4 = $get_subject_name4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4['roomid'], "int"));
                $get_class4 = $dirsa->query($query_get_class4) or die($dirsa->error);
                $row_get_class4 = $get_class4->fetch_assoc();
                $totalRows_get_class4 = $get_class4->num_rows;  
                if($totalRows_get_timetable4 >0) {
               echo "<b>" . $row_get_subject_name4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4['room_name'] . ")" ."<br>";
               echo $row_get_timetable4['groupid']  ."<br>";
                }
               } while ($row_get_timetable4 = $get_timetable4->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(1, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5 = $dirsa->query($query_get_timetable5) or die($dirsa->error);
        $row_get_timetable5 = $get_timetable5->fetch_assoc();
        $totalRows_get_timetable5 = $get_timetable5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5['courseid'], "int"));
                $get_subject_name5 = $dirsa->query($query_get_subject_name5) or die($dirsa->error);
                $row_get_subject_name5 = $get_subject_name5->fetch_assoc();
                $totalRows_get_subject_name5 = $get_subject_name5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5['roomid'], "int"));
                $get_class5 = $dirsa->query($query_get_class5) or die($dirsa->error);
                $row_get_class5 = $get_class5->fetch_assoc();
                $totalRows_get_class5 = $get_class5->num_rows;  
                if($totalRows_get_timetable5 > 0) {
               echo "<b>" . $row_get_subject_name5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5['room_name'] . ")" ."<br>";
               echo $row_get_timetable5['groupid']  ."<br>";
              }
               } while ($row_get_timetable5 = $get_timetable5->fetch_assoc()); 
               ?></td>
        </tr>
        <tr>
            <td align="center" height="50">
                <b>الأحد</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1_1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(2, "int"),
       GetSQLValueString(1, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1_1 = $dirsa->query($query_get_timetable1_1) or die($dirsa->error);
        $row_get_timetable1_1 = $get_timetable1_1->fetch_assoc();
        $totalRows_get_timetable1_1 = $get_timetable1_1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name1_1 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1_1['courseid'], "int"));
                $get_subject_name1_1 = $dirsa->query($query_get_subject_name1_1) or die($dirsa->error);
                $row_get_subject_name1_1 = $get_subject_name1_1->fetch_assoc();
                $totalRows_get_subject_name1_1 = $get_subject_name1_1->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class1_1 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1_1['roomid'], "int"));
                $get_class1_1 = $dirsa->query($query_get_class1_1) or die($dirsa->error);
                $row_get_class1_1 = $get_class1_1->fetch_assoc();
                $totalRows_get_class1_1 = $get_class1_1->num_rows;  
                if($totalRows_get_timetable1_1 > 0) { 
               echo "<b>" . $row_get_subject_name1_1['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class1_1['room_name'] . ")" ."<br>";
               echo $row_get_timetable1_1['groupid']  ."<br>";
                }
               } while ($row_get_timetable1_1 = $get_timetable1_1->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2_1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(2, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2_1 = $dirsa->query($query_get_timetable2_1) or die($dirsa->error);
        $row_get_timetable2_1 = $get_timetable2_1->fetch_assoc();
        $totalRows_get_timetable2_1 = $get_timetable2_1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2_1 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2_1['courseid'], "int"));
                $get_subject_name2_1 = $dirsa->query($query_get_subject_name2_1) or die($dirsa->error);
                $row_get_subject_name2_1 = $get_subject_name2_1->fetch_assoc();
                $totalRows_get_subject_name2_1 = $get_subject_name2_1->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2_1 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2_1['roomid'], "int"));
                $get_class2_1 = $dirsa->query($query_get_class2_1) or die($dirsa->error);
                $row_get_class2_1 = $get_class2_1->fetch_assoc();
                $totalRows_get_class2_1 = $get_class2_1->num_rows;  
                if($totalRows_get_timetable2_1 > 0) { 
               echo "<b>" . $row_get_subject_name2_1['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2_1['room_name'] . ")" ."<br>";
               echo $row_get_timetable2_1['groupid']  ."<br>";
                }
               } while ($row_get_timetable2_1 = $get_timetable2_1->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3_1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(2, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3_1 = $dirsa->query($query_get_timetable3_1) or die($dirsa->error);
        $row_get_timetable3_1 = $get_timetable3_1->fetch_assoc();
        $totalRows_get_timetable3_1 = $get_timetable3_1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3_1 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3_1['courseid'], "int"));
                $get_subject_name3_1 = $dirsa->query($query_get_subject_name3_1) or die($dirsa->error);
                $row_get_subject_name3_1 = $get_subject_name3_1->fetch_assoc();
                $totalRows_get_subject_name3_1 = $get_subject_name3_1->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3_1 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3_1['roomid'], "int"));
                $get_class3_1 = $dirsa->query($query_get_class3_1) or die($dirsa->error);
                $row_get_class3_1 = $get_class3_1->fetch_assoc();
                $totalRows_get_class3_1 = $get_class3_1->num_rows;  
                if($totalRows_get_timetable3_1 > 0) { 
               echo "<b>" . $row_get_subject_name3_1['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3_1['room_name'] . ")" ."<br>";
               echo $row_get_timetable3_1['groupid']  ."<br>";
                }
               } while ($row_get_timetable3_1 = $get_timetable3_1->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4_1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(2, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4_1 = $dirsa->query($query_get_timetable4_1) or die($dirsa->error);
        $row_get_timetable4_1 = $get_timetable4_1->fetch_assoc();
        $totalRows_get_timetable4_1 = $get_timetable4_1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4_1 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4_1['courseid'], "int"));
                $get_subject_name4_1 = $dirsa->query($query_get_subject_name4_1) or die($dirsa->error);
                $row_get_subject_name4_1 = $get_subject_name4_1->fetch_assoc();
                $totalRows_get_subject_name4_1 = $get_subject_name4_1->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4_1 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4_1['roomid'], "int"));
                $get_class4_1 = $dirsa->query($query_get_class4_1) or die($dirsa->error);
                $row_get_class4_1 = $get_class4_1->fetch_assoc();
                $totalRows_get_class4_1 = $get_class4_1->num_rows;  
                if($totalRows_get_timetable4_1 > 0) { 
               echo "<b>" . $row_get_subject_name4_1['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4_1['room_name'] . ")" ."<br>";
               echo $row_get_timetable4_1['groupid']  ."<br>";
                }

               } while ($row_get_timetable4_1 = $get_timetable4_1->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5_1 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(2, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5_1 = $dirsa->query($query_get_timetable5_1) or die($dirsa->error);
        $row_get_timetable5_1 = $get_timetable5_1->fetch_assoc();
        $totalRows_get_timetable5_1 = $get_timetable5_1->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5_1 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5_1['courseid'], "int"));
                $get_subject_name5_1 = $dirsa->query($query_get_subject_name5_1) or die($dirsa->error);
                $row_get_subject_name5_1 = $get_subject_name5_1->fetch_assoc();
                $totalRows_get_subject_name5_1 = $get_subject_name5_1->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5_1 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5_1['roomid'], "int"));
                $get_class5_1 = $dirsa->query($query_get_class5_1) or die($dirsa->error);
                $row_get_class5_1 = $get_class5_1->fetch_assoc();
                $totalRows_get_class5_1 = $get_class5_1->num_rows;  
                if($totalRows_get_timetable5_1 > 0) { 
               echo "<b>" . $row_get_subject_name5_1['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5_1['room_name'] . ")" ."<br>";
               echo $row_get_timetable5_1['groupid']  ."<br>";
                }
               } while ($row_get_timetable5_1 = $get_timetable5_1->fetch_assoc()); 
               ?></td>
        </tr>
        <tr>
            <td align="center" height="50">
                <b>الإثنين</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1_2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(3, "int"),
       GetSQLValueString(1, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1_2 = $dirsa->query($query_get_timetable1_2) or die($dirsa->error);
        $row_get_timetable1_2 = $get_timetable1_2->fetch_assoc();
        $totalRows_get_timetable1_2 = $get_timetable1_2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name1_2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1_2['courseid'], "int"));
                $get_subject_name1_2 = $dirsa->query($query_get_subject_name1_2) or die($dirsa->error);
                $row_get_subject_name1_2 = $get_subject_name1_2->fetch_assoc();
                $totalRows_get_subject_name1_2 = $get_subject_name1_2->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class1_2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1_2['roomid'], "int"));
                $get_class1_2 = $dirsa->query($query_get_class1_2) or die($dirsa->error);
                $row_get_class1_2 = $get_class1_2->fetch_assoc();
                $totalRows_get_class1_2 = $get_class1_2->num_rows;  
                if($totalRows_get_timetable1_2 > 0) { 
               echo "<b>" . $row_get_subject_name1_2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class1_2['room_name'] . ")" ."<br>";
               echo $row_get_timetable1_2['groupid']  ."<br>";
                }
               } while ($row_get_timetable1_2 = $get_timetable1_2->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2_2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(3, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2_2 = $dirsa->query($query_get_timetable2_2) or die($dirsa->error);
        $row_get_timetable2_2 = $get_timetable2_2->fetch_assoc();
        $totalRows_get_timetable2_2 = $get_timetable2_2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2_2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2_2['courseid'], "int"));
                $get_subject_name2_2 = $dirsa->query($query_get_subject_name2_2) or die($dirsa->error);
                $row_get_subject_name2_2 = $get_subject_name2_2->fetch_assoc();
                $totalRows_get_subject_name2_2 = $get_subject_name2_2->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2_2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2_2['roomid'], "int"));
                $get_class2_2 = $dirsa->query($query_get_class2_2) or die($dirsa->error);
                $row_get_class2_2 = $get_class2_2->fetch_assoc();
                $totalRows_get_class2_2 = $get_class2_2->num_rows;  
                if($totalRows_get_timetable2_2 > 0) { 
               echo "<b>" . $row_get_subject_name2_2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2_2['room_name'] . ")" ."<br>";
               echo $row_get_timetable2_2['groupid']  ."<br>";
                }
               } while ($row_get_timetable2_2 = $get_timetable2_2->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3_2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(3, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3_2 = $dirsa->query($query_get_timetable3_2) or die($dirsa->error);
        $row_get_timetable3_2 = $get_timetable3_2->fetch_assoc();
        $totalRows_get_timetable3_2 = $get_timetable3_2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3_2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3_2['courseid'], "int"));
                $get_subject_name3_2 = $dirsa->query($query_get_subject_name3_2) or die($dirsa->error);
                $row_get_subject_name3_2 = $get_subject_name3_2->fetch_assoc();
                $totalRows_get_subject_name3_2 = $get_subject_name3_2->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3_2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3_2['roomid'], "int"));
                $get_class3_2 = $dirsa->query($query_get_class3_2) or die($dirsa->error);
                $row_get_class3_2 = $get_class3_2->fetch_assoc();
                $totalRows_get_class3_2 = $get_class3_2->num_rows;  
                if($totalRows_get_timetable3_2 > 0) { 
               echo "<b>" . $row_get_subject_name3_2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3_2['room_name'] . ")" ."<br>";
               echo $row_get_timetable3_2['groupid']  ."<br>";
                }
               } while ($row_get_timetable3_2 = $get_timetable3_2->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4_2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(3, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4_2 = $dirsa->query($query_get_timetable4_2) or die($dirsa->error);
        $row_get_timetable4_2 = $get_timetable4_2->fetch_assoc();
        $totalRows_get_timetable4_2 = $get_timetable4_2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4_2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4_2['courseid'], "int"));
                $get_subject_name4_2 = $dirsa->query($query_get_subject_name4_2) or die($dirsa->error);
                $row_get_subject_name4_2 = $get_subject_name4_2->fetch_assoc();
                $totalRows_get_subject_name4_2 = $get_subject_name4_2->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4_2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4_2['roomid'], "int"));
                $get_class4_2 = $dirsa->query($query_get_class4_2) or die($dirsa->error);
                $row_get_class4_2 = $get_class4_2->fetch_assoc();
                $totalRows_get_class4_2 = $get_class4_2->num_rows;  
                if($totalRows_get_timetable4_2 > 0) { 
               echo "<b>" . $row_get_subject_name4_2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4_2['room_name'] . ")" ."<br>";
               echo $row_get_timetable4_2['groupid']  ."<br>";
                }

               } while ($row_get_timetable4_2 = $get_timetable4_2->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5_2 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(3, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5_2 = $dirsa->query($query_get_timetable5_2) or die($dirsa->error);
        $row_get_timetable5_2 = $get_timetable5_2->fetch_assoc();
        $totalRows_get_timetable5_2 = $get_timetable5_2->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5_2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5_2['courseid'], "int"));
                $get_subject_name5_2 = $dirsa->query($query_get_subject_name5_2) or die($dirsa->error);
                $row_get_subject_name5_2 = $get_subject_name5_2->fetch_assoc();
                $totalRows_get_subject_name5_2 = $get_subject_name5_2->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5_2 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5_2['roomid'], "int"));
                $get_class5_2 = $dirsa->query($query_get_class5_2) or die($dirsa->error);
                $row_get_class5_2 = $get_class5_2->fetch_assoc();
                $totalRows_get_class5_2 = $get_class5_2->num_rows;  
                if($totalRows_get_timetable5_2 > 0) { 
               echo "<b>" . $row_get_subject_name5_2['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5_2['room_name'] . ")" ."<br>";
               echo $row_get_timetable5_2['groupid']  ."<br>";
                }
               } while ($row_get_timetable5_2 = $get_timetable5_2->fetch_assoc()); 
               ?></td>
        </tr>
        <tr>
            <td align="center" height="50">
                <b>الثلاثاء</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1_3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(4, "int"),
       GetSQLValueString(1, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1_3 = $dirsa->query($query_get_timetable1_3) or die($dirsa->error);
        $row_get_timetable1_3 = $get_timetable1_3->fetch_assoc();
        $totalRows_get_timetable1_3 = $get_timetable1_3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name1_3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1_3['courseid'], "int"));
                $get_subject_name1_3 = $dirsa->query($query_get_subject_name1_3) or die($dirsa->error);
                $row_get_subject_name1_3 = $get_subject_name1_3->fetch_assoc();
                $totalRows_get_subject_name1_3 = $get_subject_name1_3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class1_3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1_3['roomid'], "int"));
                $get_class1_3 = $dirsa->query($query_get_class1_3) or die($dirsa->error);
                $row_get_class1_3 = $get_class1_3->fetch_assoc();
                $totalRows_get_class1_3 = $get_class1_3->num_rows;  
                if($totalRows_get_timetable1_3 > 0) { 
               echo "<b>" . $row_get_subject_name1_3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class1_3['room_name'] . ")" ."<br>";
               echo $row_get_timetable1_3['groupid']  ."<br>";
                }
               } while ($row_get_timetable1_3 = $get_timetable1_3->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2_3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(4, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2_3 = $dirsa->query($query_get_timetable2_3) or die($dirsa->error);
        $row_get_timetable2_3 = $get_timetable2_3->fetch_assoc();
        $totalRows_get_timetable2_3 = $get_timetable2_3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2_3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2_3['courseid'], "int"));
                $get_subject_name2_3 = $dirsa->query($query_get_subject_name2_3) or die($dirsa->error);
                $row_get_subject_name2_3 = $get_subject_name2_3->fetch_assoc();
                $totalRows_get_subject_name2_3 = $get_subject_name2_3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2_3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2_3['roomid'], "int"));
                $get_class2_3 = $dirsa->query($query_get_class2_3) or die($dirsa->error);
                $row_get_class2_3 = $get_class2_3->fetch_assoc();
                $totalRows_get_class2_3 = $get_class2_3->num_rows;  
                if($totalRows_get_timetable2_3 > 0) { 
               echo "<b>" . $row_get_subject_name2_3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2_3['room_name'] . ")" ."<br>";
               echo $row_get_timetable2_3['groupid']  ."<br>";
                }
               } while ($row_get_timetable2_3 = $get_timetable2_3->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3_3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(4, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3_3 = $dirsa->query($query_get_timetable3_3) or die($dirsa->error);
        $row_get_timetable3_3 = $get_timetable3_3->fetch_assoc();
        $totalRows_get_timetable3_3 = $get_timetable3_3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3_3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3_3['courseid'], "int"));
                $get_subject_name3_3 = $dirsa->query($query_get_subject_name3_3) or die($dirsa->error);
                $row_get_subject_name3_3 = $get_subject_name3_3->fetch_assoc();
                $totalRows_get_subject_name3_3 = $get_subject_name3_3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3_3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3_3['roomid'], "int"));
                $get_class3_3 = $dirsa->query($query_get_class3_3) or die($dirsa->error);
                $row_get_class3_3 = $get_class3_3->fetch_assoc();
                $totalRows_get_class3_3 = $get_class3_3->num_rows;  
                if($totalRows_get_timetable3_3 > 0) { 
               echo "<b>" . $row_get_subject_name3_3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3_3['room_name'] . ")" ."<br>";
               echo $row_get_timetable3_3['groupid']  ."<br>";
                }
               } while ($row_get_timetable3_3 = $get_timetable3_3->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4_3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(4, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4_3 = $dirsa->query($query_get_timetable4_3) or die($dirsa->error);
        $row_get_timetable4_3 = $get_timetable4_3->fetch_assoc();
        $totalRows_get_timetable4_3 = $get_timetable4_3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4_3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4_3['courseid'], "int"));
                $get_subject_name4_3 = $dirsa->query($query_get_subject_name4_3) or die($dirsa->error);
                $row_get_subject_name4_3 = $get_subject_name4_3->fetch_assoc();
                $totalRows_get_subject_name4_3 = $get_subject_name4_3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4_3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4_3['roomid'], "int"));
                $get_class4_3 = $dirsa->query($query_get_class4_3) or die($dirsa->error);
                $row_get_class4_3 = $get_class4_3->fetch_assoc();
                $totalRows_get_class4_3 = $get_class4_3->num_rows;  
                if($totalRows_get_timetable4_3 > 0) { 
               echo "<b>" . $row_get_subject_name4_3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4_3['room_name'] . ")" ."<br>";
               echo $row_get_timetable4_3['groupid']  ."<br>";
                }

               } while ($row_get_timetable4_3 = $get_timetable4_3->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5_3 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(4, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5_3 = $dirsa->query($query_get_timetable5_3) or die($dirsa->error);
        $row_get_timetable5_3 = $get_timetable5_3->fetch_assoc();
        $totalRows_get_timetable5_3 = $get_timetable5_3->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5_3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5_3['courseid'], "int"));
                $get_subject_name5_3 = $dirsa->query($query_get_subject_name5_3) or die($dirsa->error);
                $row_get_subject_name5_3 = $get_subject_name5_3->fetch_assoc();
                $totalRows_get_subject_name5_3 = $get_subject_name5_3->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5_3 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5_3['roomid'], "int"));
                $get_class5_3 = $dirsa->query($query_get_class5_3) or die($dirsa->error);
                $row_get_class5_3 = $get_class5_3->fetch_assoc();
                $totalRows_get_class5_3 = $get_class5_3->num_rows;  
                if($totalRows_get_timetable5_3 > 0) { 
               echo "<b>" . $row_get_subject_name5_3['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5_3['room_name'] . ")" ."<br>";
               echo $row_get_timetable5_3['groupid']  ."<br>";
                }
               } while ($row_get_timetable5_3 = $get_timetable5_3->fetch_assoc()); 
               ?></td>
        </tr>
        <tr>
            <td align="center" height="50">
                <b>الإربعاء</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1_4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(5, "int"),
       GetSQLValueString(1, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1_4 = $dirsa->query($query_get_timetable1_4) or die($dirsa->error);
        $row_get_timetable1_4 = $get_timetable1_4->fetch_assoc();
        $totalRows_get_timetable1_4 = $get_timetable1_4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name1_4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1_4['courseid'], "int"));
                $get_subject_name1_4 = $dirsa->query($query_get_subject_name1_4) or die($dirsa->error);
                $row_get_subject_name1_4 = $get_subject_name1_4->fetch_assoc();
                $totalRows_get_subject_name1_4 = $get_subject_name1_4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class1_4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1_4['roomid'], "int"));
                $get_class1_4 = $dirsa->query($query_get_class1_4) or die($dirsa->error);
                $row_get_class1_4 = $get_class1_4->fetch_assoc();
                $totalRows_get_class1_4 = $get_class1_4->num_rows;  
                if($totalRows_get_timetable1_4 > 0) { 
               echo "<b>" . $row_get_subject_name1_4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class1_4['room_name'] . ")" ."<br>";
               echo $row_get_timetable1_4['groupid']  ."<br>";
                }
               } while ($row_get_timetable1_4 = $get_timetable1_4->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2_4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(5, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2_4 = $dirsa->query($query_get_timetable2_4) or die($dirsa->error);
        $row_get_timetable2_4 = $get_timetable2_4->fetch_assoc();
        $totalRows_get_timetable2_4 = $get_timetable2_4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2_4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2_4['courseid'], "int"));
                $get_subject_name2_4 = $dirsa->query($query_get_subject_name2_4) or die($dirsa->error);
                $row_get_subject_name2_4 = $get_subject_name2_4->fetch_assoc();
                $totalRows_get_subject_name2_4 = $get_subject_name2_4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2_4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2_4['roomid'], "int"));
                $get_class2_4 = $dirsa->query($query_get_class2_4) or die($dirsa->error);
                $row_get_class2_4 = $get_class2_4->fetch_assoc();
                $totalRows_get_class2_4 = $get_class2_4->num_rows;  
                if($totalRows_get_timetable2_4 > 0) { 
               echo "<b>" . $row_get_subject_name2_4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2_4['room_name'] . ")" ."<br>";
               echo $row_get_timetable2_4['groupid']  ."<br>";
                }
               } while ($row_get_timetable2_4 = $get_timetable2_4->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3_4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(5, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3_4 = $dirsa->query($query_get_timetable3_4) or die($dirsa->error);
        $row_get_timetable3_4 = $get_timetable3_4->fetch_assoc();
        $totalRows_get_timetable3_4 = $get_timetable3_4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3_4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3_4['courseid'], "int"));
                $get_subject_name3_4 = $dirsa->query($query_get_subject_name3_4) or die($dirsa->error);
                $row_get_subject_name3_4 = $get_subject_name3_4->fetch_assoc();
                $totalRows_get_subject_name3_4 = $get_subject_name3_4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3_4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3_4['roomid'], "int"));
                $get_class3_4 = $dirsa->query($query_get_class3_4) or die($dirsa->error);
                $row_get_class3_4 = $get_class3_4->fetch_assoc();
                $totalRows_get_class3_4 = $get_class3_4->num_rows;  
                if($totalRows_get_timetable3_4 > 0) { 
               echo "<b>" . $row_get_subject_name3_4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3_4['room_name'] . ")" ."<br>";
               echo $row_get_timetable3_4['groupid']  ."<br>";
                }
               } while ($row_get_timetable3_4 = $get_timetable3_4->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4_4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(5, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4_4 = $dirsa->query($query_get_timetable4_4) or die($dirsa->error);
        $row_get_timetable4_4 = $get_timetable4_4->fetch_assoc();
        $totalRows_get_timetable4_4 = $get_timetable4_4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4_4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4_4['courseid'], "int"));
                $get_subject_name4_4 = $dirsa->query($query_get_subject_name4_4) or die($dirsa->error);
                $row_get_subject_name4_4 = $get_subject_name4_4->fetch_assoc();
                $totalRows_get_subject_name4_4 = $get_subject_name4_4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4_4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4_4['roomid'], "int"));
                $get_class4_4 = $dirsa->query($query_get_class4_4) or die($dirsa->error);
                $row_get_class4_4 = $get_class4_4->fetch_assoc();
                $totalRows_get_class4_4 = $get_class4_4->num_rows;  
                if($totalRows_get_timetable4_4 > 0) { 
               echo "<b>" . $row_get_subject_name4_4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4_4['room_name'] . ")" ."<br>";
               echo $row_get_timetable4_4['groupid']  ."<br>";
                }

               } while ($row_get_timetable4_4 = $get_timetable4_4->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5_4 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(5, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5_4 = $dirsa->query($query_get_timetable5_4) or die($dirsa->error);
        $row_get_timetable5_4 = $get_timetable5_4->fetch_assoc();
        $totalRows_get_timetable5_4 = $get_timetable5_4->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5_4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5_4['courseid'], "int"));
                $get_subject_name5_4 = $dirsa->query($query_get_subject_name5_4) or die($dirsa->error);
                $row_get_subject_name5_4 = $get_subject_name5_4->fetch_assoc();
                $totalRows_get_subject_name5_4 = $get_subject_name5_4->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5_4 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5_4['roomid'], "int"));
                $get_class5_4 = $dirsa->query($query_get_class5_4) or die($dirsa->error);
                $row_get_class5_4 = $get_class5_4->fetch_assoc();
                $totalRows_get_class5_4 = $get_class5_4->num_rows;  
                if($totalRows_get_timetable5_4 > 0) { 
               echo "<b>" . $row_get_subject_name5_4['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5_4['room_name'] . ")" ."<br>";
               echo $row_get_timetable5_4['groupid']  ."<br>";
                }
               } while ($row_get_timetable5_4 = $get_timetable5_4->fetch_assoc()); 
               ?></td>
        </tr>
        <tr>
            <td align="center" height="50">
                <b>الخميس</b></td>
            <td align="center" height="50">
                <?php 
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable1_5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(6, "int"),
       GetSQLValueString(1, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable1_5 = $dirsa->query($query_get_timetable1_5) or die($dirsa->error);
        $row_get_timetable1_5 = $get_timetable1_5->fetch_assoc();
        $totalRows_get_timetable1_5 = $get_timetable1_5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name1_5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable1_5['courseid'], "int"));
                $get_subject_name1_5 = $dirsa->query($query_get_subject_name1_5) or die($dirsa->error);
                $row_get_subject_name1_5 = $get_subject_name1_5->fetch_assoc();
                $totalRows_get_subject_name1_5 = $get_subject_name1_5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class1_5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable1_5['roomid'], "int"));
                $get_class1_5 = $dirsa->query($query_get_class1_5) or die($dirsa->error);
                $row_get_class1_5 = $get_class1_5->fetch_assoc();
                $totalRows_get_class1_5 = $get_class1_5->num_rows;  
                if($totalRows_get_timetable1_5 > 0) { 
               echo "<b>" . $row_get_subject_name1_5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class1_5['room_name'] . ")" ."<br>";
               echo $row_get_timetable1_5['groupid']  ."<br>";
                }
               } while ($row_get_timetable1_5 = $get_timetable1_5->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50">
            <?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable2_5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(6, "int"),
       GetSQLValueString(2, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable2_5 = $dirsa->query($query_get_timetable2_5) or die($dirsa->error);
        $row_get_timetable2_5 = $get_timetable2_5->fetch_assoc();
        $totalRows_get_timetable2_5 = $get_timetable2_5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name2_5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable2_5['courseid'], "int"));
                $get_subject_name2_5 = $dirsa->query($query_get_subject_name2_5) or die($dirsa->error);
                $row_get_subject_name2_5 = $get_subject_name2_5->fetch_assoc();
                $totalRows_get_subject_name2_5 = $get_subject_name2_5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class2_5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable2_5['roomid'], "int"));
                $get_class2_5 = $dirsa->query($query_get_class2_5) or die($dirsa->error);
                $row_get_class2_5 = $get_class2_5->fetch_assoc();
                $totalRows_get_class2_5 = $get_class2_5->num_rows;  
                if($totalRows_get_timetable2_5 > 0) { 
               echo "<b>" . $row_get_subject_name2_5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class2_5['room_name'] . ")" ."<br>";
               echo $row_get_timetable2_5['groupid']  ."<br>";
                }
               } while ($row_get_timetable2_5 = $get_timetable2_5->fetch_assoc()); 
               ?>
            </td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable3_5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s and studentid=%s LIMIT 1",
        GetSQLValueString(6, "int"),
       GetSQLValueString(3, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable3_5 = $dirsa->query($query_get_timetable3_5) or die($dirsa->error);
        $row_get_timetable3_5 = $get_timetable3_5->fetch_assoc();
        $totalRows_get_timetable3_5 = $get_timetable3_5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name3_5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable3_5['courseid'], "int"));
                $get_subject_name3_5 = $dirsa->query($query_get_subject_name3_5) or die($dirsa->error);
                $row_get_subject_name3_5 = $get_subject_name3_5->fetch_assoc();
                $totalRows_get_subject_name3_5 = $get_subject_name3_5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class3_5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable3_5['roomid'], "int"));
                $get_class3_5 = $dirsa->query($query_get_class3_5) or die($dirsa->error);
                $row_get_class3_5 = $get_class3_5->fetch_assoc();
                $totalRows_get_class3_5 = $get_class3_5->num_rows;  
                if($totalRows_get_timetable3_5 > 0) { 
               echo "<b>" . $row_get_subject_name3_5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class3_5['room_name'] . ")" ."<br>";
               echo $row_get_timetable3_5['groupid']  ."<br>";
                }
               } while ($row_get_timetable3_5 = $get_timetable3_5->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable4_5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(6, "int"),
       GetSQLValueString(4, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable4_5 = $dirsa->query($query_get_timetable4_5) or die($dirsa->error);
        $row_get_timetable4_5 = $get_timetable4_5->fetch_assoc();
        $totalRows_get_timetable4_5 = $get_timetable4_5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name4_5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable4_5['courseid'], "int"));
                $get_subject_name4_5 = $dirsa->query($query_get_subject_name4_5) or die($dirsa->error);
                $row_get_subject_name4_5 = $get_subject_name4_5->fetch_assoc();
                $totalRows_get_subject_name4_5 = $get_subject_name4_5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class4_5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable4_5['roomid'], "int"));
                $get_class4_5 = $dirsa->query($query_get_class4_5) or die($dirsa->error);
                $row_get_class4_5 = $get_class4_5->fetch_assoc();
                $totalRows_get_class4_5 = $get_class4_5->num_rows;  
                if($totalRows_get_timetable4_5 > 0) { 
               echo "<b>" . $row_get_subject_name4_5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class4_5['room_name'] . ")" ."<br>";
               echo $row_get_timetable4_5['groupid']  ."<br>";
                }

               } while ($row_get_timetable4_5 = $get_timetable4_5->fetch_assoc()); 
               ?></td>
            <td align="center" height="50"><?php
                        // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_timetable5_5 = sprintf("SELECT * FROM courseenrollment3  where days=%s and time=%s  and studentid=%s LIMIT 1",
        GetSQLValueString(6, "int"),
       GetSQLValueString(5, "int"),
        GetSQLValueString($row_users22['old_id_stu'], "int"));
        $get_timetable5_5 = $dirsa->query($query_get_timetable5_5) or die($dirsa->error);
        $row_get_timetable5_5 = $get_timetable5_5->fetch_assoc();
        $totalRows_get_timetable5_5 = $get_timetable5_5->num_rows;
            
              do {
                $dirsa->select_db($database_dirsa);
                $query_get_subject_name5_5 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                     GetSQLValueString($row_get_timetable5_5['courseid'], "int"));
                $get_subject_name5_5 = $dirsa->query($query_get_subject_name5_5) or die($dirsa->error);
                $row_get_subject_name5_5 = $get_subject_name5_5->fetch_assoc();
                $totalRows_get_subject_name5_5 = $get_subject_name5_5->num_rows;  
                
                $dirsa->select_db($database_dirsa);
                $query_get_class5_5 = sprintf("SELECT * FROM room where room_id =%s",
                                     GetSQLValueString($row_get_timetable5_5['roomid'], "int"));
                $get_class5_5 = $dirsa->query($query_get_class5_5) or die($dirsa->error);
                $row_get_class5_5 = $get_class5_5->fetch_assoc();
                $totalRows_get_class5_5 = $get_class5_5->num_rows;  
                if($totalRows_get_timetable5_5 > 0) { 
               echo "<b>" . $row_get_subject_name5_5['course_name'] ."</b>" ."<br>";
               echo "(" . $row_get_class5_5['room_name'] . ")" ."<br>";
               echo $row_get_timetable5_5['groupid']  ."<br>";
                }
               } while ($row_get_timetable5_5 = $get_timetable5_5->fetch_assoc()); 
               ?></td>
        </tr>
    </table>
   </div>
   <br>
   <?php if($totalRows_activite > 0) { ?>
   <?php if($row_get_co['total'] >= $row_get_year['set_whda']) { ?>
   <div class="alert alert-danger" role="alert">
   لقد تجاوزت الحد المسموح به 
    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
   </div>
   <?php } ?>
     <?php 
     $success_check1 = 0;
     $success_check2 = 0;
     $success_check3 = 0;
     ?>
     
         <div class="table-responsive text-nowrap">
    <table class="table table-striped">
      <thead>
        <tr>
          <th>إسم المادة</th>
          <th>المتطلبات</th>
          <th></th>
        </tr>
      </thead>
      <tbody class="table-border-bottom-0">
      <?php do { ?>
        <tr>
          <td><b><?php 
           // بيانات الطالب
        $dirsa->select_db($database_dirsa);
        $query_get_co_h = sprintf("SELECT * FROM courses where id_num_local=%s", 
                               GetSQLValueString($row_activite['subjectid'], "int"));
        $get_co_h= $dirsa->query($query_get_co_h) or die($dirsa->error);
        $row_get_co_h = $get_co_h->fetch_assoc();
        $totalRows_get_co_h = $get_co_h->num_rows;
        
        
          echo $row_get_co_h['course_name']; ?></b><br>
          <hr>
          عدد الوحدات : <?php echo $row_get_co_h['credits']; ?><br>
               <?php echo $row_activite ['groupid']; ?></td>
          <?php 
          $dirsa->select_db($database_dirsa);
          $query_get_dep = sprintf("SELECT * FROM department where dep_another_id=%s",
                                   GetSQLValueString($row_activite['depid'], "int"));
          $get_dep = $dirsa->query($query_get_dep) or die($dirsa->error);
          $row_get_dep = $get_dep->fetch_assoc();
          $totalRows_get_dep = $get_dep->num_rows;

          //$row_get_dep['dep_name']; ?>
  
   
          <td style="font-wieght:bold;"><?php 
          if($row_get_co_h['course1'] > 0) { 
                    $dirsa->select_db($database_dirsa);
                    $query_get_co2 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                             GetSQLValueString($row_get_co_h['course1'], "int"));
                    $get_co2 = $dirsa->query($query_get_co2) or die($dirsa->error);
                    $row_get_co2 = $get_co2->fetch_assoc();
                    $totalRows_get_co2 = $get_co2->num_rows;
           ?>
<span class="badge bg-label-primary me-1">
          <b><?php echo $row_get_co2['course_name']; ?> </b> &nbsp;
        </span>
          <?php  } else { echo "لا يوجد"; } ?>&nbsp;  
                    <?php 
          if($row_get_co_h['course2'] > 0) { 
                    $dirsa->select_db($database_dirsa);
                    $query_get_co3 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                             GetSQLValueString($row_get_co_h['course2'], "int"));
                    $get_co3 = $dirsa->query($query_get_co3) or die($dirsa->error);
                    $row_get_co3 = $get_co3->fetch_assoc();
                    $totalRows_get_co3 = $get_co3->num_rows;
           ?>
<span class="badge bg-label-primary me-1">
          <b><?php echo $row_get_co3['course_name']; ?> </b>&nbsp;
        </span>
          <?php  } else { } ?>
                    <?php 
          if($row_get_co_h['course3'] > 0) { 
                    $dirsa->select_db($database_dirsa);
                    $query_get_co4 = sprintf("SELECT * FROM courses where id_num_local=%s",
                                             GetSQLValueString($row_get_co_h['course3'], "int"));
                    $get_co4 = $dirsa->query($query_get_co4) or die($dirsa->error);
                    $row_get_co4 = $get_co4->fetch_assoc();
                    $totalRows_get_co4 = $get_co4->num_rows;
           ?>
<span class="badge bg-label-primary me-1">
          <b><?php echo $row_get_co4['course_name']; ?> </b>&nbsp;
        </span>
          <?php  } else { } ?> </td>
          <?php 
          // التحقق من تنزيل المادة مسبقاً
                          // استجلاب بيانات المقررة المسجلة
                          $dirsa->select_db($database_dirsa);
                          $query_list_subject_d = sprintf("SELECT * FROM courseenrollment where studentid=%s and courseid=%s and dgra1 >= %s",
                                            GetSQLValueString($row_student['old_id_stu'], "int"),
                                            GetSQLValueString($row_activite['subjectid'], "int"),
                                            GetSQLValueString($row_get_subject_name['course_min_mark'], "int"));
                          $list_subject_d = $dirsa->query($query_list_subject_d) or die($dirsa->error);
                          $row_list_subject_d = $list_subject_d->fetch_assoc();
                          $totalRows_list_subject_d = $list_subject_d->num_rows;

                          $dirsa->select_db($database_dirsa);
                          $query_list_subject_d2 = sprintf("SELECT * FROM courseenrollment2 where studentid=%s and courseid=%s",
                                              GetSQLValueString($row_student['old_id_stu'], "int"),
                                            GetSQLValueString($row_activite['subjectid'], "int"));
                          $list_subject_d2 = $dirsa->query($query_list_subject_d2) or die($dirsa->error);
                          $row_list_subject_d2 = $list_subject_d2->fetch_assoc();
                          $totalRows_list_subject_d2 = $list_subject_d2->num_rows;
                          ?>
                <?php  if($totalRows_list_subject_d > 0) { ?>
                <td>تم التنزيل سابقاً <br>
                <?php } else if($totalRows_list_subject_d2 > 0) {  ?>
                <td>تم التنزيل حاليا <br>
              <a href="cancel_down_subject.php?id=<?php echo $row_activite['subjectid']; ?>">إلغاء التنزيل</a></td> <?php  } else { ?>     
          <td rowspan="2">
              <?php 
                 if($row_get_co_h['course1'] > 0) {
              $dirsa->select_db($database_dirsa);
                          $query_check1 = sprintf("SELECT * FROM courseenrollment where studentid=%s and courseid=%s and dgra1 >= %s",
                                            GetSQLValueString($row_student['old_id_stu'], "int"),
                                            GetSQLValueString($row_get_co_h['course1'], "int"),
                                            GetSQLValueString($row_get_co2['course_min_mark'], "int"));
                          $check1 = $dirsa->query($query_check1) or die($dirsa->error);
                          $row_check1 = $check1->fetch_assoc();
                          $totalRows_check1 = $check1->num_rows;
                          
                           if($totalRows_check1 > 0) {
                              $success_check1 = "1";
                          } else {
                              $success_check1 = "0";
                          }
                 } else {
                     $success_check1 = "1";
                 }
                 if($row_get_co_h['course2'] > 0) {         
                 $dirsa->select_db($database_dirsa);
                          $query_check2 = sprintf("SELECT * FROM courseenrollment where studentid=%s and courseid=%s and dgra1 >= %s",
                                            GetSQLValueString($row_student['old_id_stu'], "int"),
                                            GetSQLValueString($row_get_co_h['course2'], "int"),
                                            GetSQLValueString($row_get_co3['course_min_mark'], "int"));
                          $check2 = $dirsa->query($query_check2) or die($dirsa->error);
                          $row_check2 = $check2->fetch_assoc();
                          $totalRows_check2 = $check2->num_rows;
                          if($totalRows_check2 > 0) {
                              $success_check2 = "1";
                          } else {
                              $success_check2 = "0";
                          }
                 }
                 else {
                     $success_check2 = "1";
                 }
                 if($row_get_co_h['course3'] > 0) {
                 $dirsa->select_db($database_dirsa);
                          $query_check3 = sprintf("SELECT * FROM courseenrollment where studentid=%s and courseid=%s and dgra1 >= %s",
                                            GetSQLValueString($row_student['old_id_stu'], "int"),
                                            GetSQLValueString($row_get_co_h['course3'], "int"),
                                            GetSQLValueString($row_get_co4['course_min_mark'], "int"));
                          $check3 = $dirsa->query($query_check3) or die($dirsa->error);
                          $row_check3 = $check3->fetch_assoc();
                          $totalRows_check3 = $check3->num_rows;
                          if($totalRows_check3 > 0) {
                              $success_check3 = "1";
                          } else {
                              $success_check3 = "0";
                          }
                 } else {
                     $success_check3 = "1";
                 }
                          ?>
        <?php if($row_get_co['total'] < $row_get_year['set_whda']) { ?>
       <?php if(($success_check1 == "1") && ($success_check2 == "1") && ($success_check3 == "1") && ($totalRows_list_subject_d == 0)) { ?>
        <a href="rev_subject.php?id=<?php echo $row_activite['subjectid']; ?><?php if(!(empty($row_activite['groupid']))) { ?>&&group=<?php echo $row_activite['groupid']; } ?>"><button type="button" class="btn btn-success">تنزيل</button></a></td>
       <?php } ?>
       <?php } ?>
       </tr>          
       <tr>
           <td style="font-wieght:bold;">التوقيت</td>
         <td >
            <?php 
            if(!(empty($row_activite['groupid']))) {
          $dirsa->select_db($database_dirsa);
          $query_get_days1 = sprintf("SELECT * FROM timetable where subjectid=%s and groupid=%s",
                                   GetSQLValueString($row_activite['subjectid'], "int"),
                                   GetSQLValueString($row_activite['groupid'], "text"));
          $get_days1 = $dirsa->query($query_get_days1) or die($dirsa->error);
          $row_get_days1 = $get_days1->fetch_assoc();
          $totalRows_get_days1 = $get_days1->num_rows;
            } else {
               $dirsa->select_db($database_dirsa);
          $query_get_days1 = sprintf("SELECT * FROM timetable where subjectid=%s",
                                   GetSQLValueString($row_activite['subjectid'], "int"));
          $get_days1 = $dirsa->query($query_get_days1) or die($dirsa->error);
          $row_get_days1 = $get_days1->fetch_assoc();
          $totalRows_get_days1 = $get_days1->num_rows;  
            }
            ?>
            <?php if($totalRows_get_days1 > 0) { ?>
            <?php do { 
          $dirsa->select_db($database_dirsa);
          $query_get_time1 = sprintf("SELECT * FROM time where timeid=%s",
                                   GetSQLValueString($row_get_days1['timeco'], "int"));
          $get_time1 = $dirsa->query($query_get_time1) or die($dirsa->error);
          $row_get_time1 = $get_time1->fetch_assoc();
          $totalRows_get_time1 = $get_time1->num_rows;
              echo "&nbsp;&nbsp;";
             if($row_get_days1['day'] == "1")  { echo "السبت";} 
             else if($row_get_days1['day'] == "2") { echo "الأحد";}
            else if($row_get_days1['day'] == "3") { echo "الأثنين";} 
            else if($row_get_days1['day'] == "4") { echo "الثلاثاء"; }
            else if($row_get_days1['day'] == "5") { echo "الإربعاء";}
            else if($row_get_days1['day'] == "6") { echo "الخميس";}
              echo "//";
              echo $row_get_time1['fromtime'] . "-" . $row_get_time1['totime']; 
            } while ($row_get_days1 = $get_days1->fetch_assoc());
            } ?>
          </td>
       </tr>
       <?php } ?>
 
        <?php } while ($row_activite = $activite->fetch_assoc()); ?>
      </tbody>
    </table>
  </div>
  <?php } else {  ?>

  
  <?php } ?>
  <nav aria-label="Page navigation example">
                                <ul class="pagination justify-content-center">
                                    <?php
$start_loop = $pageNum_activite;
$difference = $totalPages_activite - $pageNum_activite;
 if($difference <= 5)
    {
     $start_loop = $totalPages_activite - 5;
    }
    $end_loop = $start_loop + 4;

    if($pageNum_activite <= $end_loop)
    {
     echo "<li class='page-item'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=".($pageNum_activite + 1)."'>>></a></li>";
     echo "<li class='page-item'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=".$totalPages_activite."'>الصفحة الأخيرة</a></li>";
    }
    for($i=$start_loop; $i<=$end_loop; $i++)
    {
        if($i == $pageNum_activite) {
            echo "<li class='page-item disabled'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=".$i."'>".$i."</a></li>";
        }
                else if($i < 0) {

        } else {
     echo "<li class='page-item'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=".$i."'>".$i."</a></li>";
                }
    }
    if($pageNum_activite > 0)
    {
     echo "<li class='page-item'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=0'>الصفحة الأولى</a></li>";
     echo "<li class='page-item'><a class='page-link' href='?". $_SERVER['QUERY_STRING'] ."&pageNum_activite=".($pageNum_activite - 1)."'><<</a></li>";
    }
   ?>
                                </ul>
                            </nav>

                  </div>

            </div>
      </div>
    </div>
 <?php } ?>
   


<!-- انتهاء شاشة الطباعة -->
    <!-- / Content -->
<script>
    document.getElementById("Print").onclick = function () {
        printElement(document.getElementById("printThis"));
    };

    function printElement(elem) {
        var domClone = elem.cloneNode(true);

        var $printSection = document.getElementById("printSection");

        if (!$printSection) {
            var $printSection = document.createElement("div");
            $printSection.id = "printSection";
            document.body.appendChild($printSection);
        }

        $printSection.innerHTML = "";
        $printSection.appendChild(domClone);
        window.print();
    }
</script>
    <!-- Core JS -->
    <!-- build:js assets/vendor/js/core.js -->
  <?php require_once("include/footer.php"); ?>

3g86 2022