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/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/utripoli/public_html/cp/view_questionnaires.php
 <?php 
 // اتصال بقاعدة بيانات 
require_once("../connection/connect.php");
  $page_title = "الاستبيانات"; 
  $page_select = "4"; 
require_once("include/header.php"); 
require_once("include/check.php");
require_once("include/locked.php");


// بيانات الاقسام 

// استجلاب بيانات التخصصات
$dirsa->select_db($database_dirsa);
$query_view_question = sprintf("SELECT * FROM survey_info where survey_id=%s",
                   GetSQLValueString($_GET['id'], "int"));
$view_question = $dirsa->query($query_view_question) or die($dirsa->error);
$row_view_question = $view_question->fetch_assoc();
$totalRows_view_question = $view_question->num_rows;

// استجلاب بيانات التخصصات
$dirsa->select_db($database_dirsa);
$query_total_question = sprintf("SELECT * FROM question where survey_id=%s and is_deleted is null",
                   GetSQLValueString($row_view_question['survey_id'], "int"));
$total_question = $dirsa->query($query_total_question) or die($dirsa->error);
$row_total_question = $total_question->fetch_assoc();
$totalRows_total_question = $total_question->num_rows;

// استجلاب بيانات التخصصات
$dirsa->select_db($database_dirsa);
$query_total_answers = sprintf("SELECT * FROM survey_user where survey_id=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"));
$total_answers = $dirsa->query($query_total_answers) or die($dirsa->error);
$row_total_answers = $total_answers->fetch_assoc();
$totalRows_total_answers = $total_answers->num_rows;

// اعلى اجابة 

              $dirsa->select_db($database_dirsa);
$query_most_a_s = sprintf("SELECT answer, count(answer) as c  FROM survey_answer where survey_id=%s group by answer
order by c desc
limit 1;",
                         GetSQLValueString($row_view_question['survey_id'], "int"));
$most_a_s = $dirsa->query($query_most_a_s) or die($dirsa->error);
$row_most_a_s = $most_a_s->fetch_assoc();
$totalRows_most_a_s = $most_a->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 * FROM question where survey_id=%s and is_deleted is null order by question_id desc",
                         GetSQLValueString($row_view_question['survey_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));
}
}

 ?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/apexcharts/3.37.0/apexcharts.min.css" integrity="sha512-tJYqW5NWrT0JEkWYxrI4IK2jvT7PAiOwElIGTjALSyr8ZrilUQf+gjw2z6woWGSZqeXASyBXUr+WbtqiQgxUYg==" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <script src="https://cdn.jsdelivr.net/npm/apexcharts"></script> 
          <!-- / Navbar -->

          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->
            <div class="container-xxl flex-grow-1 container-p-y">
                                <?php   if($totalRows_view_question > 0) { ?> 
                                

            
 <div class="card invoice-preview-card">
      <div class="card-body">
        <div class="d-flex justify-content-between flex-xl-row flex-md-column flex-sm-row flex-column p-sm-3 p-0">
          <div class="mb-xl-0 mb-4">
                          <h4>رقم الاستبيان #<?php echo $row_view_question['survey_id']; ?></h4>
            <div class="d-flex svg-illustration mb-3 gap-2">
              <span class="app-brand-text demo text-body fw-bolder"><?php echo $row_view_question['survey_title']; ?></span>
            </div>
              <p class="mb-1">القسم : <?php 
              $dirsa->select_db($database_dirsa);
$query_section_h = sprintf("SELECT * FROM section where section_id=%s",
                   GetSQLValueString($row_view_question['survey_section'], "int"));
$section_h = $dirsa->query($query_section_h) or die($dirsa->error);
$row_section_h = $section_h->fetch_assoc();
$totalRows_section_h = $section_h->num_rows;

           echo   $row_section_h['section_name']; ?></p>
            <p class="mb-1"><?php echo $row_view_question['survey_des']; ?></p>

            <div class="mb-2">
              <span class="me-1">تاريخ البدء:</span>
              <span class="fw-semibold"><?php echo $row_view_question['survey_date_start'];?></span>
            </div>
            <div>
              <span class="me-1">تاريخ الانتهاء:</span>
              <span class="fw-semibold"><?php echo $row_view_question['survey_date_end'];?></span>
            </div>
                        <div>
              <span class="me-1">مجموع الاسئلة:</span>
              <span class="fw-semibold"><?php echo $totalRows_total_question; ?></span>
            </div>
                                    <div>
              <span class="me-1">إجمالي المجيبين:</span>
              <span class="fw-semibold"><?php echo $totalRows_total_answers; ?></span>
            </div>
          </div>

      <div class="card-body" style="position: relative;">
       <div id="chart" class="col-span-12 sm:col-span-6 md:col-span-4 p-2 bg-gray-900 rounded-2xl">

  </div>
    </div>
          </div>
          <a href="add_question.php?id=<?php echo $row_view_question['survey_id']; ?>">
      <button type="button" class="btn rounded-pill btn-info">إضافة سؤال</button></a>
     <div class="divider">
                        <div class="divider-text">الأسئلة</div>
                      </div>
                      <?php if($totalRows_activite > 0) { ?>
      <div class="table-responsive">
        <table class="table border-top m-0">
          <thead>
            <tr>
              <th>السؤال</th>
              <th>الأعلى الأجابة</th>
              <th>أوافق بشدة</th>
              <th>أوافق</th>
              <th>أحيانا</th>
              <th>لا أوافق</th>
              <th>لا أوافق بشدة</th>
              <th>إجراءات</th>
            </tr>
          </thead>
          <tbody>
              <?php do { ?>
            <tr>
              <td class="text-nowrap"><?php echo $row_activite['question']; ?></td>
              <td class="text-nowrap"><?php 
              $dirsa->select_db($database_dirsa);
$query_most_a = sprintf("SELECT answer, count(answer) as c  FROM survey_answer where question_id=%s group by answer
order by c desc
limit 1;",
                         GetSQLValueString($row_activite['question_id'], "int"));
$most_a = $dirsa->query($query_most_a) or die($dirsa->error);
$row_most_a = $most_a->fetch_assoc();
$totalRows_most_a = $most_a->num_rows;
              if($row_most_a['answer'] == 1) {
                  echo "أوافق بشدة";
              } else if($row_most_a['answer'] == 2) {
                  echo "أوافق";
              } else if($row_most_a['answer'] == 3) {
                  echo "أحيانا";
              } else if($row_most_a['answer'] == 4) {
                  echo "لا أوافق";
              } else if($row_most_a['answer'] == 5) {
                  echo "لا أوافق بشدة";
              } else {
                  echo "لا يوجد اجابة";
              }
              ?></td>
              <td>
<?php 
$dirsa->select_db($database_dirsa);
$query_total_answer1 = sprintf("SELECT * FROM survey_answer where question_id=%s and answer=%s",
                   GetSQLValueString($row_activite['question_id'], "int"),
                   GetSQLValueString(1, "int"));
$total_answer1 = $dirsa->query($query_total_answer1) or die($dirsa->error);
$row_total_answer1 = $total_answer1->fetch_assoc();
$totalRows_total_answer1 = $total_answer1->num_rows;
echo $totalRows_total_answer1;

?>
              </td>
              <td>
<?php 
$dirsa->select_db($database_dirsa);
$query_total_answer2 = sprintf("SELECT * FROM survey_answer where question_id=%s and answer=%s",
                   GetSQLValueString($row_activite['question_id'], "int"),
                   GetSQLValueString(2, "int"));
$total_answer2 = $dirsa->query($query_total_answer2) or die($dirsa->error);
$row_total_answer2 = $total_answer2->fetch_assoc();
$totalRows_total_answer2 = $total_answer2->num_rows;
echo $totalRows_total_answer2;

?>     
              </td>
              <td>
<?php 
$dirsa->select_db($database_dirsa);
$query_total_answer3 = sprintf("SELECT * FROM survey_answer where question_id=%s and answer=%s",
                   GetSQLValueString($row_activite['question_id'], "int"),
                   GetSQLValueString(3, "int"));
$total_answer3 = $dirsa->query($query_total_answer3) or die($dirsa->error);
$row_total_answer3 = $total_answer3->fetch_assoc();
$totalRows_total_answer3 = $total_answer3->num_rows;
echo $totalRows_total_answer3;
?>    
              </td>
              <td>
<?php 
$dirsa->select_db($database_dirsa);
$query_total_answer4 = sprintf("SELECT * FROM survey_answer where question_id=%s and answer=%s",
                   GetSQLValueString($row_activite['question_id'], "int"),
                   GetSQLValueString(4, "int"));
$total_answer4 = $dirsa->query($query_total_answer4) or die($dirsa->error);
$row_total_answer4 = $total_answer4->fetch_assoc();
$totalRows_total_answer4 = $total_answer4->num_rows;
echo $totalRows_total_answer4;
?> 
              </td>
              <td>
<?php 
$dirsa->select_db($database_dirsa);
$query_total_answer5 = sprintf("SELECT * FROM survey_answer where question_id=%s and answer=%s",
                   GetSQLValueString($row_activite['question_id'], "int"),
                   GetSQLValueString(5, "int"));
$total_answer5 = $dirsa->query($query_total_answer5) or die($dirsa->error);
$row_total_answer5 = $total_answer5->fetch_assoc();
$totalRows_total_answer5 = $total_answer5->num_rows;
echo $totalRows_total_answer5;
?> 
              </td>
              <td><a href="#delete.php?id=<?php echo $row_activite['question_id']; ?>"><button type="button" class="btn rounded-pill btn-icon btn-danger"><i class='bx bx-message-square-x'></i></button></a></td>
            </tr>
             <?php } while ($row_activite = $activite->fetch_assoc()); ?>
             <tr>
                 <td>الإجمالي</td>
                 <td></td>
                 <td><?php 
                 $dirsa->select_db($database_dirsa);
$query_total_s_answer1 = sprintf("SELECT * FROM survey_answer where survey_id=%s and answer=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"),
                   GetSQLValueString(1, "int"));
$total_s_answer1 = $dirsa->query($query_total_s_answer1) or die($dirsa->error);
$row_total_s_answer1 = $total_s_answer1->fetch_assoc();
$totalRows_total_s_answer1 = $total_s_answer1->num_rows;

                 $dirsa->select_db($database_dirsa);
$query_total_s_answer2 = sprintf("SELECT * FROM survey_answer where survey_id=%s and answer=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"),
                   GetSQLValueString(2, "int"));
$total_s_answer2 = $dirsa->query($query_total_s_answer2) or die($dirsa->error);
$row_total_s_answer2 = $total_s_answer2->fetch_assoc();
$totalRows_total_s_answer2 = $total_s_answer2->num_rows;

                 $dirsa->select_db($database_dirsa);
$query_total_s_answer3 = sprintf("SELECT * FROM survey_answer where survey_id=%s and answer=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"),
                   GetSQLValueString(3, "int"));
$total_s_answer3 = $dirsa->query($query_total_s_answer3) or die($dirsa->error);
$row_total_s_answer3 = $total_s_answer3->fetch_assoc();
$totalRows_total_s_answer3 = $total_s_answer3->num_rows;

                 $dirsa->select_db($database_dirsa);
$query_total_s_answer4 = sprintf("SELECT * FROM survey_answer where survey_id=%s and answer=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"),
                   GetSQLValueString(4, "int"));
$total_s_answer4 = $dirsa->query($query_total_s_answer4) or die($dirsa->error);
$row_total_s_answer4 = $total_s_answer4->fetch_assoc();
$totalRows_total_s_answer4 = $total_s_answer4->num_rows;

                 $dirsa->select_db($database_dirsa);
$query_total_s_answer5 = sprintf("SELECT * FROM survey_answer where survey_id=%s and answer=%s",
                   GetSQLValueString($row_view_question['survey_id'], "int"),
                   GetSQLValueString(5, "int"));
$total_s_answer5 = $dirsa->query($query_total_s_answer5) or die($dirsa->error);
$row_total_s_answer5 = $total_s_answer5->fetch_assoc();
$totalRows_total_s_answer5 = $total_s_answer5->num_rows;

                 echo $total_main1 = $totalRows_total_s_answer1; ?></td>
                 <td><?php echo $total_main2 = $totalRows_total_s_answer2; ?></td>
                 <td><?php echo $total_main3 = $totalRows_total_s_answer3; ?></td>
                    <td><?php echo $total_main4 = $totalRows_total_s_answer4; ?></td>
                       <td><?php echo $total_main5 = $totalRows_total_s_answer5; ?></td>
             </tr>
             <tr>
                 <td>ناتج الضرب</td>
                 <td></td>
                 <td><?php echo $total_sub1 = $totalRows_total_s_answer1*5; ?></td>
                 <td><?php echo $total_sub2= $totalRows_total_s_answer2*4; ?></td>
                 <td><?php echo $total_sub3= $totalRows_total_s_answer3*3; ?></td>
                  <td><?php echo $total_sub4= $totalRows_total_s_answer4*2; ?></td>
                   <td><?php echo $total_sub5= $totalRows_total_s_answer5*1; ?></td>
             </tr>
               <tr>
                   <td>المتوسط الحسابي</td>
                   <td></td>
                   <td><?php $mutwsat1 = $total_sub1/$total_main1;
                   if($mutwsat1 > 0) { 
                       echo $mutwsat1; 
                   } else {
                       echo $mutwsat1 = 0;
                   }
                   ?></td>
                   <td><?php $mutwsat2 = $total_sub2/$total_main2;
                   if($mutwsat2 > 0) { 
                       echo $mutwsat2; 
                   } else {
                       echo $mutwsat2 = 0;
                   }
                   ?></td> 
                   <td><?php $mutwsat3 = $total_sub3/$total_main3;
                   if($mutwsat3 > 0) { 
                       echo $mutwsat3; 
                   } else {
                       echo $mutwsat3 = 0;
                   }
                   ?></td>
                   <td><?php $mutwsat4 = $total_sub4/$total_main4;
                   if($mutwsat4 > 0) { 
                       echo $mutwsat4; 
                   } else {
                       echo $mutwsat4 = 0;
                   }
                   ?></td>       
                   <td><?php $mutwsat5 = $total_sub5/$total_main5;
                   if($mutwsat5 > 0) { 
                       echo $mutwsat5; 
                   } else {
                       echo $mutwsat5 = 0;
                   }
                   ?></td>                   
               </tr>
          </tbody>
        </table>
        <br><br>
        <table class="table border-top m-0">
            <td>إجمالي العينة </td>
            <td>المتوسط الحسابي</td>
            <tr>
                  <td><?php echo $total_aina = $total_main1+$total_main2+$total_main3+$total_main4+$total_main5; ?></td>
                  <?php $total_drb = $total_sub1+$total_sub2+$total_sub3+$total_sub4+$total_sub5; ?>
                  <td><?php $total_all_n = $total_drb/$total_aina;
                  if($total_all_n > 0) {
                  echo $total_all_n; } else { echo $total_all_n=0; } ?> </td>
            </tr>
        </table>
      


                       </div>
                       
                                                                     <?php } else { ?>
                <center><h3>لا توجد بيانات لعرضها </h3></center>
                <?php } ?>
            </div>
                  </div>
      </div>  
      
                                                    <?php } else { ?>
                <center><h3>لا توجد بيانات لعرضها </h3></center>
                <?php } ?>
        
            <!-- / Content -->

            <!-- Footer -->
            
                <script>
        var options = {
          series: [<?php echo json_encode($total_main1);?>, <?php echo json_encode($total_main2);?>, <?php echo json_encode($total_main3);?>, <?php echo json_encode($total_main4);?>, <?php echo json_encode($total_main5);?>],
          chart: {
          width: 380,
          type: 'pie',
        },
        labels: ['أوافق بشدة', 'أوافق', 'أحيانا', 'لا أوافق', 'لا اوافق بشدة'],
        responsive: [{
          breakpoint: 480,
          options: {
            chart: {
              width: 200
            },
            legend: {
              position: 'bottom'
            }
          }
        }]
        };

        var chart = new ApexCharts(document.querySelector("#chart"), options);
        chart.render();
    </script>
<?php require_once("include/footer.php"); ?>

3g86 2022